SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Build a Career Radar

I got started in database work during an internship. I was asked to program some Lotus 1-2-3 spreadsheets to help a department. I was pretty proud of the mess I made, since it helped someone with scheduling. Another person noticed and dragged me over to work on some dBase stuff, eventually moving into Clipper and compiled code, even some basic event driven Windows work. This led to some Visual FoxPro and eventually a real database backing the application. The choices I made in moving from Lotus to Clipper to FoxPro to SQL Server (eventually) defined my career.

I was reminded of those times in reading about technology radars. I've seen a few of these from companies like ThoughtWorks, and we've even experimented with them at Redgate. The idea of a radar is it's a living document that assesses risks and rewards of technology. I didn't create one explicitly early in my career, but I've always been interested in reading and learning about lots of technology, with an eye on trying to decide how useful, popular, and valuable different things would be for my career.

There's a nice piece from Neal Ford at Thoughtworks that says you should consider building a technology radar. Certainly if you're in the business of creating technology you might want an organizational radar, but for your career, you might think about the technologies that are around you.

I didn't explicitly build my own radar, but I did evaluate Windows v. Linux, betting on the former since I considered the overwhelming inertia from Windows 3.1 and Windows 95. I evaluated Oracle v. SQL Server, and at times I almost wish I'd have chosen Oracle (for the pay drawn working with a cumbersome set of tools), I'm glad that I went with SQL Server. I've enjoyed the product most days. There are other choices along the way, including my decision to sit too long on VB v C#, but I can't guess 100% right. Even now, as I look at R v Python, both choices that are tangential to my work, I've thought for a few years that Python was a better choice. I'm glad it was added to SQL Server and I expect its use to eclipse R in a year or two (or three).

It's hard to keep up. It can be overwhelming. Eugene Meidinger compares keeping up with learning to the stages of grief. It's not a bad analogy, and I find many people someone on that spectrum, trying hard to figure out what and how to learn, not to mention finding the time and money to invest.

I do think that it is important that most of us keep up with changing technology, at least a little. The world is changing and while some, or even many, of us stick with the same job for a long time, I don't know anyone these days that expects to never change employers. Having a variety of skills, being able to learn quickly, and most importantly, muddle through projects that you know little about are skills that will help you find your way in an uncertain employment situation.

Steve Jones from SQLServerCentral.com

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

The Voice of the DBA Podcast

Listen to the MP3 Audio ( 4.2MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

SQL in the City

Sign up for more free training from Redgate

Redgate has committed to hosting a free virtual event in every quarter of 2018, and will be kicking this off on February 28 with a livestream themed around data privacy and protection. The agenda has now been released, so you can see who will be presenting, what they will be presenting, and how you can tune in to watch. Find out more about the sessions and register your place

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

Create and manage database copies effortless and keeps compliance central to the process. With SQL Provisions virtual cloning technology, databases can be created in seconds using just MB of storage, enabling business to move faster. Sensitive data can be anonymized or replaced with realistic data to ensure data is protected as it moves between environments. Download your free trial

Featured Contents


Get Set For Speed

Tom Staab from SQLServerCentral.com

Loops are common in application code, but set-based solutions are the way to go with SQL. More »


"But It Worked in Development!" - 3 Hard SQL Server Performance Problems

Additional Articles from Brent Ozar Unlimited Blog

You’ve been performance tuning queries and indexes for a few years, but lately, you’ve been running into problems you can’t explain. Could it be RESOURCE_SEMAPHORE, THREADPOOL, or lock escalation? These problems only pop up under heavy load or concurrency, so they’re very hard to detect in a development environment. More »


Avoid T-SQL Technical Debt using SQL Prompt Code Analysis

SQL Prompt’s new Code Analysis feature helps you discover code issues and hidden pitfalls during code development, as you type. In this article, Catherine shows how the Code Analysis feature works, and illustrates how to use the feature to improve the quality of your team’s SQL code. More »


From the SQLServerCentral Blogs - How I Used Pragmatic Works Training to Pass the Power BI 70-778 Certification

Devin Knight from SQLServerCentral Blogs

Recently I took and passed the Microsoft certification exam 70-778 for Power BI called Analyzing and Visualizing Data with Microsoft... More »


From the SQLServerCentral Blogs - Hobbies, stress relief, and meeting management: T-SQL Tuesday #99

Kenneth Fisher from SQLServerCentral Blogs

It’s T-SQL Tuesday again! And in fact it’s the 99th one! Given that T-SQL Tuesday runs once a month that... More »

Question of the Day

Today's Question (by Evgeny Garaev):

What would you get by executing this query:

with cnumbers as
select 1 as i
select i+1
from cnumbers
where i < 10
select i
from cnumbers;

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 2 points 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 Contribution Center.


The Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced.  Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have a database, called Finance, with Change Data Capture (CDC) enabled inside of it. During a DR event, we decide to restore the most recent backup of this database on another instance. How do I ensure that my CDC information is not lost?

Answer: Add the WITH KEEP_CDC option to the restore command and run it


To keep your CDC settings during a restore, the WITH  KEEP_CDC option is needed.

Ref: Restore Arguments - 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 Server 2017 : SQL Server 2017 - Administration

How would you lock down a SQL DBA to have local admin on the SQL box - I would like to know if we can create a separate group or what permissions on the server should be...

SQL Server 2017 : SQL Server 2017 - Development

USE IN AND LIKE TOGETHER?? - Guys, is there a way to use the following but where the statement shows     'And Servtext IN ('WAR' ,'WARTEC' ,'TRIAGE'...

SQL Server 2016 : SQL Server 2016 - Administration

Authenticate via gMSA Account through SSMS - Hello, Im trying to Authenticate via an gMSA account that is based on computer membership of an AccessGroup in AD that...

Can I Restore with Device to Database on another Server? - my client wants me to set up an incremental database backup, which entails restoring to a device, not a file I...

SQL Server 2016 cluster issue - Hi, We have installed SQL server 2016 Standard (SP1)  in two-node Windows 2016 Fail-over cluster successfully.. <by mistake> When we restart SQL...

Transaction Log Growth - Hi, I am currently using Ola Hallengren's backup solution for my backups on a SQL Server 2016 Standard instance. I have...

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

Selecting a row per group based on multiple conditions - I have a table with sample data as shown below. For each ProcessId, I need one row to be selected...

SQL Database Audit - Hi all, My question relates to SQL Server audits, in particular the database audit, what I'd like to do is to...

SQL Server 2014 : Administration - SQL Server 2014

SQL Server 2014 service account privileges - In production we are running SQL Server 2014 with the "SQL Server Agent" and "SQL Server Database Engine" service accounts...

SQL Server 2012 : SQL 2012 - General

Run an FTP package from stored Procedure - Hi,  I am trying to run a simple FTP package from stored Procedure. So if I run the package in SSIS it...

SQL Server 2012, update Stats and Index Organize taking 16 hours for execution?? - Hi, We have SQL Server 2012, On production database SQL job update Stats and Index Organize taking 16 hours for execution. Size...

SQL Server 2012 : SQL Server 2012 - T-SQL

Need to get consecutive duplicate rows - I need a query that can get me (the ID of) consecutive duplicate rows, where I am grouping on some...

SQL Server 2008 : SQL Server 2008 - General

Reporting Service don´t export to excel - Hi, Good Moring, Someone could help me about this? I have a report via Reporting Service, In the user`s pcs,...

SQLCMD: Getting Access Denied - Hi Im running the following in a SQL agent job but realised the script im trying to call and execute, didn't....

Remote install failing " There was an error generating the XML document." - Hi I'm trying to install SQL 2008 from a powershell build script. The PowerShell invokes a batch file on the remote PC...

Strip HTML Tags - Guys, Guys I have a table with a column that has html text. The column with html text is pretty big...

DateAdd - Working Days Only - I have a calendar table like this: SmallDate DayName DayDescription 04/11/2010 Thursday Working Day 05/11/2010 Friday Working Day 06/11/2010 Saturday Weekend 07/11/2010 Sunday Weekend 08/11/2010 Monday Working Day 09/11/2010 Tuesday Working Day I would like to use maybe the DateAdd function to...

Programming : SSDT

Importing Loads of Fixedwidth flatfiles - hi i've got a big bundle of fixedwidth flatfiles to import. i have the supplier documentation to show me where the columns...

SQL Server 2005 : Administering

Error: Could not apply log backup file - hi i have a sql 2005 db with log shipping enabled. the secondary server is suddenly giving me the below errors, anyone...

SQL Server 2005 : SQL Server 2005 Integration Services

Aggregation - I'm confused about how to aggregate a value in SSIS. Let's say I have a task that simply exports the...

This email has been sent to {user_email}. 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