Migrating SQL Server Databases - The DBA's Checklist (Part 3)
The final part of the series will examine full text catalogs and indexing, database collation, service broker considerations, encryption and high availability.
2009-10-02
3,303 reads
Migration
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
Migrating SQL Server Databases - The DBA's Checklist (Part 1)
Migrating a database is often a task fraught with complications, this series examines the key issues in a simple checklist.
2009-09-16
3,369 reads
Ten steps to migrate databases between servers in a .Net environment
How to move databases from one server to another with limited downtime
2009-08-17
7,955 reads
Migrating A SQL Server 2005 Reporting Services Named Instance, The Missing Manual
Microsoft has always been pretty good at one thing, ease on install. One of the things I always says is the greatest thing about SQL Server is any idiot can install it. The other thing I also say is the worst thing about SQL Server is any idiot can install...
2009-07-01
4,332 reads
Large Analysis Database Migration
large Analysis Database migration (hundreds of gigabytes, hundreds of users and thousands of user MDX queries)
2009-04-14 (first published: 2009-04-13)
3,126 reads
RE: AWE and MaxMem settings for SQL2K on WS2003-OS Clustered
From MSDN:On 32-bit versions of Windows, PAE is disabled by default. You must use the /pae boot parameter to enable PAE. However, PAE is automatically enabled when the computer is configured for hot-add memory devices in memory ranges beyond the 4 GB region, as defined by the Static Resource Affinity Table (SRAT). Hot-add memory supports memory […]
2005-05-23
RE: Performance Problem
Just wondered if you are seeing an IO bottleneck. RAID 5 is hella slow, can you check out a perfmon, see if you are getting disk queuing?
2005-04-28
RE: SqlServerAgent cann''''t see mail profile only created with Outlook
Or you could forget the hassle of setting up the profiles and use xp_smtp_sendmail from www.sqldev.net
2005-04-20
RE: Missing performance counters for one instance
Thanks, Scott, that's excellent information! I don't have a place to reproduce the problem now but I suspect that it was as you and Mike suggested. I've since installed MS-03-031.
2005-04-12
Blogs
Back to Boston for SQL Saturday
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
T-SQL Tuesday #179: What’s In Your Data Detective Toolkit?
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
The Future of the Social Web Is in Good Hands
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers