Latest Blog Posts
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them here. In this week’s episode, we’re going to discuss the top reasons why companies are adopting Power BI.
Power BI is a cool tool that allows users to pull data… Read more
Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the name suggest this command can be used to make a clone of your user database without the table data. Instead it creates… Read more
In this post we will simply look at how we go about connecting…
Tired of typing out the same queries day after day? Well query shortcuts in SSMS are for you!
Following on from my last post Changing connection colours in SSMS I thought I’d write another quick about this cool but also often unused feature in SSMS.
These shortcuts allow you to… Read more
At Microsoft Ignite, it’s announced that very soon, we will be able to host Power BI Desktop files on premises using Reporting Services.
Watch the following Ignite session at the 40:52 time mark:
I’d like to see some demos soon. Anyway, happy dance!
If you’re a long time IT professional or an occasional user of high or even low tech software you’ll know what I mean when I say “Bugs are not a new thing”.
Some bugs are earth shattering others are an annoyance and some just make you chuckle. Luckily this simple… Read more
Open Source PowerShell has been on fire, getting tons of community support and really making people think about what’s to come with a single language to manage a heterogenous data center.
To highlight this point, in my recent Pluralsight Play By Play Microsoft Open Source PowerShell on Linux and Mac Read more
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