Main Page
From SQLServerPedia
|
Updates This WeekMichael Lato did a webcast on performing application upgrades, and added his code at Table Compare Script and Deployment Script Sample. SQL Server Backup Tutorial - we explain the differences between full backups, differential backups, log backups, database mirroring, and SAN snapshot replication. SQL Server Consolidation Tutorial - consolidating your SQL Servers saves money and can make management easier. We talk about the risks, payoffs and pitfalls. SQL Server Perfmon Monitoring Tutorial - Perfmon helps you find your SQL Server bottlenecks like CPU, memory, disk and network. Damon Clark added some of his scripts: a T-SQL script for string formatting of numbers and searching for strings in SQL Server objects. Michelle Ufford of SQLFool.com contributed a great set of T-SQL scripts to defrag indexes on SQL Server 2005 and 2008. Want to write articles for SQLServerPedia? Check out the latest list of Article Requests. SQL Server Expertise in Wiki FormWe're a wiki, like Wikipedia: all of the information you see here is freely editable by any logged-in user. Anyone can contribute to articles, add new code, edit articles, you name it. This site is by the community, for the community. Changes are moderated by our Editors, a group of SQL Server database professionals with a decade or more of experience in their field. The Quest SQL Server Business Unit VP, Billy Bosworth, explained why we're doing it in his article How SQLServerPedia is Different. If you've got questions about anything you see here, or if you've got ideas for future webcasts, feel free to email us at ask@sqlserverpedia.com. Thanks, and enjoy the site!
|
Top SQL Searches
SQL Server Date |