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

The Voice of the DBA

Closer to the Heart

This editorial was originally published on Feb 13, 2015. It is being republished as Steve is on vacation.

Most of us take whatever jobs we're offered. We send out resumes, go through interviews, and often accept the first offer for employment. In fact, I bet most of us rarely have more than one employer to choose from at a time. Perhaps two if we're looking for a job while still working, but I bet in many situations the current employer isn't one we're considering working for in the future.

What's more, it seems that many people working in technology can work in a variety of industries. A database that stores sales information for a retail company isn't managed a lot differently from one that captures inventory information for a manufacturer. I know I've worked in the power generation, education, finance, software, and other fields. I've found that my job as a DBA or developer hasn't really changed much. I could work in any of these industries.

However, I'm sure that most of you have interests and attractions in areas. Perhaps some of you have really enjoyed working with certain data, or there are applications you think you'd enjoy. This week I wanted to ask what might be your ideal field.

In what industry, or with what data, would you like to work if you had the choice?

Or perhaps, where do you think you'd have a connection with the technology as well as the business. Imagine that you could choose what data you'd work with, and some employer in that field would offer you a job.

For me, I think if I had the chance I'd like to work with a professional sports team in the US. In Denver, I'd really be interested if the Broncos, Rockies, or Nuggets needed some technical help. These organizations are starting to use more and more data to analyze their players in order to gain some competitive advantage. I find all the numbers published to be interesting and think it would be a fun job helping to find patterns and meaning in the data.

Let us know this week where you might want to work.

Steve Jones from SQLServerCentral.com

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

Continuous Delivery for SQL Server Databases

Spend less time managing deployment pain and more time adding value. Find out how with database DevOps

What’s the top challenge faced by SQL Server professionals in 2018?

Learn how 626 SQL Server professionals monitor their estates in our new report on the State of SQL Server Monitoring. Discover the challenges currently facing the industry, and what is coming next. Download your free copy of the report

Featured Contents

Enable FIPS 140-2 Compliance in SQL Server

Jason Ash from SQLServerCentral.com

What is FIPS? How do I use it? What is going to break if I do use it? More »

Power BI Introduction: Working with Power BI Desktop — Part 2

Additional Articles from SimpleTalk

Power BI Desktop is the free tool from Microsoft for developing in Power BI. In this article, Robert Sheldon walks you through importing and manipulating data with the Query Editor in Power BI Desktop. More »

Receive SQL Server Alerts through Slack

Additional Articles from MSSQLTips.com

In this tip we look at how we can use Python and SQL Server 2017 to send alerts from SQL Server to Slack messaging service. More »

From the SQLServerCentral Blogs - How to get started with Always Encrypted for Beginners Part 4: Change is Coming

SQLEspresso from SQLServerCentral Blogs

A few weeks ago, I wrote Part 1, 2 and 3 of this series, which was a beginner’s guide to Always Encrypted. In part... More »

From the SQLServerCentral Blogs - Information Measurement with SQL Server, Part 4.1: The Kullback-Leibler Divergence

SQLServerSteve from SQLServerCentral Blogs

By Steve Bolton …………This informal series of tutorials on how to implement a hodgepodge of information metrics in SQL Server is... More »

Question of the Day

Today's Question (by Steve Jones):

I have a job set that makes a backup of my SalesStatistics database every day. The filenames look like SalesStatistics_201806010100.bak and the backup job for this file would have looked like this:

 BACKUP DATABASE SalesStatistics TO DISK = 'SalesStatistics_201806010100.bak' WITH COMPRESSION, INIT,

I find that I need to restore this backup to a new instance to run CHECKDB and have it available for any problems that occur. I run this restore command:

 RESTORE DATABASE SalesStatistics FROM DISK = SalesStatistics_201806010100.bak' WITH CHECKSUM, REPLACE

What happens, assuming there is a SalesStatistics database on this new instance? Assume there are valid file paths in the backup file and on this instance.

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: Backup and Recovery.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.

SQL Server Query Store In Action

The Query Store changes the way you monitor performance on your databases and the way you tune the performance of those same databases. This book represents a deep dive into a large number of topics in and around the Query Store. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Junior Galvão - MVP):

After executing the Transact-SQL code block declared below in Microsoft Managenent Studio 17.7, what happens?

 Use TempDB Go Declare @MyVariableNumeric1 Numeric(6,2), @MyVariableNumeric2 Numeric(2,2) Set @MyVariableNumeric1 = 100.2 Set @MyVariableNumeric2 = 2 Select @MyVariableNumeric1 As 'Value 1', @MyVariableNumeric2 As 'Value 2' Go

Answer: An error is returned: Msg 8115, Level 16, State 8 Arithmetic overflow error converting int to data type numeric.

Explanation:

The answer is an error is returned. Msg 8115, Level 16, State 8.

Explanation: Note that we are declaring two numeric variables @MyVariableValue1 and @MyVariableValue2. The @MyVariableValue1 is receiving as maximum value for digit storage number 6, that is, we can store up to six values including the two decimal places.

The @MyVariableValu2 is receiving as maximum value for digit storage number 2. In this case the size set for storing values including decimal places is less than the amount assigned in the declaration line of this variable.

Reference: 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 - Development

Lock on SQL data rows - Hi, Can some one please help how can I acquire lock on rows while it is being worked by some one. My...

SQL Server 2014 : Administration - SQL Server 2014

Unable to start SQL Server service-error 3414 - After the emergency shutdown of the computer the SQL Server (SQLEXPRESS) service does not start and gives an error message: Failed...

shrinking data file on primary server does not shrink data file on logshipping server - Recently I developed a script to move user objects to newly created data file, then shrink the original file (command:...

SQL Server 2014 : Development - SQL Server 2014

Insert a duplicate copy of any record that meets certain criteria - Sorry for this dumb question but I am very new to SQL. Could someone help me write a SQL code?

SQL Server 2012 : SQL 2012 - General

?????????????Q?1010636782(Sussex)???????????“?????,????”??????University of Sussex - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

??????????????Q?1010636782(UEA)????????????“?????,????”??????University of East Anglia - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

???????????Q?1010636782(York)?????????“?????,????”??????University of York - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

???????????Q?1010636782(Leeds)?????????“?????,????”??????University Of Leeds - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

?????????????Q?1010636782(Lancaster)???????????“?????,????”??????Lancaster University - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

???????????Q?1010636782(Surrey)?????????“?????,????”??????University of Surrey - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

????????????Q?1010636782(LBS)??????????“?????,????”??????London Business School - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

?????????????Q?1010636782(RUL)???????????“?????,????”??????Regent's University London - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

???????????????Q?1010636782(RNCM)?????????????“?????,????”??????Royal Northern College of Music - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

?????????????Q?1010636782(RCA)???????????“?????,????”??????Royal College of Art - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

?????????????Q?1010636782(UAL)???????????“?????,????”??????University of the Arts, London - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

???????????Q?1010636782(Cantab)?????????“?????,????”??????University of Cambridge - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

??”UB????????Q?1010636782{}Buckingham?????????????/??????????/????/????????????University of Buckingham - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

??”UD???????Q?1010636782{}UD?????????????/??????????/????/???????????University of Dundee - ??????Q/?1010636782???????:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ?????????Q Q\??1010636782???:???,??????(????)??????+«?????&????»,???????,??????,?????,Offer,????,???? ,?????? ????????????????????????????????????????????,??,DHL?? F????:???.??.??.???.??.??.??. F???????????????????????,????,????,??????????????,????????????!??? #??

SQL Server 2012 : SQL Server 2012 - T-SQL

Find the difference between 2 values - Experts, I am wondering if I can get some help with what I am trying to accomplish here. I have 2...

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.