Simon Sabin) Anyone working on SQL Server will have banged their head against a wall at one point or another trying to figure why a query hitting millions of rows isn’t being done in parallel.

(Pinal Dave) Whenever someone reports some weird error on my blog comments or sends email to know about it, I always ask to share SQL Server ERRORLOG file. There have been many occasions where I need to guide them to find location of ERRORLOG file generated by SQL Server.

(Jeremy Kadlec) As a SQL Server DBA we need to have backups onsite and offsite to protect our organization. We need a SQL Server offsite backup solution that will support all of the features in the environment, encrypt the backups, guarantee our backups are restorable and have a high performance re

(Ed Elliott) I was reading a white paper from a Sql Server tools vendor about how to integrate their tools with SSDT and while it was very interesting there were a couple of inaccuracies and I wanted to clear one of them up and also to help people understand that although SSDT is integrated to Visua

(Michael J. Swart) This post is for me. It’s a script I find useful so I’m putting it in a place where I know to go look for it, my blog. You may find it useful too.

(Pinal Dave) Last week I wrote about SQL SERVER – Marking Filegroup as ReadOnly with SQL Server and it got me interested into few key questions. One of the questions someone asked was, how will backups behave? Are there anything I need to know about ReadOnly Filegroups?

(Robert Sheldon) One of the most certain ways of going wrong with any relational database is to get data conversion wrong. Implicit data conversion is a good feature for the expert but can cause a lot of trouble to the unwary.

(Kris Wenzel) In SQL Server the data dictionary is a set of database tables used to store information about a database’s definition. The dictionary contains information about database objects such as tables, indexes, columns, datatypes, and views.

(Derik Hammer) Today I wanted to talk about SQL Server Data Tools, specifically related to database, or dacpac, deployments. For those of you who do not follow me on Twitter, I am transitioning over to a new company in two weeks.

(Tim Smith) We’ve looked at our current schedule for DBA tasks, such as checking database integrity, re-indexing, and backing up databases, and found that it fails to match when the users access it. We’d like to create a schedule structure with conservative time estimates and begin with backing up,