Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
5 reads
Watch this week's video on YouTube
Pop quiz: What will be the output of the below three statements?
DECLARE @val_varchar varchar(3) = '100';
DECLARE @val_bigint bigint = 100;
DECLARE @val_tinyint tinyint = 100;
PRINT('varchar...
2019-12-17
5 reads
In our Christmas Special, David picks his top 5 features of Azure Data Studio.
2019-12-17
29 reads
I’ve had a month off from travel, which has been nice. It’s been an interesting time catching up on things at home, and a nice break from the disruption...
2019-12-17
12 reads
A little over a week ago, I got a new laptop. This was late on a Sunday afternoon, and I went home to spend time with me wife. After...
2019-12-16
212 reads
This is the fourth and final post in a series about modern Data Lake
Architecture where I cover how we can build high quality data lakes using
Delta Lake,...
2019-12-16 (first published: 2019-12-06)
1,167 reads
Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find,...
2019-12-16
48 reads
A question that I’ve seen come up frequently just recently is, how to track CPU use over time. Further, like a disk filling up, people want to know how...
2019-12-16 (first published: 2019-12-02)
660 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
80 reads
Don’t know about you, but one of my least favourite data pipeline errors is
the age-old failure caused by schema changes in the data source, especially
when these don’t...
2019-12-15
7 reads
By gbargsley
We’ve all been there. Someone walks up and asks, “Is SQL Server having issues?”...
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
I’m giving two online sessions soon on virtual events that are free to attend....
Comments posted to this topic are about the item The Security of Old Tech
Comments posted to this topic are about the item Revisiting SQL Server Window Functions-...
Comments posted to this topic are about the item Tables with a SPARSE Column...
True or False: Tables with a SPARSE column consume more space than regular columns if most values are NOT NULL.
See possible answers