Adding people’s names to a blog post can be rather tedious.
I blog a fair amount and do you want to know what the most annoying part of the process is? ... Continue reading
2020-06-18
36 reads
My Experience Switching To A Macbook Pro From Windows
My background
My background has been very strongly focused on the .NET world, with a focused start on SQL Server, later branching into learning PowerShell.
This world was heavily focused on...
2020-06-18
28 reads
Secure Your Data Prep Area
I’ve been building ETL processes for many years, and I’ve learned two universal truths: data preparation is messy, and you must always secure your data prep area. A data...
2020-06-18
25 reads
Power BI Data Viz Makeover: From Drab to Fab
On July 11 at 3pm MDT, Rob Farley and I will be hosting a webinar on report design in Power BI. We will take a report that does not...
2020-06-18
22 reads
Where are Sequences?–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I created a few sequence objects lately to...
2020-06-17
23 reads
PASSMN June 2020 – Data Classification with SQL Server and Azure
I presented at the virtual Minnesota SQL Server User Group meeting on June 16, 2020. The topic was data classification with SQL Server 2019 and Azure SQL Database. Data...
2020-06-17
73 reads
How SQL Server stores data types: UNIQUEIDENTIFIER
This week we’re looking at how the database engine stores GUIDs (globally unique identifiers), specifically known as UNIQUEIDENTIFIER in SQL Server. If you would like to read about storage...
2020-06-17
21 reads
Daily Coping 17 Jun 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-17
22 reads
Azure SQL Database Migrating across Tiers
A quick post today about moving across database tiers. As you can see below I have a General Purpose Serverless Gen 5 1 vCore database (currently paused). Can I...
2020-06-17
480 reads
What is Batch Mode on Rowstore in SQL Server?
Under compatibility level 150, in both SQL Server 2019 and Azure SQL Database, you now can use batch mode for CPU-bound analytic type workloads without requiring columnstore indexes. There...
2020-06-16
78 reads
Blogs
The Book of Redgate: Fun with Images
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Why companies use Palantir and how we help implement it in the Czech Republic
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
My PASS Summit West 2026
Comments posted to this topic are about the item My PASS Summit West 2026
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers