How to create a CLR assembly on a remote server with limited permissions
How to create external_access CLR assembly on remote MS SQL server, when trustworthy option is forbidden, and only SQL login is available
Patches for SQL 10 and Techniques for SQL 11
Steve rounds up the patch news for SQL Server this week along with a look forward to the next version of the platform.
SQLServerCentral Webinar #11 Q&A - A Sandbox Development Process
The answers to questions from our webinar on Sandbox development.
TSQL Challenge 61 - Generate an HTML calendar in TSQL
This challenge is to generate an HTML calendar based on the data stored in a table.
Migrating SQL Server Databases – The DBA’s Checklist (Part 2)
Continuing from Part 1 , our Migration Checklist continues: Step 5: Update statistics It is always a good idea to update the statistics of the database that you have just installed or migrated
SQL Saturday #81 - Birmingham, AL
Come get a free day of SQL Server training in Birmingham on Jul 30, 2011.
"SQL Solstice I: The Dog Days of SQL" Opens For Registration!
Get three days of training in Raleigh, NC on Aug 18-20. There are free and paid options that you can read more about.
SQL Overview VI - Monitoring Process Locks
In the sixth part of his series on monitoring your SQL Server, David Bird looks at process locks.
Be Reasonable
Be reasonable. That's how Steve Jones thinks managers ought to behave towards their employees.
How to use temporary table in function
See a short and dirty example how to use temporary table in user defined function (UDF).
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
how to write this query?
Hi everyone I asked this earlier but the desired outcome is a bit different...
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
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