Multi-Tenant Data Architecture
The second article in our series about designing multi-tenant applications identifies three distinct approaches for creating data architectures.
2009-09-24
3,979 reads
Additional Articles
Performance Improvement: Understanding
I'm going to try to lay out some general guidelines for performance improvement through improving understanding about what performance is, how to measure it, and finally solutions to common problems. This article will cover the core understanding of the performance conversation.
2009-09-24
3,790 reads
Service Broker example on how to configure, send and receive messages
SQL Server 2008 and 2005 offer the Service Broker feature. In this tip we will go through the different components of service broker and step by step on how to setup Service Broker for a single database.
2009-09-23
3,250 reads
Ten Pitfalls In Establishing An Enterprise Architecture
Avoiding getting snared in these traps avoids having to spend a lot of money later to fix problems, Gartner says. In addition, EA benefits can be realized faster and the risk of program failure is reduced.
2009-09-23
4,327 reads
Keep Your SQL Server Indexes Fragmentation Free
Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.
2009-09-22
5,457 reads
Migrating SQL Server Databases - The DBA's Checklist (Part 2)
Part 2 of the database migration series examines setting database options, mapping database users to logins, recovery models, backups, and changing the code associated with configurations.
2009-09-22
2,503 reads
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
2009-09-21
2,211 reads
Best Practice - Increasing the Number of SQL Server Error Logs
By default, there are six achieved SQL Server Error Logs along with the ERRORLOG which is currently used. However, it is a Best Practice to increase the number of SQL Server Error Logs from the default value of six. In this tip, you will see the steps which you need to follow to increase the number of SQL Server Error Logs.
2009-09-21
3,332 reads
Python for the SQL Server DBA
Python is increasingly used by DBAs as a general-purpose scripting language, despite the pressure to adopt Microsoft's PowerShell. They find it easy to learn, powerful, and reasonably intuitive. Here Timothy Wiseman, a working DBA, explains the attraction of Python and gives a general introduction to the language, suitable for anyone who has been wondering whether to give it a try.
2009-09-18
5,678 reads
Using SQL Server 2008 Reporting Services with the.NET Framework Data Provider for Teradata
This article discusses the connectivity and usage of Teradata database servers and the .NET Framework Data Provider for Teradata with Microsoft SQL Server 2008 Reporting Services (SSRS).
2009-09-18
2,924 reads
Blogs
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
4 CPE Opportunity (Virtual) for Charity
By Brian Kelley
Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...
Data Céilí 2026 Call for Speakers!
Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...
Forums
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
UNISTR Basics
Comments posted to this topic are about the item UNISTR Basics
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers