(Donabel Santos) To back up your database to Azure BLOB storage, first you need to set up the BLOB storage in your Azure account. You will also need to create a container first.

(Dennes Torres) When you’re developing database applications, it pays to check for index scans in the SQL Server query plan cache. Once you’ve identified the queries, what next?

(Adam Kreul) Often, when DBAs are looking at total wait statistics on the servers they manage, CXPacket is at or near the top of the list. If this is the case for you as well, chances are your server isn’t on fire, but there could be room for improvement.

(Jen McCown) I’ve talked about NULLs before. (Ref: Here’s a bit on ISNULL(), and here’s one about understanding NULL at a basic level.) And yet, it’s worthwhile to bring these things up from time to time.

(Koen Verbeeck) I created a line chart in Reporting Services (SSRS). In order to analyze the data better, I’d like to add some sort of trendline to the graph, such as a weighted average for example. In Excel it is possible to add this functionality with just a few clicks. Can we achieve the same in

(Gregory Larsen) There are times when you don’t what to return a complete set of records. An example where you might need this requirement would be in an inventory system when you want to produce a pick list where the stock you want to ship has the oldest manufacture dates. When you have this kind

(Kenneth Fisher) Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly regular basis. What I don’t think a lot of people know is that there are two types of temporary tables.

(Prashanth Jayaram) Replace the Data Source and Initial Catalog values of WebConfig.XML

(Roy Ernest and Surenda Djaoen) More and more applications require the handling of geospatial data. It is easy to store spatial data, but it takes rather more thought to retrieve and manipulate it. Tasks like searching neighborhoods, and calculating distances between points is often required from d

(Pinal Dave) Read this blog and I am sure it will bring some instances in your environments. This is one of the common issues I have observed while working with SQL Server from long time now. In this blog we will discuss little details about the issue and possible action you might take.