TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and community volunteer Taiob Ali – Taiob’s call is to blog on how AI, (the biggest...
2025-08-13
8 reads
Blog Posts
T-SQL Tuesday #189–AI and your Career
I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly...
2025-08-13
50 reads
Using SQL Compare to Revert a Stored Procedure
Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do...
2025-08-13
113 reads
Boost SQL Server Security with gMSA: Real-World Examples & PowerShell Scripts
When deploying SQL Server in enterprise environments, choosing the right service account model is critical for security, manageability, and scalability. Traditionally, DBAs have relied on standard domain accounts with static passwords,...
2025-08-12
22 reads
Andreas Wolter on Evading Data Access Auditing
There are always bad actors who will seek to get access to and, likely, exfiltrate (exfil) the data. But they don't want to get caught; they don't want to...
2025-08-11
8 reads
Azure Arc in Action: Hybrid Cloud Management Made Easy
In today’s hybrid and multi-cloud world, managing SQL Server instances across diverse environments can be a daunting task. Enter Azure Arc—Microsoft’s game-changing solution that brings the power of Azure to...
2025-08-07
17 reads
How AI is Shaping Sustainable Textile Solutions
The textile world is undergoing a transformation, one where creativity meets computation, and tradition dances with technology. Artificial intelligence is not just automating processes; it is unlocking new dimensions...
2025-08-07
15 reads
Microsoft Exchange Hybrid Deployment Vulnerability – Shared Service Principal
On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a shared service principal between the Exchange on-premises deployment and Exchange Online. The vulnerability is found...
2025-08-07
37 reads
A Win in the Fight Against Cyber Scams
Back in June I blogged about pig butchering and the amount of reported losses we're seeing here in the United States of America. This type of cyber scam is...
2025-08-06
17 reads
Just a few weeks to PASS on Tour and the Redgate Summit
It’s just a few weeks until the PASS Summit on Tour in New York City. This is the first event in the series, and I’m excited to go back...
2025-08-06
7 reads
Blogs
Inspecting TSQL Abstract Syntax Trees
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
Becoming a creator, my website experience
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
T-SQL Tuesday #192 Invitation: SQL Server 2025 Excitement
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
Forums
Collecting active node hostname at centralized location
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Beginner in sql server
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
fast farward curson vs while loop on @table
hi, need to known weather fast farwand cursor is faster than a while loop...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers