Recently, I ran into an issue after applying a few security updates and subsequent reboots: a number of the SQL services did not start successfully. After running the following script, I’ve had success with SQL services starting as expected after…
netnerds.net
information is power
Category: SQL Server
Using robocopy to move SQL Server files
When performing file migrations, PowerShell’s `Copy-Item` is not ideal. Use robocopy with these parameters instead.
Posted in PowerShell, SQL Server
T-SQL Tuesday #104: Code I Would Hate To Live Without
Today’s blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by…
Posted in PowerShell, SQL Server
Remove SQL Server Management Studio / SSMS 2016
Although I’ve been using SSMS 2017 on my demo machine for a while, I kept SSMS 2016 on my primary workstation until today. I’ve been unsure of the new look of SSMS 2017, but now that I’ve fallen in love…
Posted in SQL Server
TSQL2SDAY #101: Essential SQL Server Tools
Today’s blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by…
Posted in SQL Server
Why
This month Andy Leonard (b/t) wants to know why we do what we do. Matthew Broderick When I was a kid, I watched War Games and Ferris Bueller’s Day Off, and immediately wanted to hack. I actually got in trouble…
Posted in Linux, SQL Server
TSQL Tuesday #96: Folks Who Have Made a Difference
Today’s blog post is part of T-SQL Tuesday. T-SQL Tuesday is the brainchild of Adam Machanic. It is a monthly blog party on the second Tuesday of each month. Everyone is welcome to participate. This month’s T-SQL Tuesday, hosted by…
Posted in PowerShell, SQL Server
SQL Server / Windows OS losing connection to Domain Controllers
SSPI handshake failed with error code 0x80090311, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. No authority could be contacted for authentication.…
dbatools in a month of lunches is now available in Manning's Early Access Program 🚀
join chrissy on twitchdbatools is an awesome PowerShell module that helps you migrate entire instances with a single command, plus a whole lot more.
Available from dbatools.io and github
dbachecks validates SQL Server environments using crowdsourced DBA checklists and outputs to Power BI 📊
Available from dbachecks.io and github
Chrissy LeMaire
Tweet to @cl
Brandon Abshire
Chrissy has been awarded the Microsoft MVP for her work both in the PowerShell and SQL Server communities.
She has also been recognized as an inaugural GitHub Star.
And a Top 25 MVP by Nigel Frank.
She has also been recognized as an inaugural GitHub Star.
And a Top 25 MVP by Nigel Frank.
Recent Comments