Latest Blog Posts
Welcome back to another episode of This Week In Data! In our first episode, Adam and Devin debated the value of certifications. In this week’s episode, we’re discussing the right way to ask for help.
For some, knowing when and how to ask for help can be a major… Read more
Today I published the first release of ForumSurfer, a RSS reader designed explicitly to be a tool for the SQL Server online community.
Here is a screenshot:
ForumSurfer has some unique features that will help you help others online:
- it is designed to help you keep an eye on…
I’ve been looking at some of the features of DLM Dashboard as I go through work building database development pipelines. In this post I wanted to cover one of the lesser used features, filtering objects.
Why would you filter objects if you’re auditing changes? Well, this isn’t really an audit… Read more
There are many times, we face the LSN mismatch issue in alwaysON and other HA technologies. It is a bit hard to find the missing transaction log backup to apply. Since, there are hundreds of thousands log generated, depends on the transaction log frequency and it can be run… Read more
A lot of these types of events are pulled together by the local user group. If there is none, it is a great resource to spawn a group afterwards. Regardless, it helps to get a team together to get things underway. The trick is how you build the team and…
First things first the DMA is a replacement of the Upgrade Adviser. In fact it’s an upgrade of the Upgrade Adviser. It has some amazing new features.
- You can install…
I’ve got a session this fall at the IT/DevConnections conference (Oct 10-13, 2016) called “Who’s Touching My Database?” This is something I’ve worked on for a few years, but never really gotten it to the point where I was ready to deliver it.
Earlier this year, with all the security… Read more
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past, I blogged about how you should benchmark wait stats with the box product. This process will give you misleading data in Azure SQL Database. You will want to focus… Read more
Within the world of SQL Server there are a few things one can be certain of – things will change. This is true of the features in SQL Server. Additionally, Extended Events is constantly evolving which underscores this constant change.
With all of this change occurring within SQL Server, sometimes… Read more
In this module you will learn how to use the Tornado Power BI Custom Visual. The Tornado allows you to compare two categories of data vertically similar to a bar chart.
Module 14 – Tornado
Azure SQL Data Warehouse can sometimes feel like it’s completely different from SQL Server, but under the covers, it is still (mostly) SQL Server and it does have execution plans. Let’s take a look at one.
I’ve created a new SQL Data Warehouse using the sample database available on the… Read more
SQL 2014 Service Pack 2 was recently released by Microsoft and there is a ton of great new features and enhancements in this release. This isn’t just a collection of bug fixes…there’s some serious value in this Service Pack. Check out the full list here. One of the key… Read more
There has been a long standing debate over the use of a natural primary key vs an artificial one. I thought I would throw in my two cents.
First of all why is it important? The primary key is used for two major purposes.
The primary key is one… Read more
I love to speak about PowerShell. I really enjoy giving presentations and when I saw Start-Demo being used at the PowerShell Conference in Hanover I started to make use of it in my presentations.
Start-Demo was written in 2007 by a fella who knows PowerShell pretty well :-) https://blogs.msdn.microsoft.com/powershell/2007/03/03/start-demo-help-doing-demos-using-powershell/
It… Read more
Remote server management is a fact of life for folks involved with sql server. Since we work so often with remote machines I looked into a few tools that provided a better workflow than the default Microsoft tools. This one came out as the winner by far.
A better remote…
If I had a dollar for every CTE solution to a simple query in the forums (pick any SQL forum), I’d be Mark Cuban. With that said I thought it would be a good idea to ask if a CTE was actually the right solution or if it’s just the… Read more