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
878 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,394 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
655 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
What's the Date?
Comments posted to this topic are about the item What's the Date?
Two New Shortcuts for Fabric Lakehouse Developers: The Fabric Modern Data Platform
Comments posted to this topic are about the item Two New Shortcuts for Fabric...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers