By Itzik Ben-Gan, 02/18/2009
SQL Server 2008 provides several small T-SQL features, such as an enhanced VALUES clause, improved ISO week number calculation, and the ability to convert character to binary and ...
By Michelle A. Poolet, 01/22/2009
Learn what to look for if you’re pulling data from a legacy nonrelational database.
By Itzik Ben-Gan, 01/20/2009
Enhancements to CLR table-valued user-defined functions in SQL Server 2008
By Itzik Ben-Gan, 01/20/2009
Use a Common Language Runtime (CLR) split user-defined function (UDF) or SQL Server 2008’s new table-valued parameters to handle arrays as inputs.
By Kevin Kline, 01/15/2009
Use these utilities to check your environment for vulnerabilities that could put your websites and databases at risk for SQL injection attacks.
By Michael Otey, 01/13/2009
SQL Server Magazine launched in the SQL Server 7.0 timeframe. In 1998 SQL Server was a distant third in the enterprise database market and was regarded as a small-scale ...
By Sheila Molnar, 01/08/2009
Dave provides insight into Microsoft’s upcoming business intelligence and cloud computing products, as well as SQL Server 2008.
By John Green, 01/06/2009
Your SQL Server could be vulnerable to attack, but how would you know? AuditPro Enterprise and AppDetectivePro are database vulnerability scanners that can tell you, and this ...
By Michael Otey, 12/18/2008
Get help with troubleshooting SQL Server problems from this gem of a resource—the SQL Server Engineers blog, offering posts from the Customer Service and Support (CSS) SQL Server ...
By Craig Utley, 11/21/2008
It’s easy to create a usable and high-performance set of cubes with SSAS as long as you know the pitfalls to watch out for and possess the patience and savvy to thwart them.