The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Dave Campbell opines on SQL Server 2008, Madison, Kilimanjaro, Azure, and the future of data storage and delivery.
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 Michelle A. Poolet
Learn what to look for if you’re pulling data from a legacy nonrelational database.
Enhancements to CLR table-valued user-defined functions in SQL Server 2008
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
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
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 Sheila Molnar
Dave provides insight into Microsoft’s upcoming business intelligence and cloud computing products, as well as SQL Server 2008.
By John Green
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.
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 Craig Utley
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.
advertisement