Penton's IT/Dev Connections, the premier professional training and networking conference for the Microsoft technology community, has announced its 14th annual event will be held September 15-19, 2014 at the ARIA Hotel in Las Vegas....More
Are you confused by all the Microsoft business intelligence (BI) "power" tool names? Here's a quick visual overview to clarify terms and give you a look at what the latest self-service BI tools can do for you.
The object model is the heart of SQL Server Integration Services. As such, it provides a solid base to build custom components. Here are the concepts you need to understand to build a custom data flow component....More
Predixion is a Microsoft partner solution that supplements the base SSAS Data Mining offering with many features that have long been on my wish list. The Predixion Insight solution also has exceptional support and far greater capabilities than the base Microsoft solution....More
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More