SQL Server Magazine April 2008
[Features]
Build efficient queries using LINQ, which is included in Visual Studio 2008.
By William Sheldon
Get answers to your questions about SQL Server 2005 Surface Area Configuration tools that can help you protect the SQL Server surface area from security breaches perpetrated by unauthorized users or applications.
By Pinalkumar Dave
Using a database named MyDB, a table named MyTable, and some dummy tables, you can learn how to create T-SQL queries that insert new data, update existing data, and delete old data.
By Bill McEvoy
[Editorial]
Find out how Sun Technologies' acquisition of MySQL means for the database market.
By Michael Otey
[Reader to Reader]
If you have to perform a full index analysis, here are two T-SQL stored procedures you can use to get detailed information about the indexes in a single table or an entire database.
By Bill McEvoy
[Inside SQL Server]
Uncover more valuable metadata that can aid you in troubleshooting and performance-tuning your queries.
By Kalen Delaney
[Solutions by Design]
Save yourself from having to deal with large, difficult-to-manage fact tables by partitioning the rows.
By Michelle A. Poolet
[T-SQL Black Belt]
Circumvent unsupported logical phases, work around SQL Server 2005’s lack of INTERSECT ALL and EXCEPT ALL, and take advantage of the INTERSECT and EXCEPT operations’ treatment of NULLs.
By Itzik Ben-Gan
[New Products]
Check out new and improved SQL Server-related products from Datanamic Solutions B.V., CNS International, Caber Computing, and Microsoft.
By Jeff James
[SELECT TOP(X)]
While SQL Server Magazine can give you info on SQL Server 2008, Microsoft's Webcasts also assist. Here are some links to our favs.
By Michael Otey
[Review]
A SQL Server expert takes a detailed look at three popular SQL Server backup compression tools.
By Allan Hirt
[PTO for the Rest of Us]
You know how to collect and report on wait stats. Now, let’s focus on a few wait stats that typically account for most overall system waits.
By Andrew J. Kelly
[Sqlmag.com Community Dialog]
Readers share their thoughts about recent Community Dialogs, and Itzik Ben-Gan helps a reader out by creating a special "lottery" query.
By Anne Grubb
|
