Partitioning - Part 2
Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.
The Train to Katmai
We don't have a release date, the final feature set has yet to be released, but slowly I can see the train building steam. This week I found a number of blogs starting to look at various aspects of SQL Server 2008. If you look through the newsletter, you'll see coverage of data compression, clustering […]
Why We Like SQLServerCentral
We reached the half million member milestone last week and had a contest. Read on to see the winners.
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part 3
Part 3 of this series illustrates how to script PowerShell cmdlets and execute them. Scripting is essential for automation and executing repetitive tasks.
Write custom trace files in TSQL
SQL Server 2005's default trace is great for monitoring system information and for finding out what happened on your server after problems occur. However, there are times when the events that the default captures are not what you need. Here are instructions for how you can create your own trace files in TSQL to catch events on your database machine.
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part II
Part II of this series discusses more about PowerShell and its features in conjunction with SMO.
SQL Server Spotlight on Buck Woody
One of the people responsible for Books Online in SQL Server 2005 takes a few minutes to share some thoughts with SQLServerCentral.com
Enterprise Architecture: Connect-the-Dots for Adults
Developing an enterprise architecture can be viewed as connect-the-dots for adults. However, in doing so, all you get is a pretty picture and not a management tool that can help an organization understand and manage itself.
Microsoft Windows PowerShell and SQL Server 2005 SMO – Part I
As you probably know, Windows PowerShell is the new command shell and scripting language that provides a command line environment for interactive exploration and administration of computers. In addition, it provides an opportunity to script these commands so that we can schedule and run these scripts multiple times.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
Increase Deadlock Detection
Comments posted to this topic are about the item Increase Deadlock Detection
A Tool is Better than a Script
Comments posted to this topic are about the item A Tool is Better than...
Understanding Deadlock Victim Selection in SQL Server
Comments posted to this topic are about the item Understanding Deadlock Victim Selection in...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers