Last Week Reading (2019-06-16)
Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of the data platform. Here you have a big portion of news today. Press Unlock the...
2019-06-16
13 reads
Blog Posts
High Security Prices–Always Encrypted 2019 needs Datacenter Edition
I was recently doing some work on Always Encrypted in SQL Server 2019 and needed to set up an HGS server. I went through most of the setup, and...
2019-06-14 (first published: 2019-05-30)
328 reads
Leadership Part 1: Team building
One of the most challenging aspects of being a good leader is building a team that can support the initiatives you will set forth. Without a team that will...
2019-06-14 (first published: 2019-05-28)
451 reads
Notes from Jacksonville, Atlanta, and South Florida
Misc notes: Jax. Ice cream break in the afternoon is nice, but the waffle cones on site make all the difference, the smell is hard to miss! Jax. Rooms...
2019-06-14
19 reads
SQLSaturday Orlando 2019 Begins
We’ll be event number 911, set for September 28th at our usual location at Seminole State College. Maybe something interesting to do there as far as a theme. Call...
2019-06-14
48 reads
12 Ways To Rewrite SQL Queries for Better Performance
Watch this week’s video on YouTube. Thanks to you, we just crossed the 2k subscriber mark! Over the past several week’s I’ve been exploring ways to rewrite queries to improve...
2019-06-13 (first published: 2019-05-28)
3,744 reads
As a DBA, how do I offload some of my work?
I don't have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I...
2019-06-13
5 reads
As a DBA, how do I offload some of my work?
I don’t have time for this “I am a DBA, I am busy, too busy. Developers keep pushing changes to production without me reviewing the code, and now I...
2019-06-13
269 reads
Does the case statement short circuit?
Let’s start with definitions: CASE Statement: This is basically an inline IF .. ELSE IF .. ELSE IF ….. etc ... Continue reading
2019-06-13
497 reads
Get the Source of PREEMPTIVE_OS_PIPEOPS Waits
Extended Events is a powerful tool with plenty of ease of use and flexibility. This flexibility allows the DBA to capably monitor the server for any issue be it...
2019-06-13
214 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers