Although Microsoft introduced the XML data type in SQL Server 2005, widespread use of the new data type has been slow to catch on. Carlo Innocenti, XML Technologies Program Manager at DataDirect Technologies, speculates that the main reason for the slow adoption is simply that most users have been used to storing data in other types.
Good news for DBAs who are entering the field or looking to improve their situation. The article notes a similar demand for Java and .NET programmers. Wonder what kind of dream job is out there for a DBA who can program in .NET and Java?
One of our 2006 SQL Server Magazine Innovators contest winners brought levity to his workplace by developing SQL Server Funeral Services, a procedure that lets users bid adieu to a decommissioned server.
Regardless of whether respondents felt empowered by their daily challenges or overwhelmed by them, they all acknowledged the challenges exist. Here are some of the job stresses that keep you up at night.
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