Have You Reviewed Your Azure Storage Bill Lately?
At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the...
2023-06-16
3 reads
Connecting to Azure SQL DB with an Azure Active Directory Account in Azure Data Studio
This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I...
2023-07-03 (first published: 2023-06-15)
244 reads
What Happens in the Background when Executing Queries with Always Encrypted
In previous posts we've looked at a number of aspects of Always Encrypted and how it works. I think it's very useful to understand how it actually works in...
2023-07-03 (first published: 2023-06-15)
246 reads
The New Redgate Office in Cambridge
I’m in Cambridge, UK this week for the internal Global Marketing Week and Level Up Conference. This is my first visit to Cambridge in 2023, and we have a...
2023-06-30 (first published: 2023-06-14)
268 reads
Avoid “Constants” in T-SQL
Here we look at a common query "anti-pattern" that can create performance problems - and how you work around it.
2023-06-14
411 reads
Why Aren’t You Monitoring SQL Server
I repeat the phrase “If you aren’t monitoring it, you can’t measure it” all the time. Through my IT career, this has been a constant. If you don’t have...
2023-06-14
12 reads
Executing Queries Using Always Encrypted
In this post we’ll look at how you interact with data that is encrypted using Always Encrypted. The examples here will show how you run queries from SSMS, in...
2023-06-13
40 reads
Notes from SQLSaturday Jacksonville 2023
Year 15 for Jacksonville! SQLSaturday Jax was held on May 6 this year, back at the usual location on the campus of the University of North Florida. At the...
2023-06-23 (first published: 2023-06-13)
175 reads
Across the Water Again
I’m in the UK again, for my second trip this year. This time I have no commitments for speaking or presenting anything. I’m in town for a Marketing get-together...
2023-06-12
20 reads
Tales From The Field Weekly Wrap Up for the Week of 06-05-2023 Live 360, the Missing Week, & the Pain in the Back
Hello Dear Reader! Let's address the missing week. Last week I was really behind due to the move. We did not have a Monday video and despite my best...
2023-06-12
24 reads
Blogs
Programmatic Tool Calling with the Claude SDK
Programmatic Tool Calling with the Claude SDK Every morning somebody on the team runs the...
A New Word: Mauerbauertraurigkeit
By Steve Jones
mauerbauertraurigkeit – n. inexplicable urge to push people away, even close friends whose company...
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
Forums
Alamat Kantor BCA KCU Wisma Asia Telp:08218200174
Via Wa:628218200174 Alamat Wisma Asia, Jl. Letjen S. Parman No.Kav. 79, RT.4/RW.9, Kota Bambu...
Alamat Kantor BCA KCU Kebayoran Baru Telp:08218200174
Via Wa:628218200174 Alamat. Jl. Melawai Raya No.Blok B, RT.7/RW.5, Kramat Pela, Kec. Kby. Baru,...
Question of the Day
BIT_COUNT() IV
In SQL Server 2025, I run this code:
select bit_count('A')
What is returned? See possible answers