SQL Server Magazine March 2005
[Focus]
Change control isn't just for developers; you can use it to manage your database schema as well. Just follow these 7 steps to get a handle on your database changes.
By Michelle A. Poolet
Use this checklist to ensure that your ADO.NET applications are the best they can be.
By Michael Otey
Before you start using CLR extensions in SQL Server, you need to consider "why" and "how" in addition to "what" you need to do.
By Gert Drapers
You’re overworked already. You know you could use some best practices to optimize your system, but who has the time to search them out? Answer: we do. Check out these tips from SQL Server experts and let them simplify your life.
By Editors
Everything you need to know about log backups in one handy checklist. What could be easier?
By Kalen Delaney
For better security on your reporting system, make sure to follow these steps.
By Peter Blackburn
Check out these best practices that can help your T-SQL code run smoothly and efficiently.
By Itzik Ben-Gan
[Features]
SQL Server 2005 Integration Services has new features that simplify package creation and editing. Walk through the package-modification process and see how you can effectively create new packages without reinventing the wheel.
By Kirk Haselden
Sp_who and its cousin sp_who2 give DBAs crucial information about SQL Server user connections and processes, but they have limited filtering and block-finding capabilities. Welcome sp_who1, a new member of the sp_who family that tackles those limitations.
By Richard Ding
[SQL Server Savvy]
A bug in SQL Server 2000 Service Pack 3 (SP3) causes you to lose Performance Monitor counters if System Monitor is running from the performance console when you stop SQL Server.
By Brian Moran
People often forget tempdb's effect on query performance. People also neglect to manually set tempdb to an adequate size.
By Brian Moran
Don't assume that AWE is working in SQL Server unless you verify that it's enabled and using the amount of memory you expect. Also, make sure that you set the max server memory option by using sp_configure.
By Brian Moran
What's the best way to configure SQL Server to handle large amounts of memory, and how do I know when to use the /3GB switch?
By Brian Moran
[Editorial]
Passwords are essential to security, but are they always safe? Maybe it's time to consider pass phrases for your system security plan.
By Michael Otey
[Inside SQL Server]
Shrinking a data file may seem straightforward compared with the intricacies of shrinking the log, but some of DBCC SHRINKFILE's hidden nuances can give you a serious performance hit.
By Kalen Delaney
[T-SQL Black Belt]
You can find all sorts of solutions to this T-SQL problem, but the most intuitive might not be the best. You may have to step outside the box to see the pattern.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products.
By Dawn Cyr
[SELECT TOP(X)]
Michael Otey's ten favorite SQL Server Web sites.
By Michael Otey
[Ask Microsoft]
Microsoft's Patrick Conlan explores two options for using object aliases in database applications to execute queries on remote servers.
By Microsoft's SQL Server Development Team
Microsoft's Vaqar Pirzada explains how to use sp_helparticle to list all a publication's articles in transactional or snapshot replication setups.
By Microsoft's SQL Server Development Team
|
