When I’m leading a full-day architecture design session (ADS) with a customer and the goal is to come up with a data architecture for them, I first start doing...
2022-08-08 (first published: 2022-07-26)
706 reads
As part of starting a new job you need a way to get a good inventory of basic information of SQL Server instances. Once you
The post Run Glenn Alan...
2022-08-05 (first published: 2022-07-26)
763 reads
Ah, Tim Ford. I remember the time we were sitting at Ruth Kriss Steakhouse trying to figure out which of the two of us was the dumbest person in...
2022-08-12 (first published: 2022-07-26)
254 reads
I 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...
2022-07-26
11 reads
Picture this, you have a report in Power BI that someone passes off to you for data quality checks. There are a few ways to make sure your measures...
2022-08-03 (first published: 2022-07-26)
581 reads
I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed ... Continue reading
2022-08-03 (first published: 2022-07-26)
775 reads
The SQL Solutions Group asked me to do a webinar with them, which is still an honor for me. They’ve been working with various clients on DevOps development practices,...
2022-07-25
36 reads
In the last Database Fundamentals post, I explained what a unique constraint was and how you can create them using the GUI. Using TSQL to create a constraint is...
2022-07-25
101 reads
I 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...
2022-07-25
24 reads
This year we’re back at our usual location on the campus of Seminole State College for SQLSaturday #1030. You may remember that last year we couldn’t use the college...
2022-08-01 (first published: 2022-07-25)
187 reads
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers