New SQL Server Show Posted
The weekly SQL Server show has been posted – we look at injection protection and recovery today, along with server protections, data warehousing for the rest of us, events, tips, trick, news and more.
Featured Article(s)
Oracle 2-Day DBA in x Days Post 4; Getting Enterprise Manager (dbconsole) to work
It seems we can’t get around this so we better get Enterprise Manager working before going any further.
Thanks to Our Survey Prize Partners!
I wanted to say thanks to our great partners – check out their products below – they have some amazing tools! The survey will close tomorrow (Friday, 4/4/2008) at midnight.
Take the survey here, enter in the drawing.
Ten (10) $50 cash prizes
Five (5) 5-Year SSWUG.org Memberships
Two (2) Lifetime SSWUG Virtual Conference Passes
One (1) SQL Farm Combine – Unlimited user license + 1 yr of maint. & support, (SQL Farms ~$5,000 value)
One (1) DataDefractor Developer edition. -12 month license (InteractiveEdge)
One (1) SQL defrag manager or SQLsecure free license – Choice of (1) (Idera)
One (1) Event Manager for SQL Server – Enterprise Edition license + 1 yr maint (SQL Sentry – $1,194 value)
One (1) PowerGadgets license, or (1) license for Chart FX – Choice of (1) (SoftwareFX)
One (1) Sql Power Tools Enterprise License 2.0 with 3D Visualization – (SQL Power)
One (1) Performance Monitor license – (Teratrax)
One (1) Change Director for SQL Server – 12 month Server License (Quest – $1,200 value)
Here’s a direct link to the survey. It shouldn’t take long at all – and the prizes are substantial!
DBA "Industry" Changes
I wanted to pass along one response that was really intriguing about the whole "Are DBA roles changing?" question. I think it would be classified as "It just works" but…
Charles: "The firm I work for handles several large sales and revenue reporting applications for a Fortune 50 client. We routinely deliver applications on servers built from desktop grade components bought locally. These "servers" will run between 1 and 6 applications and will carry 50 or 60 separate SQL databases.
Our developers and project managers are typically hired from better liberal arts schools. We are supporting all this with Off the shelf installs of MS SQL server 2000 or 2005 …. and with fairly green staff who have not been trained formally in SQL Server or DB development.
There is a firm belief in our firm that we need one senior level DB/Developer around, but honestly, that role is more of a good luck charm. These are not small databases, 8 to 12 GB of data is typical, And several of the DB’s contain all the sales and marketing data for the past 12 months for a fortune 100 client ….
I’d say for our firm the future is now. We install SQL Server, and start using it, and we have several projects delivered without active involvement of a Sr. SQL DBA."
Now, no offense or accusations to Charles, honestly. The question that comes to mind with this for me – do we run an increasing risk of not being able to keep up with security issues, best practices, compliance requirements changes and such without a dedicated DBA watching over, or is that a commodity-type thing now (or in the near future)?
Drop me a note with your thoughts.
Featured White Paper(s)
7 Ways to Improve Your Database Server’s Performance by 60%-80%
Sql Power Tools White Paper reviews 7 steps you can take to improve your database server’s performance. With production datab… (read more)
SQL Server 2008: What to Expect
Microsoft SQL Server 2008 has many great new features that will allow you to develop higher performing, more scalable next-ge… (read more)