This is part two in a five part series this week, Moving into Consulting 101.
Today's consulting topic is friendly advice on how to handle yourself in front of clients,...
2021-03-31 (first published: 2021-03-23)
943 reads
Introduction to this blog series
After being laid off by a Great Recession-era mortgage company in 2007, I entered into consulting. I made that switch from in-house DBA to consulting...
2021-03-30 (first published: 2021-03-22)
1,383 reads
Say you have a temp table and you want to see the columns names.
For example, I was trying to convert a query from using a #temp table to a...
2021-03-04 (first published: 2021-02-26)
427 reads
I'll be presenting at two virtual SQL data platform communities this week on a couple well-rehearsed topics, each with fresh updates.
Tuesday, February 23, 2021
12:00 PM to 1:30 PM EST
DBA...
2021-02-22
7 reads
I'll be presenting at 7AM Central Time in the first timeslot of the main three-day PASS Virtual Summit 2020 conference. It's long been a goal of mine to present...
2020-11-04
16 reads
Not many disaster recovery or SQL migration/upgrade scenarios require the SQL Server instance service master key to be restored.
Some do.
Recently, by far the most frequent and common disaster recovery...
2020-11-09 (first published: 2020-11-03)
722 reads
Honored to be a part of not just SQLSaturday #1000, but the long proud history of the free community series of SQLSaturdays celebrating their 1000th+ event. (I spoke at...
2020-10-19
15 reads
Enjoyed the heck out of tonight's October special edition of the virtual Baton Rouge .NET and SQL User Groups meeting, where we had a lot of active chat, three...
2020-10-15
21 reads
Looking forward to presenting at SQLSaturday Memphis virtually this weekend!
Both my wife and I are on the schedule for Saturday, and the organizers chose interesting nontechnical topics for both...
2020-09-29
6 reads
Note: co-authored with Christine Assaf, originally published in the now-defunct PASS Blog.
Historical data analysis that is naïve to past discrimination is doomed to parrot bias. How do we combat bias in our...
2020-09-23
11 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item I Love Editorials
Hi everyone I have a 1000 plus line query and I am getting an...
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers