2012-03-13
24 reads
Articles
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).
2012-03-13
10,817 reads
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?
2012-03-13
2,149 reads
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.
2012-03-12
6,894 reads
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.
2012-03-12
2,138 reads
SQL Saturday #105 - Dublin
The first SQL Saturday in Ireland on Mar 24, 2012. Come get a free day of SQL Server training.
2012-03-12
1,615 reads
SQL Saturday #120 - Orange County
Come to a free day of SLQ Server training on Mar 24, 2012 in Huntington Beach, CA.
2012-03-12
1,406 reads
Implementing Microsoft iSCSI Initiator Policies & Multi Pathing
Impementing iSCSI multi-pathing and redundancy policies
2012-03-09
4,013 reads
Solid State Disks and SQL Server
An interesting result from a recent test of SSDs in SQL Server by Wes Brown. A surprising discovery is important for anyone thinking about using SSDs to know.
2012-03-09 (first published: 2010-04-08)
36,264 reads
Working with Variables in SQL Server Integration Services
There are a number of ways that you can incorporated variables into your SSIS Scripts. Robert Sheldon demonstrates how.
2012-03-09
3,911 reads
Blogs
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Forums
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Azure SQL Database | CREATE EVENT SESSION [Blocking_Capture] ON DATABASE
Hello, Is there a way in Azure SQL Database to change the 'Blocking Process...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers