 | A community of more than 1,600,000 database professionals and growing |
| | | The Full Stack DBA The last couple of years have seen the job title "full stack developer" posted quite often. With the popularity of DevOps, companies are hoping to hire a developer that can work on the database, understand some networking, and continue to build front end applications. In my career, I've done all of this while being just titled a programmer, but apparently with more specialization these days, some want to differentiate themselves as being able to do it all. I saw this tweet from Erin Stellato, asking if people manage multiple items. Specifically, she asks about "the virtualization, the server admin, the storage, and system security". No networking, firewalls, etc. in there, but I'll add those in as well. This week, can you answer this question: Are there any of you full-stack DBAs? By that I mean you work on more than the database. Do you manage storage at all? Are you a domain admin with AD responsibilities? Do you manage applications or perform some development? Is there any networking in your daily work? I've actually done all of these before. At one startup, my primary responsibility was a database developer and administrator, but I had AD rights and needed to help our sysadmin with Exchange and various other servers. I setup and configured our T-1 line to the co-location facility, and explained how to get two NICs in our SQL Server working so that backups and office access didn't interfere with application access from our web site. I even had to help build new network cables one day. In a few jobs, I've actually been a domain admin, even though I was primarily a DBA. That was because we shared responsibilities and on-call on the team. Even though my primary work was with databases, I ended up helping work on other systems at times. To me, these were welcome distractions and also chances to build knowledge that was useful in troubleshooting and narrowing down the scope of problems. Are any of you still doing that today? Whether you are or not, let us know what types of responsibilities you have at work. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.1MB) podcast or subscribe to the feed at iTunes and Libsyn.  The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. |
|
|
|
| | ADVERTISEMENT | |  | | Redgate University Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning |
|
|
|
| | |  | John F. Tamburo from SQLServerCentral.com There are times when you need to share tables between servers, where the table may be updated in both places. Peer-to-Peer Transactional Replication gives you the ability to create a solution. I explain the benefits and the downfalls. More » |
 | Additional Articles from MSSQLTips.com Learn how to stop the data sync process in SQL Server Merge Replication on a large table during maintenance windows. More » |
 | Over the past year Redgate has released some major improvements to SQL Provision, including the ability to modify images with Data Masker and SQL scripts, and create templates for clones, allowing users to specify SQL scripts to run after creation. More » |
 | Grant Fritchey from SQLServerCentral Blogs It is entirely possible to try to JOIN two tables on almost any field, as long as the two data... More » |
| | Wayne Sheffield from SQLServerCentral Blogs Advent of Code 2018 – Day 2 As I explained in yesterday’s post, I’m participating in this year’s Advent of Code challenge,... More » |
|
|
| | | Today's Question (by Kendra.Little): Which view in perfmon.exe shows you a printed list of the perf counters you are collecting along with the counter values from the most recent sample? |
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: PerfMon. We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center. |
|
|
| |
| ADVERTISEMENT | | Expert T-SQL Window Functions in SQL Server Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today. |  |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): Which of the following is true if you drop a temporary table in a stored procedure?
Answer: Dropping a temporary table causes a rename of the temporary table, which may remain cached Explanation: Dropping a temporary table in a stored procedure is not like dropping a user database table in a stored procedure. The temporary object will be renamed and may be cached for later re-use, if other conditions for temporary object caching are met. Learn more about this in Paul White’s blog post here: click here
» Discuss this question and answer on the forums |
|
|
| Database Pros Who Need Your Help |
| Here's a few of the new posts today on the forums. To see more, visit the forums.
SQL Query to Extract and Merge data - Hell community, Can someone please take a look at the tables in the attached file and help compile a sql query...
Licencing Question with 2 instances and active/pasive - Hi We are after using 2 instances with an availability group in each instance over 2 servers, but want to save... Why do NULLs appear in DMV queries? - Hello experts, I'm learning more about Dynamic Management Views (DMVs) and noticed that sometimes the values for certain seemingly important columns... Availability Group Database - Resize of LOG file causes Transaction Log use to grow significantly - SQL Server 2016 - 13.0.4541.0 Availability group setup with 2 replicas Most databases reside within the one AG. Development server with relatively minimal use at... Queries to practice compilation and recompilation. - Hi expert, Can someone please post here some quires (or simulate recompilation) to practice compilation/recompilation? I would really appreciate. Thanks, Are Database Upgrade Advisor and Data Migration Assistant the same things? - I am confused. Are these tools the same or different? Or it is just a different naming depending on a... Error: 15006 'username' not a valid name because ... - Dear I'm new to SQL and trying to learn the basic in a practical way. The error: TITLE: Microsoft SQL Server Management Studio ------------------------------ Create...
Looping Through Data - Hello, I'm new to SQL. This is what I'm trying to do. If Caller and Call Type is same within the table... Set @rptStartDate = CASE WHEN 'TransactionCount' = 2 Then '11/1/2018' - 30 days Else '11/1/2018' End - Hello again! The issue I am having today is dealing with a date change when certain conditions are met. As... PIVOT operator is not allowed in the recursive part of a recursive common table expression - Hello, i have a little problem. I create an in lined table function and with SQL Server 2008 work fine, with...
Run away logical reads on stored proc causing timeouts. - Hi, I am hoping some one maybe have any insight or suggestions. I have a stored proc that returns 10 to 200...
SQL Server : Parallelism vaules best practice - Hi, We are using SQL Server 2012 having Always on High Availability setup ( Active - Passive nodes) with 2 TB database size. CPU : 8...
SQL Crash "The transaction log for database 'master' is full due to 'CHECKPOINT'" - SQL 2008 instance was running on a VM. It ran out of space so IT decided to shutdown and expand...
Stupid Question: Return Object Explorer to It's original position - Stupid question but I accidentally moved object explorer from it's original default position on SSMS. By default, object explorer is...
DB Env. Refresh - Hi, I've recently migrated from On Prem to PaaS and I has previously created an automated DB refresh from PROD...
adding keywords to SSRS report metadata? - Got a dumb question... Say I have a ton of SSRS reports (you know a good 300+)... Is there an easy...
Problem reading all Attributes into SQL table - Hello everyone. I'm writing a proc that imports several XML files and stores them in a SQL table. Here's a sample...
XML Data Loading - Issue - Hi, SQL Server: Microsoft SQL Server 2014 (SP2-GDR) (KB4019093) - 12.0.5207.0 (X64) Jul 3 2017 02:25:44 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...
Using Hash values as Dimension Keys in Datawarehouse - All We are exploring the idea of using a hash value as the surrogate key in Dimensions. Eg , Lets say we...
Convert .adp to .accdb - Hello; I am in the place of having to reengineer a solution that was built using a .adp in 2014 and... |
|
| This email has been sent to newsletter@newslettercollector.com. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the webmaster@sqlservercentral.com.
| 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.
| This transmission is ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
