18Jan 2016 by Grant Fritchey 15 Comments

Removing All SQL Server Query Store Data

Azure, SQL Server 2016
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I realized I wanted to purge all the data from my Query Store, just for testing. I did a series of searches to try to track down the information and it just wasn't there. So, I did what anyone who can phrase a question in less than 140 characters should do, I posted a question to Twitter using the #sqlhelp hash tag. Jamey Johnston (t|b) came through... and it was right there in the documentation that I had been reading, over and over. In fact, it was in the documentation in two different places. Reading is clearly a problem for me today. Just so that you know, it's actually really easy:…
Read More
13Jan 2016 by Grant Fritchey 10 Comments

Learning R: Hitting the Books

Data Science
I've been using a series of web sites while I was starting the process of learning R. I've highlighted several of these in previous posts. While people will claim to learn better based on a single source-type, studies have found that you actually learn best by a multitude of methods. So, in addition to video instruction, web sites, guides, etc., I'm also going to read a few books to help learn R. After a lot of research, I've arrived at two that I'm starting with. The first is R In Action. I'm already on the 2nd chapter and I'm enjoying the style and approach. The other book is Using R for Introductory Statistics. I'm using this book because as I have already picked up, the real trick to learning R…
Read More
12Jan 2016 by Grant Fritchey No Comments

“Applies To…” in the MSDN Documentation

Azure, SQL Server 2016, T-SQL
Quick little post. I just wanted to share how happy I am with the new "THIS TOPIC APPLIES TO" infographic. An example here: I think it makes things much more clear when you're attempting to figure out what's up with some T-SQL syntax. Well done Microsoft and thank you. Side note, this only exists in documentation that has been updated recently. I first saw it in some documentation that was updated January 11, 2016. It's not there in another piece of documentation I saw that was updated October 15, 2015. Here's hoping it gets put everywhere. It works.
Read More
11Jan 2016 by Grant Fritchey 13 Comments

Restoring a Database in Azure

Azure
One of the many small things you don't have to worry about any more when working with Azure SQL Database are those pesky backups... Ha-ha-ha! Yeah, I can't keep a straight face when I type it. Microsoft takes on the role of DBA and creates backups and log backups for you when you're working in the Platform as a Service offering of Azure SQL Database. If that doesn't scare you, I'm not sure what will. However, there's good news. There are still ways for you to create your own backup (through the bacpac, I outlined it here, years ago). More good news is, Microsoft's backups actually work. Testing it out is easy. Let's walk through it once. I'm going to assume you have an Azure account on which you already…
Read More