SQL Server Reporting Services, set for release by the end of the year, will fill the only hole in the SQL Server product--the lack of a built-in reporting component. Here are Reporting Services' seven most important features....More
ADO.NET connection pooling improves the performance of .NET applications, but a busy application can sometimes accumulate connections, overflowing the pool and sinking performance. Here's how you can keep a watchful eye on your connection pools....More
Brian Moran talks about tracking configuration changes and settings within the servers and databases you support, learn about importing an MXL file, get the results of our latest instant poll and more!...More
Brian Moran thanks his fellow MVPs for all their hard work, learn about the buffer-overrun vulnerability in MDAC, find out how to share data between two sites, get the results of our latest instant poll, and more!...More
Brian Moran has gained a new appreciation for the value of stored procedures exposed as Web services. Will this functionality, which Microsoft will enhance in Yukon, make his current theory of extreme performance irrelevant?...More
An option when creating new AlwaysOn Availability Groups is to specify Backup Preferences.
It’s also something you can easily configure once the Availability Group has been set up as well – by simply right-clicking on the Availability Group and selecting Properties – then navigating into the Backup Preferences tab. ...More
The quest for the Golden Record to achieve a single, accurate and complete version of a customer record is worth the pursuit to attain survivorship. Record matching and consolidation are only the beginning. Melissa Data takes a new approach. Learn how to apply intelligent rules based on reference data to make smarter and better decisions for data cleansing....More