PASS Board 2016: Update #1
Hello everyone. Just because I’ve moved on to the executive committee doesn’t mean I’m walking away from these reports. I...
2016-01-29
892 reads
The Scary DBA
The Importance of a Full Backup in SQL Server
This is the first of 12 posts this year in support of Tim Ford’s #iwanttohelp initiative. These will be completely...
2016-01-27
496 reads
Finding Your Query in Query Store
Query Store is pretty amazing. I’m loving working with it. I think it’s likely to change how query tuning will...
2016-02-01 (first published: 2016-01-25)
2,234 reads
Removing All SQL Server Query Store Data
While setting up example code for my presentation at SQL Cruise (which is going to be a fantastic event), I...
2016-01-18
530 reads
Learning R: Hitting the Books
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
580 reads
“Applies To…” in the MSDN Documentation
Quick little post. I just wanted to share how happy I am with the new “THIS TOPIC APPLIES TO” infographic....
2016-01-12
432 reads
Restoring a Database in Azure
One of the many small things you don’t have to worry about any more when working with Azure SQL Database...
2016-01-18 (first published: 2016-01-11)
1,391 reads
Learning R: Hard Lessons
I’ve always found the best way to learn a new programming language is to start building stuff, solving problems, using...
2015-12-21
962 reads
Speaker of the Month: December 2015
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
452 reads
Benefits from Data Lifecycle Management
I spend a lot of time talking about the need for automation within your databases, especially in support of development,...
2015-12-22 (first published: 2015-12-15)
1,744 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
PowerQuery.... don't meet SSIS
I have a powerQuery that reads and transforms a table in a PDF. Works...
Count of Total Appointments within 30 days of each Appointment Date
Good Afternoon. I have a Table where each Record: 1) Represents an Appointment. 2)...
Reporting Services in Managed Instance
Hi , one of my on-premises servers one server is having databases and one...