(Rob Farley) This is such a cool feature and I hadn’t noticed it until recently, even though Microsoft have had a page about it since December.

(Siddharth Mehta) Upgrading SQL Server Analysis Services (SSAS) to higher versions by applying service packs or installing a totally new version is a routine process in production environments. Each new version generally adds a series of feature enhancements to the product.

(Pinal Dave) Every now and then, experienced SQL Server DBAs as well as the SQL Server rookies find themselves in the unpleasant situation when some important data has been changed or lost with the monumental task to solve this in the most efficient way.

(Derik Hammer) SARGability is the ability of the query to properly search the arguments that you pass it. When your query is not sargable you cannot properly use your available indexes. A few months ago I wrote about sargability in detail.

(Sunil Agarwal) In earlier blog why columnstore index, we had discussed what is a columnstore index and why do we need it. The columnstore storage model in SQL Server 2016 comes in two flavors; Clustered Columnstore Index (CCI) and Nonclustered Columnstore Index (NCCI) but these indexes are actually

(Vikram Pendse) Azure DevTest Labs is a service that helps developers and testers quickly create environments in Azure and save time, efforts and resources.

(Pinal Dave) I assume a number of times when the machine is booted up, I am most likely to hit the Management Studio to work on some script or the other. But sometimes strange things happen and I get all sorts of error. There might be tons of reasons why SQL Server is not able to start.

(Chris Webb) Recently I was creating a parameter in Power BI Desktop and had it configured something like this:

(Daniel Mellor) If you are a SQL Server Administrator, eventually you are going to need to request specific storage for your servers. Depending on the setup at your current company, that is all handled in the background by your Storage Administrators, but if you have the power or are asked for your

(Murilo Miranda) So you’ve decided to use Azure SQL Database. You head for the portal to choose your service tier, and are suddenly faced with a number of questions. Sure, the choices you make have a number of repercussions, but what are they? database performance? business continuity? cost?