Latest Blog Posts
I am excited to share that I will be presenting at the DevConnections conference in Las Vegas in October of this year. This is my fourth (if I remember correctly) time to have spoken at DevConnections, and the first time I will have delivered a full-day workshop there. This year… Read more
Speaking on Consolidated Essential Performance Health Check using PowerShell – SQLSaturday (Sacramento)
The first time I heard someone mention drift at Redgate, it made sense to me. After all, in the context of the schema of your database, I can see the code “drifting” away from what you expect. Someone noticed this was a problem when implementing continuous delivery and DLM Dashboard Read more
Here is an overview of the articles I published in the second quarter of 2016, which were all focused on the new changes for Master Data Services in SQL Server 2016:
- Approval Workflow in SQL Server Master Data Services 2016 using Change Sets – Part 1
- Approval Workflow in Master…
Finding the right event or combination of events to monitor may seem like quite a daunting task with so many events to explore and (frequently) too little familiarity with Extended Events. In this follow-up article to Extended Event Help Queries, I will share another means to quickly explore the… Read more
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.
Having system named objects is one of those things that people may debate, but as you move to more automated and scripted processes can cause you issues.… Read more
I was recently browsing www.myplates.com and I’ll say it’s actually quite fun to see what plates people have randomly bought. I found it easy to spend 15 or so minutes typing in all sorts of fun and silly things into the search just to see what would come up.
If you have not already seen in the What’s New in Integration Services list there is a new property for Data Flows that is called AutoAdjustBufferSize. Why is this important and what does it actually do?
First, let’s remember that in SQL 2014 we had a max DefaultBuffersize of… Read more
My very first course has been published on Pluralsight – SQL Server: Consolidation Tactics and Best Practices. In this course I spend just over two hours sharing my experiences and knowledge of consolidating numerous clients over the years.
I had a lot of fun working on this course and… Read more
We’ll be talking deployment, with demos to show you how to work with ReadyRoll for… Read more
So, I have the privilege of not only delivering a regular session, Introduction to Power BI Desktop, at SQL Saturday 531 Louisville, KY, but also a pre-con. The pre-con Power BI: Beginning to End, is a full day of Power BI including hands-on labs. An overview… Read more
I read an announcement from the PASS organization this week that bothers me. I am less upset with the content than the manner in which it was presented, though I am not pleased with either.
What is DBA Tools?
A collection of modules for SQL Server DBAs. It initially started out as ‘sqlmigration’, but has now grown into a collection of various commands that help automate DBA tasks and encourage best practices.
I wrote a short piece over on the Redgate blog that covers how SQL Compare can catch and build a script to move Dynamic Data Masking (DDM) code from one database to another.
As the surface area of SQL Server programming changes, moving these items from one instance or database… Read more
Why create your databases manually if you don’t have to? If there is one thing that I hate to do it is extra work when it’s not needed. With the magic of PowerShell and Azure PowerShell modules you can easily automate the creation of your Azure Database. You can download… Read more