Creating Empty Repos in Azure DevOps–#SQLNewBlogger
I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...
2023-09-13
94 reads
Extended Events and I (T-SQL Tuesday #166)
Foreword
This month’s invitation is from Grant Fritchey (t|b), aka the Scary DBA, about Extended Events (XEs).
If you look at the Tags section of my blog, you can see that...
2023-10-06 (first published: 2023-09-13)
387 reads
Restarting What’s Important
I’m currently in Enterprise Architecture in my organization and as a result, I blogged earlier about putting up study notes with regards to preparing for the two TOGAF (The...
2023-09-13
34 reads
Webinar: The Cloud, the Future, and Bob Ward at the Summit
I’m doing a webinar next week with Bob Ward, a principal architect for Microsoft working on Azure and SQL Server. I’ve had the chance to work with Bob quite...
2023-09-12
60 reads
T-SQL Tuesday #166: Extended Events
When I was put on the list to host September’s T-SQL Tuesday, well, I forgot to put it in my calendar. So I’m late (and in the doghouse with...
2023-09-11
56 reads
SQL Server Security Checklist
In this article I will share the Microsoft SQL Server Security Checklist that I have used for many of my clients to help them achieve PCI compliance. This can...
2023-09-11
281 reads
A New Word: Vulture Shock
vulture shock – n. the nagging sense that no matter how many days you spend in a foreign country, you never quite manage to step foot in it –...
2023-09-08
38 reads
Raiders of the Lost ADX – dataminds connect 2023
I’m very excited for this year’s edition of dataminds connect. It’s the first time I’m going to co-present a live session. My fellow explorer is the amazing bearded Johan...
2023-09-08
24 reads
I don’t blog anymore, but not because I work at Microsoft
Last year I had a health scare that got my blood pressure at 200-and-something over 100-and-something, soon to be wired up to an IV drip, put through a CT...
2023-09-08
59 reads
Decimal Display in Power Query
Introduction
Power Query is a versatile tool found in both Power BI and Excel, facilitating data transformation and manipulation. Despite its efficiency in numerous data tasks, managing decimal values can...
2023-10-02 (first published: 2023-09-07)
556 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers