Get month names ordered using recursion
Learn how to pull the month names in a report drop down using a recursive common table expression (CTE).
The Consistency Debate
Steve Jones wonders today if data professionals get a little too hung up on the consistency issues between servers.
Steps to Rename a Subscriber Database for SQL Server Transactional Replication
I have transactional replication configured in production. The business team has a requirement to rename the subscription database. Is it possible to rename the subscription database and ensure that transactional replication will continue to function as before? If so, how could we achieve this?
Disaster Recovery: Rebuild system databases on SQL Server 2008 cluster
In this article we will see how to rebuild system databases in SQL Server 2008 cluster that is failed to restart.
SQL Server 2012 RTMs
This past week the big news in the SQL Server space was the release to manufacturing of SQL Server 2012.
How to Secure your SQL Azure Application
Developers targeting the SQL Azure platform should make sure their applications are secure. This article walks through the considerations developers need to keep in mind when designing SQL Azure applications.
SQL Saturday #105 - Dublin
The first SQL Saturday in Ireland on Mar 24, 2012. Come get a free day of SQL Server training.
SQL Saturday #120 - Orange County
Come to a free day of SLQ Server training on Mar 24, 2012 in Huntington Beach, CA.
Implementing Microsoft iSCSI Initiator Policies & Multi Pathing
Impementing iSCSI multi-pathing and redundancy policies
Old, but stable
This Friday Steve Jones wants to know about the older versions you are running in your production environments. Are you still using SQL Server 2000?
Blogs
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Blue Sky Programming – The Optimism Trap
Many years ago, before I joined Oracle, I was working on a major modernisation...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I include the Resource Database?
See possible answers