Latest Blog Posts
In the upcoming release of SQL Server Analysis Services 2016, one of the new features you’ll see is the ability to perform a database consistency check against your SSAS cubes and Tabular models. Just like in the database engine side of things, DBCC for SSAS checks for corruption across the… Read more
A few years ago Andy Warren had this idea for a networking dinner. We had been chatting about all the parties and events at PASS, with many of them limited to select individuals. We talked about trying to get more people involved in the community and giving them something to… Read more
I was toying around with the new SQL Server 2016 CTP release and I wanted to run a few SSIS packages to test out the new logging levels. However, everytime I ran a package in the SSIS catalog, it ended with the dreaded “unexpected termination” message. In such a case,… Read more
In the previous article, I wrote about getting into some of the metadata to take a peek at session metadata relevant to deployed Extended Event sessions. Today, I will continue talking about metadata. One difference being that today I will focus on diving into the metadata of running sessions. Read more
In this article I’d like to tell about monitoring tools available in SQL Server 2014 to evaluate the performance of Buffer Pool Extension.
First of all there is a system view sys.dm_os_buffer_pool_extension_configuration that provides information on the configuration of BPE. It shows whether BPE is enabled or not, the location… Read more
Temporal tables were included in SQL Server 2016 as a new feature. These temporal tables are also known as system-versioned tables allow SQL Server for keeping the history of data in table automatically. A temporal table can be defined as a table for which PERIOD definition exists comprising of system… Read more
SQL Server Page Level corruption is encountered due to several reasons, which includes hardware related issues, i.e. failure of certain hardware, hard disk functioning failure, improper network establishment, or logical level of issues such as malware intrusion on the server storing data, repository being declared as out of limit. These… Read more
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:
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…