Low-Cost High Availability: Simple Database Monitoring in a Windows En
The .NET Framework 2.0 and Visual Studio 2005 make it easy to create a basic but extensible database-monitoring solution without a lot of complexity or coding.
Another Fall Book Sale
We've added a few more bundles to our sale, including a new book: The Best of SQLServerCentral.com - vol. 4. If you're not coming to the PASS 2006 Summit, this is your chance to snag this volume for your corporate bookshelf.
Implementing a T-SQL semaphore
SQL Server does a great job of handling concurrency & ensuring that users can make changes in multi-user systems without conflict. However there are times a strict calling order is needed.
Fine Tuning your Database Design in SQL 2005
Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005
A Guide to Application Memory Tuning
Working with memory in SQL Server and tuning your server for optimum performance gets more complex all the time, especially with the availability of 64-bit platforms. New author Paul Mu brings us a short guide to using the /3GB and PAE switches along with their implications for your server.
End to End Training
The training arm of SQLServerCentral.com is spinning off to its own company. This is the place to come for high quality custom training.
Design Challenge: Global Address
Are you up to the latest design challenge? A great way to sharpen our analysis and modeling skills is to continuously address real-world scenarios. A modeling scenario with suggested solutions appears each month in this Design Challenge column. The scenario is emailed to more than 1,000 modelers. The responses are then consolidated into this column.
How to Schedule a SQL Server Database Creation Script
Scripting out your SQL Server 2000 objects is useful in any number of ways. You can save off the scripts for version control, generate the scripts needed to migrate to new hardware or a new environment, or just package up your application for deployment. Jon Reade brings us a look at the SCPTXFR utility, which can prove very valuable in managing your scripts.
Executing all SSIS packages in a folder: three methods
This article examines a variety of ways in which you can execute all the SSIS packages in a folder.
Migrating From DTS to SSIS - Part 1
In this presentation, Brian talks about the good, the bad, and the ugly of DTS migrations. Then, he shows you how to migrate a simple DTS package to SSIS and some of the challenges you will see.
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Stop Prompting Your AI Agent. Give It a Playbook.
Comments posted to this topic are about the item Stop Prompting Your AI Agent....
Finish the quote
Comments posted to this topic are about the item Finish the quote
Question of the Day
Finish the quote
Finish this quote (for a fun Memorial Day question):
Do not try and bend the spoon. That's impossible. ...See possible answers