(Jonathan Clark) SQL Server sp_showpendingchanges is used to determine how many changes need to be moved to a subscriber or uploaded to a publisher. You can use these steps to “roll your own” and pull similar data.

(Rick Dobson) Have you ever needed to store and use results computed by a SAS Analytics package in a SQL Server database? This kind of requirement comes along very infrequently, but it is imperative to understand the different outputs and columns for matching results between your SAS package and SQL

(Melissa Coates) Quick tip for cancelling a long-running SQL Server Analysis Services query. Screen shots & statements are from SQL Server 2008 R2.

(Rohatash Kumar) Today, I have provided an article showing you how to use the new Date and Time functions in SQL Server. In this article, I will be covering the common usage of these functions because they are very useful for SQL developers. There are seven new datetime functions introduced in SQL S

(Patil Kishor) This article is about storing and retrieving images from a SQL Server database using VB.NET. When we create an application where we need to save images then we save images in a folder and store the path of the image in the database as string type.

(Denny Cherry) Upgrading a clustered SQL Server 2008 R2 instance to SQL Server 2012 is just as easy as it was upgrading from SQL Server 2005 to SQL Server 2008. However, when upgrading a SQL Server 2008 R2 (or earlier) cluster to SQL Server 2012, there’s an additional decision that needs to be made

(Jason Strate) The compatibility view sysdepends returns rows dependency information for objects within a SQL Server database, such as establishing relationships between a stored procedure and the tables that it uses.

(Scott Murray) As you design and deploy more and more reports to your Report Server, how do you review which reports are being run, how often, and how long the reports take to render?

(Derik Hammer) Often enough we encounter a situation where we need security to be migrated. Microsoft hasn’t made this task as easy as moving other things such as SQL Agent jobs since restoring the master database to another server is tricky at best but they do provide us some tools.

(Chris Yates) There have been instances in my career where I’ve had to perform backups off a routine schedule; I mean it’s inevitable, right? It’s nice to look at job history to see about how long the backup job normally takes; can give an estimate or an ideal of what to expect.