SQL Server Magazine February 2009
[Focus]
Dave provides insight into Microsoft’s upcoming business intelligence and cloud computing products, as well as SQL Server 2008.
By Sheila Molnar
[Features]
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.
By Craig Utley
[Editorial]
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 departmental database; easy to use but not enterprise-ready. How things have changed.
By Michael Otey
[Solutions by Design]
Learn what to look for if you’re pulling data from a legacy nonrelational database.
By Michelle A. Poolet
[T-SQL Black Belt]
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 Itzik Ben-Gan
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 binary to character values while preserving the hexadecimal digits.
By Itzik Ben-Gan
[SELECT TOP(X)]
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 Escalation Services team.
By Michael Otey
[Tool Time with Kevin Kline]
Use these utilities to check your environment for vulnerabilities that could put your websites and databases at risk for SQL injection attacks.
By Kevin Kline
[Review]
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 review will help you decide which one you want.
By John Green
|
