(Kris Wenzel) In databases a common issue is what value or placeholder do you use to represent a missing values. In SQL, this is solved with null. It is used to signify missing or unknown values.

(Kenneth Fisher) I’m sure most of you have looked at the control options of the SQL services right? Start an instance, stop an instance, pause an instance. Start, stop, pause. Wait just a minute! Is this SQL Server or an mp3?

(Rohit Garg) Sometime, We caught in a situation where we need to run SQL server in single user mode. Issues like Master DB restore, Sysadmin locked out etc.

(Pinal Dave) Earlier I wrote three blog posts on SQL Server 2014 Cardinality. Read them over here to get the context of this blog post.

(Tim Ford) Page splits occur when inserting—and in some cases updating—data in a database. If there’s not enough room to insert the new value or deal with the ramifications of the updated value of a key, then an additional page may be added to the leaf level of the index (and depending on the state

(Samuel Betts) How to setup SharePoint with SQL Server AlwaysOn has been covered nicely now, but I’ve not covered the performance hit setting up such a system will incur. The short version is: updates are about x2 slower than standalone for a x2 node AlwaysOn cluster; reading data is about the same

(Jeffery Yao) It’s a common task that DBAs need to drop SQL Server logins after a user leaves a company or some business scenario changes. Usually this is not a big task, but in a worst case scenario the SQL Server login may have database user accounts in multiple databases with roles and schemas ow

(Derik Hammer) Last week I promised a post on enabling PowerShell Remoting when we discussed automating service account password updates. So, let’s break down the two methods.

(Kenneth Fisher) The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are the best information about what a query is doing and so how to improve it.

(Chris Webb) You probably know that, when you are importing data from multiple tables in SQL Server into the Excel Data Model in Excel 2013 using Power Query, Power Query will automatically create relationships between those tables in the Data Model. But did you know that you can get Power Query to