(Manoj Pandey) A Stretch Database lets you archive your historical data transparently and securely in the Azure SQL Database (i.e. Microsoft PaaS Cloud).

(Kathi Kellenberger) Before SQL Server had SQL window functions, SQL Server developers had to use all manner of tricks and algorithms to come up with ways to rapidly process large amounts of data. Do we need these techniques now that we can express a SQL task in terms of window functions?

(Kenneth Fisher) Figuring out what components of SQL Server are installed on a particular machine has always been a task that has aggravated me. Telling what services have been installed is pretty easy, discovering if the backwards compatibility components were installed, for example, is a bit more

(Niladri Biswas) In SQL Server, if we want to perform the Total and Subtotals inorder to gerenate the reports, we can take the help of the RollUP function.

(Pinal Dave) If you search this blog, there are a number of PowerShell scripts that I have shared in the recent past. Some of them include:

(Kenneth Fisher) Figuring out what components of SQL Server are installed on a particular machine has always been a task that has aggravated me. Telling what services have been installed is pretty easy, discovering if the backwards compatibility components were installed, for example, is a bit more

(Niladri Biswas) In SQL Server, if we want to perform the Total and Subtotals inorder to gerenate the reports, we can take the help of the RollUP function.

(Pinal Dave) If you search this blog, there are a number of PowerShell scripts that I have shared in the recent past. Some of them include:

(Larry Leonard) This script will load all the trace (*.TRC) files in a given folder into a single trace table. You have to specify the database to create the trace table in, the folder the trace files are in, and the filename prefix (if any). Be careful: trace files can take up a lot of space in a h

(John Pertell) I’m starting to catch up on some of my backlog this month. One of the items on my list has to do with FileTables. I wrote about inserting files into a SQL FileTable a while back. I gave an example how to do it with a TSQL script.