(Derek Wilson) You can create and leverage cloud based SQL Server instances using Microsoft Azure. However, if you have never used the Azure portal it can be a bit challenging to get started. This post will show you how the steps required to create an Azure SQL Server database.

(Arshad Ali) Statistics refers to the statistical information about the distribution of values in one or more columns of a table or an index. The SQL Server Query Optimizer uses this statistical information to estimate the cardinality, or number of rows, in the query result to be returned, which ena

(Francesco Cogno) Last blog post was quite code heavy (http://bit.ly/1xnRn4Y). We have implemented the RESP protocol by hand in C# (well, some of it) and wrapped it in a nice SQLCRL stored procedure. We have shown how easy it to publish events from SQL Server to redis.

(Edwin Sarmiento) In a previous tip on Making Adjustments to SQL Server Reporting Services Configuration Files, we’ve seen how we can modify the rendering format of a Reporting Services report by making changes to the RSReportServer.config file. However, this does not work when Reporting Services is

(Pinal Dave) In my previous blog I talked about using SQLCMD to generate a comma separate files for the table data.

(Chris Webb) The other day when I was thinking about Power Query functions (as you do) it occurred to me that they would be a lot more usable if, when you invoked them, you could show your users a dropdown box for each parameter where they could choose all of the allowed parameter values rather than

(Jason Brimhall) Recently I shared an article on how to track the growths and shrinks that occur within database files. I shared that article here, you should read it before proceeding with today’s article.

(K. Brian Kelley) I ran a couple of health checks on my SQL Servers and the checks indicated I didn’t have critical alerts configured. What do I need to do?

(Pinal Dave) It’s always a fun to learn and share new thing which I learn about any technology. So I decided to spend my weekend at home quietly, so I could learn some scripting using PowerShell and SQL Server.

(Chris Shaw) Sometimes managing multiple file groups and the amount of data that is in them can cause a few logistic issues. Recently I found myself needing to know what tables are in what file groups and what the sizes of those tables are. With the database the size it is and the number of objects