Traveling to SQL Saturday Jacksonville 2023
I’m heading to SQL Saturday Jacksonville 2023 today, speaking tomorrow. After not making any of their events, I went in 2022 and am back for their 15th event this...
2023-05-05
31 reads
Blog Posts
Adding microseconds to a timestamp in Azure Data Factory
(2023-Apr-25) It’s not hard to see that many different teams were involved in building Azure Data Factory (ADF) product at Microsoft. It doesn’t have conformed constraints for naming the objects...
2023-05-03 (first published: 2023-04-25)
943 reads
Find out how fast is your SQL database growing using the backup metadata from msdb
Sometimes I need to know how fast a database is growing, or which particular database is growing the most out of all the databases on a SQL instance. Now...
2023-05-03 (first published: 2023-04-24)
802 reads
Azure Resource Group
What is Azure Resource Group? Azure Resource Group is a powerful feature that enables effective organization and management of resources in the Azure cloud. A Resource Group is a...
2023-05-01
122 reads
How to use the new dynamic format strings for measures in Power BI
The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from...
2023-05-01 (first published: 2023-04-21)
742 reads
New Job -> Week 6 -> Ozar sp_BlitzIndex
This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I...
2023-05-01 (first published: 2023-04-24)
765 reads
Tales From The Field Weekly Wrap Up for the Week of 04-24-2023 Steve Martin, Martin Short, & Tacos
Hello Dear Reader! I've realized something writting this blog. I don't like to sit still. It is very rare that I have a down weekend, and this weekend was...
2023-05-01
54 reads
Creating Your First Azure SQL Database
Azure SQL Database is a cloud-based database service that offers scalability and flexibility to handle large workloads. It’s based on Microsoft SQL Server Database Engine and provides a managed...
2023-04-30
73 reads
Get your Query History in Redshift
Because my Windows machine apparently decides to install updates over night (and thus reboot my machine), it has happened that I lost the query that I was writing for...
2023-04-28 (first published: 2023-04-20)
132 reads
Monitor SQL replication subscriptions synchronization status
In your current role if you are managing a SQL server replication setup, you are probably well aware that if any of the subscriber is not getting synchronized within...
2023-04-28 (first published: 2023-04-22)
360 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
This Week's AI Trust Problem Became Everyone’s Problem
Comments posted to this topic are about the item This Week's AI Trust Problem...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers