SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

Featured Script

The Voice of the DBA

So, you didn’t get the job; maybe it is YOUR fault.

A friend once shared with me his personal motto about job security, “I don’t need job security, I have career security.” For 20 years, I adopted that same motto. The confidence this simple sentence instilled was quite powerful. Over those years, the arrogance of “career security” soiled my personal appreciation for enthusiasm, work ethic, and logic. Fortunately, these last four weeks have caused a fundamental shift in my perspective. Finalizing to a phone interview one recent Tuesday afternoon for a senior DBA position, I am now the newest advocate for “Change or Die.”

For the most part, I believed that my experience in enterprise application development, systems management, and database management was enough to leverage, beating out most candidates for a technical position. <sarcasm><rhetorical question> When they advertise for a senior DBA, how am I not the right fit? </rhetorical question></sarcasm> Cue the arrogance, machismo, and stupidity.

Thirty-four minutes later, the call was over and I knew that I didn’t get the senior DBA job. I spent the next 20 minutes recalling the questions, looking up answers, and banging my head on the table. Compared to the answers I gave, I wouldn’t hire me for a junior DBA. It was time to pick apart my “I have career security” mindset.

Participating in a few interviews a year is always good practice. Practice is necessary to understand what is required to be a valid candidate. A benefit of the technology field is a mixed bag of having options, skills, and being able to grade and compare yourself to the rest of the world. Of the many things I didn’t do before my interview, first and foremost obviously, was to prepare. <arrogance> I have done this work for so long, why prepare? </arrogance> DBA positions revolve around how to resolve issues about customer’s data, such as security, recovery, availability, and performance. Being a manager once, I was more impressed by interviewees who had thorough, concise answers (Einstein had it right) and enthusiasm.

When I did my research into who interviewed me, a known author on this site, I both struggled with his past tenure versus mine, and how he became the person interviewing me. A weekend of introspective thought was in my near future. Some simple and powerful answers bubbled to the top of my list:

  1. Be enthusiastic about your career.
  2. Always be prepared.
  3. You do NOT know everything.

Being enthusiastic can actually be hard, especially without constant practice. I gave up playing with new technology for several reasons. Every seven to nine years, I experience burnout. I start hating technology. Wishing for the return of stone tablets and no electricity. Like being stuck in the middle of a lake without a paddle, it takes a while to dig out of the funk. I know, as I am at the end of my second burnout. Enthusiasm for technology continues by always trying new things. Start by going to users’ groups, or create a blog. Maybe tweet something that interests you in your field. Pick a new topic, for example, how much time have you dedicated to NoSQL? It is shocking to see the enthusiastic replies.  Whatever it is, you just have to start.

Be prepared is more than a Boy Scout motto because, in technology, it is synonymous with being educated. Udemy.com, A Cloud Guru – acloud.guru, edx.org, YouTube.combitfountain.io, Ppluralsight.com, and SqlServerCentral.com are but a tip of the education iceberg. There are thousands of websites dedicated to new technology, education, and social groups wanting to help bring people forward in this space. Education is our number one offensive and defensive maneuver.

The first step in any self-improvement plan is admitting one’s faults, so not knowing everything is my admission. In order to be prepared, one must identify their weaknesses. Challenging oneself to speak at a user’s group, write an article, get a certificate, or publish cool and awesome solutions on Github is a great opportunity to get feedback.

I never liked the idea of having to build a brand. My “brand” was being able to do a lot of things well, but having lost that enthusiasm and believing I knew everything, I was a loss leader. Besides technology, my interviewer’s articles refer to these exact points, you need to practice and work at creating, building, and playing. Through his examples of code, he shows how to make work more efficient, challenging, and fun. In the end, I do believe I gained more from the interview than he.

Change or die.

Rodney Hess from SQLServerCentral.com

Join the debate, and respond to today's editorial on the forums

ADVERTISEMENT
SQL Clone

NEW SQL Clone - version 1 available now!

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free.

Database DevOps

Library of articles for DevOps, DLM, & Continuous Delivery

Discover best practices and processes for more agile methods of database delivery. Find out how automating the build, test and deployment of database changes reduces risk and speeds up the delivery cycle. Read more on Simple Talk.

Featured Contents

 

Free eBook: SQL Server Internals: In-Memory OLTP

Press Release from Redgate

In this free eBook, Kalen Delaney explains how Microsoft's new In-memory OLTP engine works. In her book, learn how to use lock- and latch-free data structures to allow non-blocking data processing, and find out how to migrate existing tables to Hekaton. More »


 

AlwaysON Availability Group and Jobs Part 1

Leo Peysakhovich from SQLServerCentral.com

In this article (consist from 2 parts) , I will be focusing on one of the practical solutions for management of internal SQL Server jobs in AlwaysOn Availability Groups scenarios. More »


 

Using an R Package within SQL Server with Real time analysis in Power BI

We all know how easy it is to run R, together with dependent packages, from SQL Server on order to do statistical analysis, and then turn the result into a real-time graph using Power BI; but can you actually do it? Saurabh Desai gives a step-by-step hand-holding guide to turn even the most timid into a BI guru. There is nothing difficult in using R in SQL Server 2016 once you know the steps. More »


 

SQL Data Mask: now featuring configurable masks

Additional Articles from Redgate

SQL Data Mask is the latest prototype to come out of Redgate Foundry. It copies your database while anonymizing personal data, and you can use it to mask your databases right now, free of charge. Here are the details. More »


 

From the SQLServerCentral Blogs - Multiple usage of functions to ensure “value” is not null?!

Igor Micev from SQLServerCentral Blogs

In this post I’m describing a piece of code that is not well written. The author (unknown) had applied three... More »


 

From the SQLServerCentral Blogs - DAX calculations with hierarchies: Set the order straight.

Rayis Imayev from SQLServerCentral Blogs

[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of... More »

Question of the Day

Today's Question (by Steve Jones):

If I type this in R, what does the REP() function do?

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: R Language.

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

Exam Ref 70-762 Developing SQL Databases

Prepare for Microsoft Exam 70-762, Developing SQL Databases –and help demonstrate your real-world mastery of skills for building and implementing databases across organizations. Designed for database professionals who build and implement databases across organizations and who ensure high levels of data availability, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

When do checkpoints in SQL Server not run on instance startup?

Answer: They do not run when the server starts with -f or -m

Explanation:

The -m (single user mode) and -f (minimal configuration) parameters prevent a checkpoint from executing on server startup.

Ref: Start SQL Server with Minimal Configuration - click here

Start SQL Server in Single User Mode - click here


» Discuss this question and answer on the forums

Featured Script

Faster Backuphistory delete

Doran Mackay from SQLServerCentral.com

Should be orders of magnitude faster than the default cleanup proc.

Mine was running for 25 minutes when I decided to kill it and add a small change.

The solution to the slowness was to replace all the table variables in the MS proc with temp tables.

Additionally, added clustered primary keys to the temp tables.

Choose how much history you want to keep and assign it as per below.

declare @olddate datetime
declare @var int = -120
set @olddate = DATEADD(day,@var,GETDATE())
exec [dbo].[faster_delete_backuphistory] @oldest_date = @olddate

Be careful as it may complete the task before you have a chance to stop it in SSMS, so test it first to see if it meets your needs.

More »

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 Server 2016 : SQL Server 2016 - Administration

Identity in a table used previous number - Hi all, I have something that does not make sense to me. If anyone can give me clues that will be...


SQL Server 2016 : SQL Server 2016 - Development and T-SQL

How to use 'between' in CASE statement? - Hi Friends, I am trying to wirte a filter condition in WHERE clause like  CASE WHEN GETDATE() = 'first of this month' THEN 'DATE...

How to convert string to "data type" ? - Hello everybody, First of all sorry for my English ;-) Here is my problem. In a table I've :  - MyValue : column (varchar) wich store...

Choose the result NOT in a JOIN-query - I have this question selecting all students that are registered to a course. Select distinct Registrations.CourseId AS 'KursID', Course.CourseName AS...

Summarize field by week of the month - Hi Guys! Hope you can help me with this. I have 3 tables as: table 1 A        B             C1 1        1/1/17        10 2        1/7/17        20 3...


SQL Server 2014 : Administration - SQL Server 2014

SignalR Deadlock - The below select is causing deadlock on our production box. How can i avoid this? The same query is running from...


SQL Server 2014 : Development - SQL Server 2014

Drop/Create objects versus Alter - I am trying to put together some standards documents for development on a new team, and I received some sage...


SQL Server 2012 : SQL 2012 - General

Why would SQL throw a Severity 016 alert?? following a successful db restore? - Hi all, Does anyone know why would SQL throwing a Severity 016 alert following a successful db restore, and what I...

Single Node MSSQL 2012 cluster to Always on - We need to migrate one of our MSSQL instances in Production . The outgoing replication is to Informatica and is very...

COMPUTED COLUMN needing to retain value - I need to restore a value in my travellog table by adding a computed column called confirmDate: TABLE dbo.travellog ( travelID (pk,varchar(5), NOT...


SQL Server 2008 : SQL Server 2008 - General

translation to hours - Hi, I'm trying to normalize my data to hours and I'm a bit confused. For example,  for 12 hours to 1 billed...


SQL Server 2008 : SQL Server Newbies

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...


SQL Server 2008 : SQL Server 2008 Administration

SQL code works from SSMS but fails from the SQL Job. - Hello, The following part of the SQL code works perfectly well from SSMS, but fails when scheduled (SQL Job). SET QUOTED_IDENTIFIER is...


Cloud Computing : Amazon AWS and other cloud vendors

SQL Backups in AWS not on RDS - I am doing native SQL backups on a windows 2012 server to an S3 bucket. The full's (40gb) never make...


Data Warehousing : Integration Services

ETL Processes and SOX - I've managed to largely avoid SOX ... up until now. I'd like to solicit opinions from those who know about this stuff. Consider...

Copy data from flat file with multiple headers - Hi, I am trying to copy data from a flat file (CSV) which has multiple headers between the row values to...


Data Warehousing : Strategies and Ideas

No PKs on fact tables - I just inherited a data warehouse where none of the fact tables have a primary key (all fact tables are...


Data Warehousing : Analysis Services

Tuning slow running SSRS generated MDX script with union function - I have a simple cube with two calculation to calculate average and standard deviation. I have to create a simple...


SQL Server 2005 : Backups

backup all databases in SQL 2008 - Hi, Need a script to compress and backup all the databases in sql 2008, except system databases. Please let me...


Career : Certification

70-461 - Hi, Id like to take this exam and looking for some good prep.. My T-SQL skills are basic at present...

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 ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com