#PowershellBasics: Warnings and how to hide them.
One of my favorite parts of having a new job is that I learn a ton. (No really, my brain ... Continue reading
2022-12-08
135 reads
Blog Posts
Daily Coping 8 Dec 2022
Today’s coping tip is to be curious. Learn about a new topic or an inspiring idea. My daughter pointed a new podcast out to me: What’s Her Name? This...
2022-12-08
8 reads
Creating a Unity Catalog in Azure Databricks
Unity Catalog in Databricks provides a single place to create and manage data access policies that apply across all workspaces and users in an organization. It also provides a...
2022-12-07 (first published: 2022-11-23)
235 reads
Daily Coping 7 Dec 2022
Today’s coping tip is to stop for a minute when you walk outside and just enjoy nature. It’s getting cold in Colorado, but we had a day recently that...
2022-12-07
10 reads
Encryption and Data Protection Regulation
One of the reasons you may be considering encryption is due to the relevant data protection regulation: either because the regulation specifies that data should be encrypted or because...
2022-12-07
19 reads
Granting read access to SQL Server services with Just Enough Administration
We’ve all been there as DBAs…people requesting access to the servers that we look after to be able to view certain things. I’ve always got, well, twitchy with giving...
2022-12-07 (first published: 2022-11-23)
346 reads
Daily Coping 6 Dec 2022
Today’s coping tip is to find a new way to tell someone you appreciate them. My daughter is away at school, but she has a prescription that is still...
2022-12-06
12 reads
T-SQL Tuesday #157 – “End of Year Activity”
Welcome to the final T-SQL Tuesday for 2022. My ask is, what do you have planned for end-of-year activities for your SQL environment? Do you have annual processes or...
2022-12-06
3 reads
What’s next: Job search burnout
I was given 4.5 months notice this past June and was fortunate to find a new job. I blogged about ... Continue reading
2022-12-06
18 reads
Daily Coping 5 Dec 2022
Today’s coping tip is to look for new reasons to be hopeful, even in tough times. My life is pretty amazing most of the time. There are some stressful...
2022-12-05
10 reads
Blogs
DATEADD Truncates the Number Parameter: #SQLNewBlogger
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
Our SQL Server is Slow! What Do I Do First?
By Kevin3NF
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before...
Using SQLFluff
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Update records based on several common columns
I have 4 tables (apologies for the formatting of the tables, I don't know...
Eliminate a function by writing out the code is now throwing an error
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Question of the Day
A Strange Choice
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex ( indexval VARCHAR(20) ) GO INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3') GO SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE)) FROM dbo.CatIndex AS ciSee possible answers