It has been a few years since I have blogged actively, and I’ve not had much to share with the community during that time. In these recent years I have turned my focus from SQL and PowerShell (which are still awesome together of course) toward the clouds, specifically Azure and AWS (and soon perhaps GCP.) […]
Author: dave
Scripting SQL Logins, Windows Logins, group membership
I’m working with AlwaysOn Availability Groups in SQ’L 2014. One of the many interesting gotchas I have with AlwaysOn is that SQL Logins on each AG node must be created with identical SIDs, otherwise after failover the database users for those SQL Logins will be orphaned. I discovered Bill Graziano’s post back from 2010 where he scripts out […]
Installing sqlcmd without SQL Server
I just ran into a need for sqlcmd without SQL Server. I’m on Windows Server 2016 Datacenter. I installed Microsoft® ODBC Driver 11 for SQL Server – Windows, with filename msodbcsql.msi Installed from https://www.microsoft.com/en-us/download/details.aspx?id=36434 This is a dependency for Microsoft Command Line Utilities 11 for SQL Server, with filename MsSqlCmdLnUtils.msi I installed from https://www.microsoft.com/en-us/download/details.aspx?id=36433 I chose the 64-bit versions of both. […]
Set up an SMTP Replay (or smarthost) in Windows 2012 R2 with PowerShell
I just set up for our servers that need to send mail, we have a smart host relay to sendgrid. Part of the setup is done via PowerShell, part through the GUI. If you can direct me on how to configure the additional steps via PowerShell I would be keenly interested and would update this […]
Install SQL Express 2014 or 2016 from PowerShell
This may be useful for some folks out there. While the documentation on SQL Books online for command line installs is extensive, the examples there are limited, and the troubleshooting steps are not described clearly. You will need to download the SQL installer iso or files and mount or extract them, and locate the setup.exe. […]
Presenting PowerShell for the DBA, Part 2 – Objects and Tools – for the PASS DBA Virtual Chapter
Wednesday March 8, 2017 will be presenting online for the PASS DBA Virtual Chapter. The topic is PowerShell for the DBA, Part 2 – Objects and Tools If you’d like to join us, here is the attendee link! Here’s the link to part 1 of the talk, including videodownloadable scripts, and resources to learn more. Link […]
Web Deploy 3.6 installed from Web Platform Installer – Features missing
Having issues setting up Web Deploy 3.8 on IIS 7.5 for 2008R2? I feel your pain. I was installing Web Deploy 3.6 via the Web Platform Installer (WPI) onto IIS 7 on Server 2008 R2, all seemingly goes smoothly, but the interface options in IIS manager don’t show up. After much investigation, I go to […]
Presenting online for PASS DBA Virtual Chapter
I’ll be presenting on POWERSHELL FOR THE DBA to the PASS DBA Virtual Chapter Sept 28, 2016, Noon Eastern Time Abstract: This webinar introduces the SQL DBA to PowerShell and how it can be used to automate many common SQL Server tasks and monitor SQL Server metrics. You will be shown the basics of PowerShell […]
Presenting SQL and PowerShell for South Florida CodeCamp 2016
Presentation scripts and resources here at the SFCodeCamp.com presentation OneDrive under ‘SQL and PowerShell’
My first book review! SQL Server 2014 with PowerShell v5 Cookbook
Has been a very busy year for me, haven’t posted lately, but was very excited to share this. I’ve had the opportunity to be a technical reviewer for three PowerShell books this year! One that I’ve really enjoyed reviewing has just been released, and the publisher Packt is offering an end of year sale for $5 eBook […]