Learn to Use Books Online
One of the first questions I hear from folks wanting to grow in their Microsoft SQL Server DBA or database developer...
2012-08-06
2,144 reads
Blog Posts
Recovering from out-of-disk space conditions for tempdb
Another potential problem that you need to tackle as a DBA is running out of disk space on the hard...
2012-08-06
3,247 reads
Rollback TRUNCATE TABLE statement
Whenever I ask a SQL candidate in an interview the difference between DELETE and TRUNCATE TABLE, the first answer I...
2012-08-06
2,433 reads
SQL Audit 201 – Creating an Audit Solution
Welcome back, folks!
Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...
2012-08-06 (first published: 2012-07-31)
6,721 reads
SQL Server - Oracle Architectural comparison
This is one of the session I took for SQL DBA to understand the basics of Oracle, Its a powerpoint presentation but...
2012-08-06
4,597 reads
SQL Server : Lost all Administrator Account in SQL Server and Forgot sa Account Password
What will happen if you lost all your administrator account by mistake ? As per the best practice you have disabled...
2012-08-06
7,988 reads
SQL Server: How Recursive Common Table Expression (CTE) Works ?
Last Friday evening, I forced to look into a procedure which is using Recursive Common Table (CTE) . The procedure was...
2012-08-06
12,280 reads
The first record on data page.
TweetG’day,
I had a recent conversation about data pages. There was some debate about the location of the first record on...
2012-08-06
1,197 reads
Time Flies When You're Having Fun (Déjà Vu Edition)
Writing - be it a technical language like T-SQL, C#, PowerShell, etc. or blogging - is like exercise. When you do it...
2012-08-06
1,530 reads
What's new in Reporting Services 2012 Free Webinar
We are starting our free monthly webinars with 'What's new in Reporting Services 2012' on Wednesday August 8, 2012 at 12...
2012-08-06
1,324 reads
Blogs
AI: Blog a Day – Day 6: Embeddings – How AI Understands
By Vinay Thakur
Continuing from Day 5 where we covered notebooks, HuggingFace and fine tuning AI now...
The Book of Redgate: Mistakes
By Steve Jones
This is kind of a funny page to look at. The next page has...
ADF Pipeline Debugging Fails with BadRequest – The Sequel
A while ago I blogged about a use case where a pipeline fails during...
Forums
Dynamic Unpivot
I have a table I didn't design that has tons of repeating groups in...
Writing as an Art and a Job
Comments posted to this topic are about the item Writing as an Art and...
String Similarity II
Comments posted to this topic are about the item String Similarity II
Question of the Day
String Similarity II
What is the range for the result from the EDIT_DISTANCE_SIMILARITY() function in SQL Server 2025?
See possible answers