Learn about the mysterious Incremental Service Model for automatic notification of SQL Server hotfix Cumulative Updates. Plus, check out the TechX Interoperability Web site and newsletter, join the discussions on our forums, and more!
Learn how improvements in Microsoft System Center Data Protection Manager 2007 Beta 1 make this product worth watching. Plus, read about the real value of BI technologies, check out the new Windows Live search macro for SQL Server, and more!
Learn how giving IT presentations can boost your reputation as an expert among your peers and help you further your career. Plus, get creative solutions to Reporting Services’ limitations, figure out a high-wait-status problem, and more!
Learn how Microsoft MVPs spread the news about upcoming product improvements and also help shape the future of those products. Plus, learn how tempdb affects performance, get part 2 of Itzik Ben-Gan's DATETIME Calculations article, and more!
Oracle’s acquisition of Hyperion Solutions could be the first in a series of aggressive acquisitions in the BI and applications markets. Plus, learn to build dynamic IN lists, handle connection problems, and more!
Presenting at a conference can force you to become an expert in a topic, so submit your proposal for the 2007 PASS Community Summit. Plus, automate date/time conversions, improve Books Online, and more!
Not sure if you should bother downloading SQL Server 2005 SP2? Take a look before you make up your mind. Plus, use trimming to return only the date or time of a given datetime value, write a shorter query for combining records, and more!
A recent Gartner report delves into upcoming trends in the growing BI market. Plus, read about Microsoft's plans for end-to-end business insight, Itzik Ben-Gan's analysis of missing language elements in SQL Server, and more!
In a sea of white-paper oysters, Microsoft has released some true pearls of wisdom for getting great performance from Analysis Services 2005. Plus, join in the search for Jim Gray, learn whether you can force a parallel query plan, and more!
There will always be a need for trained performance-tuning professionals, but quad-core technology simplifies one aspect of the quest for better performance. Plus, learn about Native XML Web Services in SQL Server 2005, and more!
SQL Server Compact Edition is fundamentally different from other editions. Here's what makes it special. Plus, a new email newsletter helps you keep track of Windows Vista, dig into the solution to the January Reader Challenge, and more!
How will a large show such as Microsoft's first-ever BI conference affect attendance at other independent shows? Plus, learn where to download the newly release SQL Server Compact Edition, weigh in on the future of MSDN and TechNet, and more!
Explore how widespread adoption of BI through tools like Swivel will affect the impact of “real” BI in the business world. Plus, read about the release of Visual Studio 2005 Tools for the 2007 Microsoft Office System and more!
Is Swivel just another way to fritter away time on the Internet or is it really the way that BI will become available to the masses? Also, check out the new SQL Server Best Practices Web site, ring in on this month's Reader Challenge, and more!
Important post migration tasks are outlined in part III of this series on the steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or migration....More
Here's Part II of an overview of actual steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or migration. Part II covers preparing databases for migration, 13 migration steps, and failback tips....More
Get an overview of actual steps you'll want to use when demoting an older server and promoting a newer server as part of a SQL Server upgrade or migration. Part I addresses guiding principles, acceptance testing, and your communication plan....More