If you are planning on taking the Microsoft Certification Exam for 70-462, this guide provides the step-by-step instructions to completely setup your Hyper-V lab environment used in the official training kit.
Tim Smith addresses some common questions from PowerShell developers about connection strings, errors with strings, and alternative development approaches to using connection strings.
The one question about PowerShell that trips up almost everyone is about when and how to quote strings. Because PowerShell replaces the old command shell, it has to be able to work the way that it did with string parameters, but it also has to behave like a .NET scripting language to replace VBA. In this article, Michael Sorens explains the how and when of PowerShell quoting.
When cardinality estimates are incorrect, the parallel threads doing the query work are given uneven amounts of work to do. This problem can lead to a seeming explosion in CXPACKET waits occurring and is commonly called skewed parallelism; Paul Randal explains how to check for it.
Denzil Ribeiro looks at how SQL Server 2016's new Merge functionality in INDEX REORGANIZE simplifies Columnstore index maintenance significantly.
This week Steve Jones looks at the idea of combining some NoSQL concepts inside of SQL Server.
Are you a do-it-all DBA, or do you specialize in one aspect of database work?
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Is there a good syllabus for reading these two together? (Yes, it's called the...
Comments posted to this topic are about the item GPX distance and time analysis...
Comments posted to this topic are about the item The DBA is Dead; Long...
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers