(Shaun J Stuart) SQL Server Reporting Services provides functionality to automatically generate a report on a recurring basis. These reports can then be emailed or written to a file. The method for doing this is called a subscription. It’s common for a developer to create a report and then create a

(Joe Celko) It is awkward to do ‘Graph databases’ in SQL to explore the sort of relationships and memberships in social networks because equivalence relations are classes (a set of sets) rather than sets. However one can explore graphs in SQL if the relationship has all three of the mathematical pr

(Pinal Dave) This article shows how to use ApexSQL Refactor,a free SQL code formatting and refactoring tool. You can download ApexSQL Refactor, and explore it through the article.

(Steve Endow) I’ve been using SQL Server Management studio since long before it was called Management Studio, but I regularly stumble across some new feature or shortcut that I never knew existed.

(Kenneth Fisher) Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and said I would discuss it later. Well it’s later.

(Chris Webb) Recently I had to solve the same, rather complex, problem for three different customers within the space of two weeks, a variation of the ‘events-in-progress’ problem I’ve blogged about a lot in the past. It’s this one: how can you calculate the value of your overdue invoices on any giv

(Tim Ford) A busy database administrator (DBA) can often be blindsided with a request involving a SQL Server instance they’ve not had to look at for a while—or worse yet—an instance that is a suprise in their environment.

(vamittal) I recently faced an issue while migrating our SSRS reports from one server farm to another with reports having an embedded data source, sub-report URL etc. in them. Needless to say but both the farms had different URLs:

(Dallas Snider) What is the basic process to install SQL Server 2014? Can you walk me through the steps?

(Mihail Mateev) In the previous post we did an overview of the different Node.js drivers for Microsoft SQL Server. There was a comparison between different modules for SQL Server and were considered and their advantages and disadvantages.