A Basic Update Trigger: #SQLNewBlogger
I had someone ask me about using triggers to detect changes in their tables. As I explained a few things, I thought this would make a nice series, so...
2025-06-04
22 reads
Blog Posts
IndiaAI Mission: Transforming India with AI Power!
IndiaAI Mission: Empowering India Through Artificial Intelligence🔹 Mission VisionThe IndiaAI initiative aims to harness the power of artificial intelligence to drive innovation, improve accessibility, and catalyze socio-economic development across...
2025-06-04
2 reads
IndiaAI मिशन: भारत को AI की ताकत से बदलने की तैयारी!
🔹 मिशन विज़नIndiaAI पहल का उद्देश्य आर्टिफिशियल इंटेलिजेंस की शक्ति का उपयोग करके नवाचार को बढ़ावा देना, पहुंच को बेहतर बनाना और देशभर में सामाजिक-आर्थिक विकास को गति देना है।...
2025-06-04
6 reads
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things discovered in our vulnerability assessments. Changing things via PowerShell I wanted to be cautious with...
2025-06-04 (first published: 2025-05-16)
408 reads
Stack Overflow & AI
I won’t try to pretend otherwise, I’ve had some mixed feelings about Stack Overflow for a long time. I think the concept of the place, ask a question, get...
2025-06-04 (first published: 2025-05-21)
404 reads
Why I Created the SQL Rescue Sprint – And How It Works
Over the past 25 years, I’ve worked with SQL Server in all kinds of environments: startups, mid-size companies, and global enterprises. And no matter the industry or infrastructure, one...
2025-06-04
27 reads
My first year on full disability, wow!
What a year … At the end of May 2024, I went on full time disability. For the first time in my adult life, I was not fully employed....
2025-06-03 (first published: 2025-06-02)
34 reads
Getting References for GenAI Results
I wrote an editorial on the view of GenAI tech from execs and someone commented that they wanted references for results. Most of us might take a result from...
2025-06-02
22 reads
KDA: Echoes of Deception - Case 2
The people of Digitown are being targeted by phishermen, and they need my help to stop them in their tracks.
The problem
The police have asked for our assistance, and we’ve...
2025-06-02 (first published: 2025-05-13)
188 reads
SQL Server 2025 Is Here – AI Just Changed Everything!
🔟 Top 10 Features of SQL Server 2025 #SQLServer2025 #MicrosoftSQL #DatabaseUpdates #SQLAI #SQLFeatures #SQLServerCopilot #VectorSearch #MicrosoftFabric #DataEngineering #TechUpdates #decodeites #mssqlfun
2025-06-02
64 reads
Blogs
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Modify Power BI page visibility and active status with Semantic Link Labs
Setting page visibility and the active page are often overlooked last steps when publishing...
Forums
Password Guidance
Comments posted to this topic are about the item Password Guidance
Using table variables in T-SQL
Comments posted to this topic are about the item Using table variables in T-SQL
Azure elastic query credential question
I am trying to check out elastic query between two test instances we have...
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers