Latest Blog Posts
Table of Contents
In this post I will talk about the in-built refactoring support in SSDT – the language is slightly different from my normal style as originally it was going to be published else but rest assured it is written by myself
What is refactoring?
In programming , the term ‘refactoring’ essentially…
In this module you will learn how to use the Stream Graph chart Power BI Custom Visual. The Stream Graph is similar to a Stacked Area Chart but has more of a fluid look and feel to it. You’ll find this visual often useful when displaying data across time.
PASS Summit 2016 is fast approaching. If you’re going, time to start making plans. If you’re not going, sell your boss on the idea and get registered. It’s only the largest Microsoft Data Platform event on the planet. There are over 200 sessions given by some of the most knowledgeable… Read more
Piggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events.
Having the opportunity to work alongside these vendors has been both a learning experience for myself along with forming new… Read more
SQL Prompt has lots of great features that can help you write SQL quicker. However, you’ve got to train yourself to use a few of these and not just start to type with your old habits. This quick tip looks at one of those areas when inserting data into tables. Read more
It’s funny how easy it is to find information you aren’t looking for. A few weeks back Stephen Bennett (b) linked to my post Comparing Two Query Plans. Since I always find that interesting I followed the link and wound up at his post 3 Reasons to?… Read more
When using the latest version of SSMS (SQL Server Management Studio) there is a small but handy little feature that I noticed when you are connected to an Azure (logical) SQL Server.
So below I have 2 screen shots – 1 when connected to an “earthed” SQL Server versus the… Read more
Most of the time, while working with SQL Server, the transaction log files usually grows due to numerous reasons. Out of which one such reason is that there is already existing allocated space to the file in the SQL Server. This can be caused due to natural increment in… Read more
Here’s a great question I received: We had a problem at 9:02 AM this morning, but we’re not sure what happened. Can Query Store tell us?
My first blush response is, no. Not really. Query Store keeps aggregate performance metrics about the queries on the database where Query Store is… Read more
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who successfully landed his A320 jet on an icy river after losing both engines shortly after takeoff. I enjoyed the movie for its main story line but also for some of… Read more
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve been collecting a few links with examples and instructions I have been using to improve my skills.
Express editions of SQL Server Reporting Service, from SQL 2016 on down, cannot connect to Azure SQL Databases. Turns out, getting something for free does have some significant limitations.
For example, you'll see an error message…