Latest Blog Posts
I have released a new version of SQLCover which is a code coverage tool for T-SQL (let's you identify where you need to focus when writing tests).
This includes a few minor fixes but also support for SQL Azure so if you run your test in a v12 database or…
There seems to be two trains of thought and I think this is mainly down to who and where your developers are. The first is that a stored procedure or a function is a great place to put all the business logic that an application needs. The second is that…
One June 5, I’ll be back in Pensacola, FL for SQL Saturday #491. It’s been a few years since there was a conference in the area, and I’m excited to go back. I really like the area, and am looking forward to visiting for a few days.
I’ll be… Read more
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa City on 6/10/2016 called ‘The Complete Primer to SQL Server Infrastructure‘.
The focus of the course is to help those new to the enterprise server infrastructure… Read more
If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of the two full-day workshops I have scheduled for August of this year. I’ll be taking my popular course Building Better SSIS Packages on the road to Baton Rouge, Louisiana and… Read more
After a few days in Copenhagen for SQL Nexus, I traveled to London late last night, and am now making my way to Liverpool for SQL Bits. A hectic schedule, leaving one city, flying to another, a few hours sleep and moving again today.
It’s exciting to be… Read more
Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I partnered with Linchpin People, a guild of independent consultants made up of some of the very best practitioners in the database and business intelligence space. Working with Linchpin helped to… Read more
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic question. It went something like this…
“Can you get the text in management studio to word-wrap?”
Word-wrap is not on by default. You can see from the image below we… Read more
In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage account. Just introduced is a new kind of storage account, called “Cool Blob Storage”. When creating a storage account, the “Account kind” will now list two options: the existing type… Read more
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them.
TL;DR; GRANT and DENY are opposites. GRANT applies a positive permission, DENY a negative permission. DENY will always override GRANT. REVOKE is the opposite of GRANT and DENY. It removes… Read more
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you can edit the MDX). When you create the MDX query using the designer, it will append some cell properties at the end of the query. Basically it’s just metadata about… Read more
I saw recently an email where someone stated that the reason that they manually create deployment scripts is that because of the restirctions put on them by the requirements for auditing and the ability to be able to demonstrate exactly what was deployed at what time.
When automating deployments it…
Letting SQL Server change data types automatically can seriously impact performance in a negative way. Because a calculation has to be run on each column, you can’t get an index seek. Instead, you’re forced to use a scan. I can demonstrate this pretty simply. Here’s a script that sets up… Read more
Overview of SQL Server Error 3013
One of the most frustrating situations that a user experiences while working with SQL Server is when errors are encountered. These errors disrupt the normal functioning of SQL Server and in worst case scenario may even lead to data loss. Sometimes, SQL Server Backup… Read more
By Steve Bolton
…………As mentioned in previous installments of this series of amateur self-tutorials, goodness-of-fit tests can be differentiated in many ways, including by the data and content types of the inputs and the mathematical properties, data types and cardinality of the outputs, not to mention the performance impact… Read more