Adding a log shipping monitor
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,107 reads
Articles
Using The AlwaysOn Feature of SQL Server 2012
This is the first in a four-part series on the new AlwaysOn feature in SQL Server 2012. In this article, AlwaysOn is introduced and contrasted with previous high-availability solutions in SQL Server. The second part of the series will commence with a detailed walkthrough on preparing the environment for AlwaysOn
2012-03-15
3,949 reads
Basics of XML and SQL Server, Part 2: Shredding XML
In Part 2 of this series we will shred an XML document and insert its records into a SQL Server table using both the OpenXML and XQuery methods.
2012-03-14
18,179 reads
No Significant Fragmentation? Look Closer…
If you are relying on using 'best-practice' percentage-based thresholds when you are creating an index maintenance plan for a SQL Server that checks the fragmentation in your pages, you may miss occasional 'edge' conditions on larger tables that will cause severe degradation in performance. It is worth being aware of patterns of data access in particular tables when judging the best threshold figure to use.
2012-03-14
3,229 reads
Webinar: SQL Source Control 3.0 Connect your existing source control system to SQL Server
Find out what SQL Source Control & SQL Compare can do for your database development and deployment processes at one of our free weekly webinars. Each webinar includes a 30 minute software demonstration and a Q&A session.
2012-03-14 (first published: 2012-01-10)
6,184 reads
2012-03-13
22 reads
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,812 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,880 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
Blogs
Runing tSQLt Tests with Claude
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Getting Your Data GenAI-Ready: The Next Stage of Data Maturity
By James Serra
I remember a meeting where a client’s CEO leaned in and asked me, “So,...
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Forums
The Long Name
Comments posted to this topic are about the item The Long Name
Eight Minutes
Comments posted to this topic are about the item Eight Minutes
T-SQL in SQL Server 2025: Fuzzy String Search I
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
The Long Name
I run this code to create a table:
When I check the length, I get these results:
A table name is limited to 128 characters. How does this work?