SQL Server | netnerds.net

Category: SQL Server

Using robocopy to move SQL Server files

Posted on September 6, 2019 by

Chrissy LeMaire — No Comments ↓

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

Posted on July 10, 2018 by

Chrissy LeMaire — No Comments ↓

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

Posted on April 28, 2018 by

Chrissy LeMaire — No Comments ↓

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

Posted on April 10, 2018 by

Chrissy LeMaire — 1 Comment ↓

Posted in SQL Server

Why

Posted on February 12, 2018 by

Chrissy LeMaire — No Comments ↓

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

Posted on November 14, 2017 by

Chrissy LeMaire — 2 Comments ↓

Posted in PowerShell, SQL Server

SQL Server / Windows OS losing connection to Domain Controllers

Posted on May 24, 2017 by

Brandon Abshire — 5 Comments ↓

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.…

Posted in Active Directory, Security, SQL Server, Windows

SQL PowerShell Pros: Submit Your Abstracts for PASS Summit!

Posted on May 20, 2017 by

Chrissy LeMaire — No Comments ↓

Recently, PASS announced their first round of speakers for Summit 2017 speakers and I’m on the list! I’m particularly excited because Summit is the largest SQL Server event in the world and it’s looking like PowerShell will be getting some…

Posted in PowerShell, SQL Server