The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Migrating to SQL Server is an increasingly difficult task to prepare for and accomplish. SQL Server Migration Assistant can help you outline tasks, convert PL/SQL to T-SQL, migrate datas, test migrated objects, and deploy your migrated database.
By
The procedure cspBackupListing can list your databases’ most current backups, back up databases with previous backups older than 24 hours, or list all the backups for a database.
By Omri Bahat
By gathering information from sysprocesses and running KickUserOut.sql, you can terminate processes that are impeding a server's performance.
By Itzik Ben-Gan
Get the solution to August's puzzle "Prisoners and Switches," and prepare your mind for September's puzzle, which involves the numbers of hairs on Chinese heads.
By Michael Otey
Language-Integrated Query (LINQ) is the long-awaited wave of the future, and its benefits definitely outweigh its drawbacks.
Last month's discussion was pretty theoretical. Now, we dig deeper by offering concrete examples to clarify the topic of temporary objects.
By Andrew Sisson
Do you want to move to SQL Server from Oracle, but aren't sure how difficult the data conversion and migration will be? Find out how SSMA for Oracle can help you more easily move to SQL Server.
Here's a preview of SQL Server 2008 features that just might add a smile to your face: enhanced Microsoft Office integration, the ability to hot-add CPUs, and more goodies DBAs are sure to welcome.
By Blake Eno
Check out new and improved SQL Server–related products.
If you often need to display the current date in different formats, you know that it can take a lot of code and effort. The FormatDate function changes that. By providing just two parameters, you can display any date in the format you need.
By John Green
Need some help with SQL Server database recovery and log auditing? Our review of ApexSQL Log will help you decide whether this app fits your needs.
By Douglas McDowell
Your SAN engineer might not know the finer points of BI database storage. To stave off trouble, you need to be involved in the SAN configuration process.
By Andrew Kelly
This built-in SQL Server 2005 DMV lets you see exactly what type of physical I/O your SQL Server system is experiencing when you're reading from or writing to the files on disk. Learn how to get the most out of it.
By Jeff James
Enhancements in SQL Server 2008 will make every action auditable and provide transparent data encryption.
An emerging selection of software- and appliance-based products augment SQL Server 2005’s basic auditing capabilities, to help you keep data secure and in compliance with government regulations.
By Kevin Kline
Microsoft makes available a variety of scripts that its own Database Operations team uses for automating maintenance jobs—and they're free.
By Anne Grubb
Rodney Landrum reaches out to readers who needed help following the steps in his article.
By Kalen Delaney
By using both TEMPLATE plan guides, which enable autoparameterization, and SQL plan guides, which let you specify many query-processing hints, you can optimize query performance.
By Michelle A. Poolet
With dimensional modeling, you can build a user-friendly data structure that makes data access intuitive. Start by learning the components of the dimensional model and why they're designed as they are.
advertisement