Archives: August 2016
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.
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… Read more
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
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at events where there’s no compensation. I know more or less why I do this, but I’ll hold off on my answer. I want to hear about you. #SQLSaturday and… Read more
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 things… 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