Latest Blog Posts
Going to be in Seattle on Monday night (Oct 26th) and want to see old friends and make some new ones? Here’s the registration link for our networking dinner/party. The location should be settled sometime in the next few days. Turns out Monday night is football night in Seattle and… Read more
Really excited by my first post on medium, haven't really used it before but found it to be a really nice tool:
Who can do what? One of the key things that a DBA...
If you happen to be in the central Florida or Daytona area head over to Melbourne on September 10th to see me!
I’ll be speaking at the newly merged Space Coast SQL/.Net User Group on Power Query. This topic is easy for anyone in SQL, business intelligence, .Net or even… Read more
I’m a regular watcher of the Midnight DBA Webshow and one day they mentioned regular expressions. Not a new term for me, but not something I’d ever looked at much. Well as it happens I had something that I needed to use it on a day or two later and… Read more
I have the great pleasure to announce that I have been nominated for the “Author of the Year 2015” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post I received the award last year, so I have a… Read more
Today will be the first of a few introductory level posts about Extended Events.
When dealing with Extended Events, there are a few ways to take a look some of the metadata. Not all metadata is created equal when dealing with Extended Events. Some of the metadata is pertinent to…
Pro SQL Server Wait Statistics is available in a variety of different formats, including ePub, Kindle and paperback… Read more
Monitoring of the size of database files is one of the important DBA tasks and this process should be automated. This article will show you how you can achieve this. Why is it important? Most likely you keep an eye of the size of the database and its files to… Read more
If you’ve read my blog for a while you may have seen the following posts:
Well the time has come for me to put together a compilation of ten useful DAX calculations for your… Read more
I’ve been working more with SQL Data Generator (SDG) because it solves some problems that many software developers have with test data. Often each developer needs to create their own set of test data, with these being the common actions:
- Use a backup of production, perhaps old.
- Randomly insert a…
I’m excited to be able to say that coming up next week on Thursday September 10, I’ll be presenting my session Power Pivot 101: An Introduction to the PASS Excel BI Virtual Chapter! For a lot of users, Power Pivot is like the Ferrari you had in your garage but… Read more
The other day I wrote about that torrid love/hate relationship DBAs tend to have with working with XML. In that same post, I promised I would have a follow up post about XML in Extended Events.
Well, today I present to you another opportunity for you to renew your love/hate… Read more
About 80% of the world’s population lives in about 13% of the countries. Okay, this statement is not as knee-jerking as I made it sound. Pareto Principle (also known as 80-20 rule, the law of the vital-few) states that, for many events, roughly 80% of effects come from 20% of… Read more
A new monthly release of the SQL Server 2016 preview has been released: CTP 2.3.
You can find the download here (the official SQL Server 2016 page currently still links to CTP 2.2).
There isn’t any official documentation out yet describing which features have been added or improved, but thanks… Read more
Let`s assume we have following task – make changes to the data in a large table that has consistency checker in a trigger. Let`s look at the ways to do it in a most efficient way.
Use test database in a simple recovery mode. Create two tables and fill them… Read more
The PASS speakers were announced a quite a number of weeks ago now for PASS 2015 in October – and I felt pretty damn honored to be one of the 160 or so selected to speak at the conference (…and as a quick aside I also note a reasonably… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
I was looking to test some of the Azure v12 capabilities, but I needed to upgrade a database. Here’s a quick look at how.
In the old portal,… Read more