Today we have a guest editorial from Andy Warren as Steve is out on holiday.
Back when I became a DBA I was involved in everything. I worked on the hardware evaluations and purchase decisions, everything from memory and storage to network cards. I decided on the RAID type, stripe size, and more. I was a backup to the server team and was a domain admin so I could both provide coverage and just get things done when needed. I did the SQL Server installs, upgrades, and patches, and I consulted with the developers on everything from design to performance to security. I went to class to learn clustering and SAN administration, more to understand how they worked than an expectation that I’d be doing in on any kind of regular basis.
Today I work with a team where I’m a DBA but I don’t do the installs or the service packs. I don’t have anything to do with storage besides asking for more when needed. I don’t build or patch the servers, I don’t build clusters. It’s all handled by the server/operations team, a team that doesn’t contain a single DBA. It’s more and more common, and I think a good thing if you have the staff to do it. I don’t feel like any less of a DBA because someone else does the service packs!
I was struck by a recent conversation with one of those team members who remarked that they didn’t like that the DBA team had direct access to the server because we could make a change that would bring down the server. I had to laugh. I get the urge/need to limit access, and I’ll get by with whatever access I am handed, but in my biased view bringing down the server pales in comparison to the kind of issues that a DBA can cause with a single mistake.
If you think about it, that’s a lot like what we get in cloud solutions today. We’re abstracted from the hardware and the storage and just about everything else that isn’t a direct component of SQL Server. It feels like a loss of control, and it is of course, but it also means that we can just focus on the database. It doesn’t mean that mistakes or under provisioning won’t cause us pain, but as a service we can just identify it and then wait for whatever team owns it to fix it.
If I had a choice, which way would I have it? I’m reluctant to admit it, but I like the way things are today. What about you – do you like being ‘just’ a DBA, or do you yearn for (or still have) your fingers in a lot more pieces of the technology?
SQL Server 2014 offers In-Memory OLTP, but you may be hesitant to use this because of the lack of support for constraints on Memory-Optimized Tables. In this tip we will see how we can solve these issues. More »
It’s funny to me how easy it is to fail a phone screen – both as the interviewer, and as the... More »
Question of the Day
Today's Question (by Steve Jones):
If I wanted to avoid matching a character, which wildcard would I use inside the square brackets?
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
1 point in this category: T-SQL.
We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the
Securing SQL Server
Written by Denny Cherry, a Microsoft MVP for the SQL Server product, a Microsoft Certified Master for SQL Server 2008, and one of the biggest names in SQL Server today, Securing SQL Server, Second Edition explores the potential attack vectors someone can use to break into your SQL Server database as well as how to protect your database from these attacks. In this book, you will learn how to properly secure your database from both internal and external threats using best practices and specific tricks the author uses in his role as an independent consultant while working on some of the largest and most complex SQL Server installations in the world. This edition includes new chapters on Analysis Services, Reporting Services, and Storage Area Network Security.
It's Thanksgiving in the US. Assuming we have a table of colors associated with holidays, what should be returned by this query?
SELECT sales = color + ' ' + datename( dw, DATEADD( d, 1, GETDATE()))
WHERE holiday = 'Thanksgiving'
Answer: Black Friday
The Friday after Thanksgiving is known as Black Friday in the US. This is the day that many retailers begin their Christmas shopping season with sales and deals.
Since today is Thanksgiving, Thursday, November 28, 2013, the GETDATE() should return this date. The dateadd should move the day to Novermber, 29, 2013 and the DATENAME should return "Friday". I am hoping you realize which day this is and therefore our table should contain a row with "Black" and "Thanksgiving" in it.
Duplicate row data on condition...
I have a table with following structure:
SaleId INT, SaleRowId, TaxCode INT, TaxValue INT, Price INT, ExtraTaxCode INT, ExtraTaxValue INT
- Hi all,
I attempted to perform a backup and ended up with error message:
TITLE: Microsoft SQL Server Management Studio
Backup failed for...
I can't nested some node in XML output
I have this xml structure
<?xml version='1.0' encoding='iso-8859-1'?>
<Pedido ID_PEDIDO="P500000999" COD_SAP="50000999" N_AMPL="001" NOM_NOMBRE="COMP.HOSTELEROS LAS BRUJAS,S.L." CANAL="G" NOM_PROVINCIA="Ciudad Real" FEC_ULT_ERROR="2012-08-09T04:22:10.960" DESC_ULT_ERROR="Error de...
KB Knowledge Store
- I would be instrested to hear from fellow SQL DBA's BI etc..
Where do you store your notes ?
By notes I...
- Okay, a topic that has NOTHING to do with SQL . . .
Came across [url=http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx]this link[/url] describing the SSC point scoring descriptions,...
Today's Random Word!
When you woke up today, or logged-onto Opera Forums, you may have had a dream, a thought, a scene...
Looking for a Sr. SQL DBA out of SF
- Contact: Amber.Richard@staffmark.com
Phone: (925) 969-4433
Searching for a Senior level SQL DBA. This is a F/T or contract-to-hire position. SQL...
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.