Featured Script
admin db – meaningful Agent job notification
If you want to konw the real failure message when a job fails and you want to maintain a history of job failures (and succes… (read more)
Interested in Learning About SQL Server Security?
Check out our upcoming virtual workshop! In the workshop, we’ll be going through things to know, SQL Server injection protection, overall security and best practices information and a lot more. This is not a sales presentation, it’s all technical and is several hours long – we’ll be covering a lot of ground (yes, there are breaks). At the end of the workshop, you can review materials, take the quiz and get a certificate for completing it. I’ll be available throughout for live Q&A and to make sure it all makes sense. This workshop is brought straight to your desktop and is practical, applicable information you can use immediately.
I hope to see you there – make sure you register here and save the date!
What is the Role of a DBA Today?
This is a constant and recurring topic; as changing as the features of SQL Server itself; as changing as the needs of business; as changing as the adoption of the Microsoft BI Platform reaches deeper into small, medium and large businesses.
Viewing recent job postings on DICE it appears that the role from a hiring perspective has changed dramatically. The posts seem to fall into two categories.
1) Database Systems Admin
2) BI Developer
The DB Systems admin role, as defined in the job descriptions, emphasize planning, monitoring, performance tuning and disaster recovery (clustering, backup, restoration and alerts).
The BI role has changed some. Previously (read as 3+ years ago), emphasis was on database design, TSQL, SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS). Today, emphasis is on both OLTP and OLAP design with emphasis on the data warehouse. SQL Server Analysis Services (SSAS) is almost always a requirement. They want the whole stack and more.
The solo role for OLTP database design, development and tuning is almost non-existent.
So, can you do it all? Can one person really do all these roles effectively? Can one person be strong, nay, an expert, in NT, Clustering, SANs, replication, mirroring, OLTP database design, OLAP database design, TSQL Queries, SSIS, SSRS, SSAS, DMX Queries, MDX Queries?
Hey, wait, I forgot CLR .net integration and SharePoint Services along with many other features of SQL Server and the MS BI Stack?