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.
Despite similar intentions and high-level goals, the ways in which AlwaysOn Failover Cluster Instances and AlwaysOn Availability Groups tackle high availability and disaster recovery are quite different....More
While AlwaysOn Availability Groups are a powerful solution that let DBAs tackle both high availability and some disaster recovery concerns from within a single, unified, set of technologies and tooling, AlwaysOn Availability Groups also come with a number of challenges....More
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More