(MattSQL) I was recently involved in the migration of a group of core databases from three SQL Server 2005 instances to three SQL Server 2012 instances. There were quite a few moving parts that needed to be considered as part of the upgrade including replication, CLR, service broker and full text se

(Chris Webb) A bit of an obscure one, this, but useful to know nonetheless…

(Pinal Dave) If the standard set of reports were not enough, in this blog, let me introduce an interesting addition to the reports. This is called as Performance Dashboard reports.

(Tim Ford) Some things go great together: chocolate & peanut butter, movies & popcorn, Mork & Mindy, to name a few. However, there are even more things that don’t mesh well: brushing your teeth & drinking lemonade, Mondays & happiness, myself & reaching the top shelf in the grocery store . . . GUID

(Kenneth Fisher) One of my favorite features of CROSS APPLY is the ability to use it instead of a calculated variable. Well recently I was working on performance tuning a rather annoying query (which I will blog about in more detail later) and one of the steps I took was an attempt to combine CROSS

(Arvind Shyamsundar) Recently I had spoken at the SQL Bangalore User Group about using SSDT and Visual Studio Online to have an efficient and agile development process for the cloud-first world. After my talk meeting, an attendee had asked me about correctly handling four-part names (objects referen

(Tim Smith) Following the webcast on protecting confidential data, a few viewers asked excellent questions unrelated to RegEx and the below provide some approaches as answers to these questions.

(Rohit Garg) Question : When you take full backup, do it capture data till the time backup start time or till the time backup end.

(Pinal Dave) SQL Server Management Studio can now connect to Azure Storage.

(Michael K. Campbell) In my previous post where I addressed considerations for what needs to be synchronized at the server (or instance) level (I mentioned the need to keep alerts synchronized across servers.