Archives: March 2016
Dynamically totaling child members
Putting the dynamic totals on top or at the bottom can be a trivial or a big decision. Very often, visual tools reply on MDX queries to get the aggregation correct in the MDX query so that the need to aggregate in the visual tool is… Read more
If you don’t know Gareth you should make it a point to get to know him. He originally hails from South Africa but now resides in the United States with his family.
Gareth is a frequent presenter in the… Read more
I was pleased to hear today that I was selected for the 2016 NomCom, along with Joaquin Romero, Erin Stellato, and Thomas LeBlanc. We’ll be working with the Nominations Committee (NomCom) Chair, Thomas LaRock, and Board representative, Tim Ford. It is a solid team and I’m eager to get… Read more
A less timing consuming option to trying the latest is to use Microsoft Azure. If you have an Azure subscription you can spin…
In my article, TFS tools for managing SQL Server development, I covered several Team Foundation Server (TFS) client tools that can be used to manage SQL Server-related development. Some of the feedback I received from the article was the issue of tagging items in Excel. This article illustrates… Read more
To test or not to test. That is the question. Or is it? Shouldn’t we always test? That was the question posted here. It’s a big question so let’s break it down a bit.
You have a system and are about to upgrade some or all of it.… Read more
Many moons ago, I posted a script to help report on the human friendly scheduling information for SSRS subscriptions. You can read all about that here.
In a very similar fashion, today I want to share how easy it is to turn the internal schedules for SQL Agent jobs… Read more
Last week, I received an alert that the percentage of transaction log in use on one of our production databases was increasing more than it should have been. I’ll refer to this database as DB1 from here on in. It had reached 18%, which is above the normal 5-10% we… Read more
I frequently present at user groups, and always try to create a brand new presentation to keep things interesting. We all know technology changes so quickly there is no shortage of topics! There is a list of all my presentations with slide decks and videos in some cases. Here are… Read more
It’s Tuesday, and the Monday post is late. A weekend of smoking quite a few pounds of pork kept me in a meat coma. The three day weekend also kept motivation to get this post out low, but hey, it’s Tuesday and might as well share this – since I… Read more
The sa account is a well, known, built in account for SQL Server. Years ago, in previous
versions, I’d see people often use the “sa” account for development, usually with a blank password. Even those speakers and experts often showed demo code with a blank “sa” password.
Ugh, a horrible… Read more
Given that SQL Server 2016 is coming ‘real soon now’, it’s probably well past time that I write up some thoughts on new features.
The first one I want to look at is a feature that I’m so looking forward to getting to use, the Query Store.
Query Store is… Read more
Continuing my obsession with partitioning I thought I’d write this quick post about a cool change in SQL Server 2016.
This change allows you to truncate an individual partition, instead of having to switch that partition out to another table and then truncate it. Full details can be found here:… Read more
I offer instruction on the Azure Data Platform, and have for about six years, since shortly after it came out. I started using Azure SQL Database (although it had a different name then) Day 1.
I know a few other people who don’t work for Microsoft, but have been actively… Read more
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queuing technology built into the SQL Server Database Engine.
In this installment, we introduce the basic Service Broker service architecture components. Read more
From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will be in Liverpool promising four days of great SQL Server sessions and training. Just take a look at the agenda to be blown away by the amount of… Read more
In a galaxy far, far, far away a developer of a third party application somewhere in the Hoth system had to implement cell level encryption for sensitive data. Their weapon of choice was to do this utilizing C# code within SQL Common Language Runtime (CLR). Though the galaxy is full… Read more