Using a gMSA with SQL Server. Comparing Inline and Multi-Statement Table-Valued Functions. Does a Clustered Index really physically store the rows in key order? .

This includes tips, tricks, rants, and raves. Tuesday, April 5, 2016. Introduction to BI Office from Pyramid Analytics.

Groceries as a Data Problem. Regular Expressions in SQL Server. Buying a Van Using Data. Two of my most popular posts have been about the unpleasant process. A second car would have been useful. My wife and I decided it was time to get one, and the practical choice was a minivan. A vehicle is the 2nd largest purchase most folks make.

SQL Server Fixed Role Permissions. Some of my recent articles have been focused on permissions and security. You can catch up with a couple of those articles here. This article will help to reveal the permissions granted to the various roles and maybe a gotcha or two. What are the fixed roles again? These default roles do have a unique set of permissions fo.

The Best Database Administrators Automate Everything. Do you understand the value of your time? How Does Disabling an Index Affect the Index Usage DMV Counters.

I was actually travelling for most of July and some of that was on holiday with the family, the real family. Thanks for all your work Carmen. Watch this space for more about the Data Community Leadership Program.

El Blog de Cheo Redondo.

Quenching my SQL Server and Powershell thirst. Working with EPPlus and PowerShell. I recently worked on a requirement, where the end user wanted to convert Excel files into tab-delimited text files.

How Do You Ensure Data Integrity in Cubes? April 9, 2015. A friend of mine recently asked for assistance on creating a custom DLL. But, i asked him, why he was pulling his hair over this. He wants the DLL to implement data integrity in the cube. For example, in a customer dimension with SSN as an attribute, he was hoping, a DLL can be created to ensure that SSN is always 9 digit number.