Do you know what you want to be when you grow up? Browsing the list of the new specializations for Microsoft Partners might spark your imagination. Plus, see who was named IT Pro of the Month, check out a better logging tool for DTS, and more!
Learn about Microsoft's dramatic improvements in SQL Server security, check out the launch of Windows Vista and the 2007 Office system, use the RECOMPILE query hint to solve parameter sniffing problems, and more!
Last week, Microsoft announced the SQL Server 2005 SP2 CTP. Check out the preview and learn about the new SQL Server enhancements coming your way. Plus, learn about Microsoft's other important product milestones, take the Reader Challenge, and more!
If a rising tide floats all ships, database professionals on the good ship SQL Server should see their own fortunes rising on the strength of Microsoft’s database platform. Plus, check out the Database Publishing Wizard and more!
Follow Brian Moran as he traces the footsteps of two illustrious SQL Server gurus, check out the debut of Kevin Kline's new Tool Time forum and column, make the most of ASP.NET login controls, and more!
Businesses are increasingly exposed to risk because they lack the readiness to handle core data-management problems. See how a shared DBA model could help. Plus, get the answer to the Catch That Bug puzzle and more!
The TPC’s new specification, TPC-E, strives for a more real-world simulation. Plus, check out the latest Catch That Bug! T-SQL puzzle by Itzik Ben-Gan, find out the top 10 things you'll learn at TechX World, and more!
When is a database not a database? And where does SQL Server the database start and SQL Server the application server end? Explore these questions, learn to handle interoperability with humor, read FAQs about SQL Server Everywhere, and more!
Concentrating on testing is one of the most challenging tasks for developers. I've lost count of the number of times a developer has raced into my office to tell me that a piece of software is done, only to race back out of my office when I ask, "Have you tested it?"
Does the SQLCLR give devious barbarian developers a way to overrun our relational database strongholds? We don’t know yet--learn why. PLUS: Solve your database interoperability problems with strategies you learn at two upcoming events!
A recent IDC report hails the start of a new wave of BI expansion. Reading the report give you what you’ll need to know as a database professional. ALSO: Send your solution to this week’s new T-SQL puzzle by Itzik Ben-Gan!
EnterpriseDB, an open-source database, provides a compelling motivation to try moving Oracle database shops toward open source. What does this mean for you? Plus, learn to use Reporting Services to access Analysis Services cube data, and 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