SQL Server – Login Failed, cannot open user default database
Each login in SQL Server has a default database associated with it. When you login to SQL Server context is...
2013-01-07
1,809 reads
- Interests: SQL Server!
SQL Server – Skipping Function Execution when parameters are NULL
You can avoid executing a function when NULL values are passed as parameters. To achieve this you need to create...
2012-12-28 (first published: 2012-12-19)
4,116 reads
SQL Server – DDL vs. DML Triggers
Although, DML and DDL triggers are used for different purposes, there are some similarities and differences between these.
Similarities between DDL...
2012-05-28
1,627 reads
SQL Server – Check SQL Agent Job History using T-SQL
To check SQL Server Agent Job History you can use the Log File Viewer from SQL Server Management Studio.
To Open...
2012-05-14
2,831 reads
SQL Server – Purging Database Mail History
SQL Server stores all mails and attachments in msdb database. To avoid unnecessary growth of msdb database you should remove...
2012-05-10
1,240 reads
SQL Server – Four-part object names
Generally it is considered good practice using two-part names for objects. It make the code more readable and avoids confusion...
2012-04-30
3,136 reads
Run SSMS as different Windows user
When connecting to a server from SSMS using Windows Authentication, you are limited to using only user which you used...
2012-04-23
2,421 reads
Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008
Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:
1. Microsoft Certified Solutions Associate...
2012-04-18
1,711 reads
Importing data from Excel – using INSERT statements
You can easily import data from an Excel file to SQL Server using SQL Server Import and Export Wizard. However,...
2012-03-29
3,309 reads
Exporting data to CSV file using SQLCMD/BCP
When it comes to exporting data there are different options available in SQL Server, such as SQL Server Integration Services,...
2012-03-27
4,808 reads
Blogs
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency
By HeyMo0sh
As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...
Forums
Windows logins for users migrated from DomainA to DomainB
Hi, I have a SQL Server instance where users connect to via Windows Authentication,...
Multiple Deployment Processes
Comments posted to this topic are about the item Multiple Deployment Processes
How to Use sqlpackage to Detect Schema Drift Between Azure SQL Databases
Comments posted to this topic are about the item How to Use sqlpackage to...
Question of the Day
Upgrading Admin Queries
I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?
See possible answers