Latest Blog Posts
Historical Reports vs. Predictive analytics: Rear view mirror look vs. Forward-looking view. Really?
There have been a couple of fixes in SQLCover this week, kindly submitted by John Mclusky (https://github.com/jmclusky):
A few months ago I created a GitHub repository for the purpose of building and maintaining a list of resources for Azure Data Platform training. You can see it here. My goal in putting this into GitHub instead of just running it on my blog is to make it… Read more
No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of all the accounts with sysadmin rights in your SQL Environment. You can’t BinGle; the Auditor is watching. You start to sweat. A lot. You excuse yourself to run to the…
I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working with XML is not my favorite. I know I can get the GUI in SSMS 16.x to show me events, but I sometimes want to query.
Here was my quick… Read more
Cortana Intelligence Solutions is a new tool just released in public preview that enables users to rapidly discover, easily provision, quickly experiment with, and jumpstart production grade analytical solutions using the Cortana Intelligence Suite (CIS). It does so using preconfigured solutions, reference architectures and design patterns (I’ll just call… Read more
I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive one. That made me start thinking. At my very first Summit, I met a couple of volunteers for PASS (Allen Kinsel was one of them, I’ll blame him… Read more
It’s always been my dream to speak at SQL PASS Summit. It’s a tough egg to crack. In my experience the abstract process is a true pain. I submit each year and the feedback on my abstracts has not been all that helpful.
As an example I got feedback on… Read more
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
PASS is our community.
It may sound a little cliche in this time of election propaganda in the US, but it’s absolutely true. PASS is our community. It’s made up of data professionals from around the globe. All of us are volunteers, from the attendees to the speakers, from the… 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!