(Dennes Torres) SQL Server Data Collector, together with Management Data Warehouse, is a fine and useful component for gathering information centrally about how SQL Server instances are being used, and thereby keeping an eye out for problems. It comes into its own when you have figured out how to co

(Pinal Dave) When I wrote my previous blog post on SQL SERVER – Finding Tables Created Last Week – DBA Tip, lesser did I know something as simple as this can become such an interesting topic of conversation. I have been overwhelmed with the number of emails I have got in the past week to know more a

(Prashanth Jayaram) Different ways to find the weekend between two given dates. The SQL requires @begindate and @endate paramteters to be entered in the below SQL

(Derik Hammer) Today a co-worker of mine (Brad) asked a question regarding the usage of T-SQL’s Try-Catch block. Brad wanted to write to a table every time a stored procedure failed so that it was easy to recover the error messages and track issues.

(Chris Bell) Continuing the thoughts of knowing what is going on in your database let’s talk a little bit about primary keys.

(Pinal Dave) In a recent debugging exercise for performance, one of my friend recently posted a question to me:

(Rick Strahl) I’ve been looking at Azure for a long time, hearing all the glowing reports about how well integrated the platform is and how easy it is to move things get up and running. I’ve been contemplating moving to some sort of virtual host from my current physical server setup as I can certain

(Kathi Kellenberger) This is the last installment of a four-part series of articles on the basics of creating and publishing reports using SQL Server Reporting Services:

(Kris Wenzel) The purpose of this article is to introduce you to subqueries and some of their high-level concepts. There are a lot of details to cover in order to learn sub queries, but you’ll see we cover those in depth in later articles.

(Marcin Policht) When planning for deployment of Azure SQL Database, it is important to consider all of the security measures that can be implemented as part of the defense in depth strategy. We have already covered in detail one facet dealing with firewall-based protection in one of our earlier art