Cloudbrew 2019 – Slides
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...
2019-12-19
2 reads
Blog Posts
Cloudbrew 2019 – Slides
Cloudbrew 2019 is over and it was a great event. Great speakers and a big audience. Even in my session there were a lot of attendees, which I found...
2019-12-19
15 reads
New Power BI Report Design Pre-Con in 2020
I’m excited to announce that I will be offering a full-day pre-con about Power BI report design in the coming year called Bookmarks, brain pixels, and bar charts: creating...
2019-12-19 (first published: 2019-12-05)
494 reads
One-Click Package Restart in SSIS
This quick tip is likely to be the most brief of the entire collection, but is also one of the most practical. When testing SSIS packages during development in...
2019-12-19
10 reads
SQL Server Christmas Script
Nothing much to say but I hope you all have a nice break. Thanks for the support and reading my blog. Enjoy the script! (Might not format correctly here...
2019-12-19
52 reads
Why You Should Take the 2020 State of Database DevOps Survey today (video)
In this six minute video, I explain why you should take the 2020 State of Database DevOps Survey. The survey is open for a few more days — we’ve...
2019-12-19
4 reads
Compression in SQL Server: COMPRESS and DECOMPRESS
On Twitter recently, I asked: Does anyone I know use the COMPRESS and DECOMPRESS features in T-SQL? To those who replied in the affirmative, I asked: What made you...
2019-12-18
137 reads
Database Reliability Engineering (22 minute video)
I was fascinated yesterday to come across the term, “Database Reliability Engineering,” which I hadn’t seen before. In this 22 minute whiteboarding session, I talk about why we need...
2019-12-18
3 reads
Distributing Jupyter Notebooks
If you’re working with the Microsoft Data Platform, you should be, at the least, exploring Azure Data Studio as a new tool in your toolbox. One of the big...
2019-12-18 (first published: 2019-12-09)
332 reads
Resetting an Azure SQL Database Admin Password
This is likely something that most people know, but it was a bit confusing for me. This post is really here to remind me and help cement this in...
2019-12-18 (first published: 2019-12-05)
2,965 reads
Blogs
Troubleshooting SQL Server – Starting with the Error Log
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Free Online Sessions – Building the €100 DWH and Indexing for Dummies
I’m giving two online sessions soon on virtual events that are free to attend....
Forums
What is rice purity test?
The Rice Purity Test is a harmless questionnaire designed to assess an individual's exposure...
The Security of Old Tech
Comments posted to this topic are about the item The Security of Old Tech
Revisiting SQL Server Window Functions- A Practical Walkthrough
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Question of the Day
Tables with a SPARSE Column and Consumption
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers