How to troubleshoot SSL encryption issues in SQL Server
Tibor Nagy explains how to find the root cause of SSL encryption configuration problems in Microsoft SQL Server.
Overcoming Proposal Objections
We have all had our innovative solutions and proposals shot down by leads, managers and directors. This article addresses some of the causes and tips to improving the success rate for getting your ideas into the priority list.
What, When and who? Auditing 101
In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.
The SQL Scrabble Puzzle
An enhancement to a Phil Factor puzzle gives you a chance to play scrabble in T-SQL.
Webinar: Performance Tuning .NET & SQL Code Using ANTS Performance Profiler
In this LIDNUG webinar, Mitchel Sellers walks through performance tuning best practices, and investigates how developers can use ANTS Performance Profiler to explore their application code and the SQL queries and execution plans behind it.
Monitor Database Growth and Usage
Create a repository of all your database devices and stay informed about changes in their size and usage.
What Have You Learned Lately?
Have you learned anything new lately? Steve Jones asks the question after an interesting T-SQL Tuesday.
Bitwise Operations in T-SQL
How can you get a list of columns that have changed within a trigger in T-SQL? How can you see what bits are set within a varbinary or integer? How would you pass a bitmap parameter to a system stored procedure? Phil Factor has answers.
Runbooks in SQL Azure
SQL Azure Runbooks promise to be your “SQL Server Agent in the cloud” enabling automation of time consuming, repetitive tasks.
The Value of Code
What's the value of code to your organization? Steve Jones thinks it's much larger than many people believe.
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