ASF 019 video invitation
Check how many bicycles he has got at home and where was the destination of last year of a 400...
2019-02-15
116 reads
Speaker at SQL Saturday’s Guatemala city 2019
I’m very happy to announce that for the second year in a row I will be participating as speaker in...
2019-02-15
187 reads
Learn about the State of Database DevOps Next Week
It’s a week to my webinar with Donovan Brown (bt, yg), leader of the League of Extraordinary Cloud DevOps Advocates,...
2019-02-14
232 reads
DBA Myths: Can a differential backup get bigger than the full backup?
The thing about DBA Myths is that they are generally widespread and widely believed. At least I believed this one...
2019-03-04 (first published: 2019-02-14)
2,457 reads
Undercover Catalogue 0.2.1, Fixes An Issue With The Recording Of Unicode And MAX Datatype Lengths
Please see https://sqlundercover.com/undercover-catalogue-0-2/ for full details on the Undercover Catalogue and how to obtain it.
We’ve spotted an issue where unicode...
2019-02-14
135 reads
Partitioning 3: Beyond just partition elimination
In Partitioning 2, I showed how to analyze which partitions were accessed by our Index Seek. However, we were searching...
2019-03-04 (first published: 2019-02-14)
1,871 reads
Violin Plots in Power BI
In case you aren’t familiar, I would like to introduce you to the violin plot.
A violin plot is a...
2019-03-05 (first published: 2019-02-14)
3,130 reads
Cool Stuff in Snowflake – Part 6: Query History
I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share....
2019-02-14
68 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March 16, 2019. I will be presenting my What is...
2019-02-13
24 reads
Speaking at SQL Saturday Victoria
I am so excited to announce that I have been selected to speak at SQL Saturday Victoria on Saturday, March...
2019-02-13
118 reads
Blogs
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers