(Kenneth Fisher) One of the options you had when installing your instance was setting some default file locations.

(David Dye) While my last post discussed SSIS object variables this post will look at variable value assignment. There are several ways that a variable can be assigned a value within an SSIS package:

(Kubilay Hüsmenoðlu) When installing System Center Service Manager 2012 you are asked for a SQL Server instance that will host the ServiceManager database. After that the setup wizard looks for instances on the specified SQL Server machine.

(Edwin Sarmiento) Our organization is starting to deploy more virtual machines on Azure for both testing and DR environments. I would like to create and administer Azure virtual machines using Windows PowerShell. How do I get started?

(Michael Sorens) There aren’t many frameworks for writing acceptance tests for databases, including SQL Server. FitNesse is an obvious choice since it is designed with a Wiki-style interface that, once it is configured and set up correctly, makes it very easy for a non-specialist to set up individu

(Don Mackenzie) Business systems often include challenging reporting requirements. A business user needs access to historic transactions and current activity. He also needs to view data in many ways. A user will make specific requests such as:

(Pinal Dave) I have written quite a while on Delayed Durability and every blog post when I think it will be the last post on this subject, I always get some question in an email and I end up writing a new blog post.

(Rohit Garg) Issue : I am facing error “The remote procedure call failed. [0x800706be]” while trying to view SQL Services from SQL Server Configuration Manager.

(Chris Webb) Loading data from SQL Server using Power Query is fairly straightforward, and the basics are well-documented (see here for example).

(Derek Colley) You are tasked with checking account or credit card numbers for validity, for example as part of a web application handling sensitive card data. You wish to implement this as a function within SQL Server, with the ability to be called with any number and return either TRUE (valid) or