SQL Server – Find all the LOB Data Type Columns in a Database Using T-SQL Script
Today morning when I was working on a huge database containing lots of LOB data, I was required to know...
2013-09-12
879 reads
SQL Server – How to Perform Striped Database Backup & Restore Using T-SQL Command
Even though there are more pros than cons, Striping database backups are often overlooked by many DBAs. Based on my...
2013-09-03
1,668 reads
SQL Server – Why is the ‘sa’ Login Account Disabled & How to Enable ‘sa’ Login Account
Ever noticed and wondered why the well-known SQL Server system administrator (sa) login is in a disabled state? The reason...
2013-08-20
741 reads
SQL Server – How to Move Database Files – Data File and Log File – From One Drive Location to the Other
Most of the DBAs at some point of time in their career should have faced at-least one of the below...
2013-08-10
1,395 reads
SQL Server – Automating Backup Files Cleanup Task Using Maintenance Plans
Cleaning/deleting the old backup files is equally important as taking the backups. Doing so we can (i) Avoid overhead cost for...
2013-08-07
1,002 reads
SQL Server – Get all Login Accounts Using T-SQL Query – SQL Logins, Windows Logins, Windows Groups
Earlier today I was required to pull the list of all SQL Login Accounts, Windows Login Accounts and Windows Group Login...
2013-08-06
1,416 reads
SQL Server – How to Download and Install the ‘right’ AdventureWorks Sample Database
One of the first things I did when I began my journey with SQL Server was installing a sample database....
2013-07-31
1,603 reads
SQL Server – Understanding ‘sp_spaceused’ Results for Database Size Information
From a recent conversation with a customer, I noticed even some of the experienced DBAs are not very clear about...
2013-06-28
1,622 reads
SQL Server – How to Insert Explicit Values Into An Identity Column
By default, SQL Server automatically assigns a value to the Identity Column for each new row inserted into the table....
2013-06-02
665 reads
SQL Server – Get the Default Data File and Log File Location using T-SQL Query
In SQL Serve 2012, we can get the default data file and log file locations using a simple T-SQL query...
2013-05-23
656 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
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
Supervised versus Unsupervised Training of an Artificial Neural Network
Comments posted to this topic are about the item Supervised versus Unsupervised Training of...
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