SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Learn More than Technology

I've been lucky and successful in life in many ways. Certainly I've worked hard, may long days and nights, but plenty of others have as well. In fact, there are plenty of people I know that have worked more hours, but been less successful. Conversely, I know some that have worked much less and been more successful. It's hard to know what the best way is for each of us to examine how to move forward in life, but it's also not really helpful to compare yourself with others as a measurement. What I'd note you should do is decide if you think you're becoming more or less successful and find your own path.

This could mean very different things to different people, and that's fine. I don't want to live other people's lives. I want to live my own, learning from positive and negative things that happen to others, but following the path that best suits my wife and me. I include my wife because we're a partnership. We decided to spend our lives together, and that means we work with each other, sharing success and sacrifice, making joint decisions. It's worked out well for us, and I am looking forward to the next few decades of continuing on that path.

I got inspired to write this by Troy Hunt's 10 Personal Finance Lessons for Technology Professionals, which is better written than what I'd do if i wrote it. My wife and I haven't been as focused as Troy has, but we've gone through a similar set of thoughts and execution in our careers. We were less money focused, and we don't live on the Gold Coast, but we're pretty happy with where we are. We've made a few real estate investments, along with some traditional ones, and I think we've been fairly successful.

What inspired me, however, isn't the advice about how to make money as much as the need to understand what money means to you and the implications of your choices. I do think money is necessary, at least some to live in the US. I also think money can make life better, but you have to learn to enjoy life first. Money should help you with things you enjoy, not make you buy things you think you (or others) will enjoy. However, to ensure you can make the choices you want to, learning a bit about money is useful. 

Most of us don't get good financial literacy, and more importantly, we don't think about what money really means. It's a representation of time, and your time is the most valuable asset you have. I don't advocate that everyone try to be rich, or retire at 40, or save every penny/pence/shilling/lira/yen and live like a pauper.

Enjoy your life as you live it and learn to appreciate the small things that touch your days. Along the way, learn a bit about money so you can make choices. Develop a hobby outside of work, and enjoy the moments with friends and family. Life is short. Try to actively live to enjoy it.

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.5MB) 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.

Database DevOps

Benchmark your Database DevOps maturity level

Get a better understanding of how advanced your current processes are, receive recommendations for improvements, and see how your maturity level compares with that of your peers. Complete the Database DevOps Maturity Assessment

SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Featured Contents


Using SQL Server and R Services for analyzing Sales data (Part 3)

Tomaž Kaštrun from SQLServerCentral.com

Using R integration for analyzing sales data in WideWorldImporters database More »


Which Version of SQL Server Should You Use?

Additional Articles from Brent Ozar Unlimited Blog

Wait! Before you install that next SQL Server, hold up. Are you sure you’re using the right version? More »


Automatic Provisioning of Developer Databases with SQL Provision

Microsoft MVP Steve Jones provides a simple proof-of-concept workflow that allows organizations to provision full sized databases for developers, using production like data that has been masked automatically as a part of the provisioning process. More »


From the SQLServerCentral Blogs - Scheduling things to Run in SQL Server

SQLEspresso from SQLServerCentral Blogs

A key part of the SQL Server Agent is the ability to schedule jobs. While you can create one schedule... More »


From the SQLServerCentral Blogs - Rotating Expired SQL Server TDE Certificates

WaterOx from SQLServerCentral Blogs

In general, SQL Server TDE certificates will expire at some point. In SQL Server, if we have setup TDE using... More »

Question of the Day

Today's Question (by Steve Jones):

On SQL Server 2017, I have a brand new database with no objects. I run this code:


I now decide to query sys.objects with this code. How many rows are returned?

 FROM sys.objects AS o
 WHERE o.type = 'P'

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: Stored Procedures.

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


Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server

Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization’s increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I run this code on SQL Server 2017:

CREATE TABLE dbo.SalesOrderHeader
( OrderKey TINYINT IDENTITY(1, 1) 
, CustomerName VARCHAR(30)
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy')
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian')
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve')

This adds three rows. Now I run this:

SELECT IDENT_INCR('dbo.SalesOrderHeader') 

What is returned?

Answer: 1


The IDENT_INCR() function returns the identity increment for a table with an identity property. This is set in the table definition as 1. The identity value isn't returned here.

Ref: IDENT_INCR() - 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

Best way to track "errors" in Stored Procedure - Hi Guys, I need advice. I have almost 30 Update statements with different logic in one stored procedure. If I...

What it means to atomize values in 1st normal form - Suppose we have the following table.  We have everything for the address packed into one cell.  Also, we have two...

Any video courses that teach Execution Plans? - Hi, I am  aware that  Redgate  has a free  ebook  that  explains  execution  plans.  I was wondering  if there were  video ...

When does SQL decide to load all of an index in to memory? - We're having a bit of a performance issue with one of our tables, which seems to be behaving in a...

SQL Server 2016 : SQL Server 2016 - Administration

Reporting Services Migration Problems - I am trying to get SSRS running on Server #2, copied from Server #1 What I've done so far. - Backup Reports...

HA VS DR - What is the difference between high availability  and disaster recovery ? Also  proxy and credentials

upgrade to 2016 causing performance problems - Hi all Experts, We have strange problem (at least for our case), we have database in 2012 which was restored...

Backup and log - Hello, since 2 years, I manage a database with a lot of transactions Recovery mode is Full Full backup once a week ...

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

Sort already comma separated list - Hi I have values like this in a column which basically is the exact same thing if sorted . ORM;

SQL Server 2014 : Administration - SQL Server 2014

Easy (I think) mdf file size question - So is there any advantage to splitting up a data file that is getting close to 2TB if all the...

SQL Server 2014 : Development - SQL Server 2014

Tuning Query In Stored Procedure - Below table contains five millions of records. My Table Structure CREATE TABLE .(   (50) NOT NULL,   (2) NOT NULL,  ...

Remove duplicate substrings from string - Hello experts, I have a problem I'd appreciate advice on please. I'm asked to determine distinct combinations of sequences of values...

SQL Server 2012 : SQL 2012 - General

msdb.dbo.backupset table on standby server - I am new to SQL server.. we are generating backup report on primary server using msdb.dbo.backupset table. But in backupset table,...

SQL Server 2012 : SQL Server 2012 - T-SQL

Convert string MMDDYYYY to a date - First I will say I've found a couple different SQL solutions for this, I'm asking if there is a better...

Convert string nvarchar(6) with format MMM-YY to date - Hello, I have a column that is an nvarchar(6) and the data in the column is formatted like this: Dec-15 Jan-16 Feb-16 I'd like to...

SQL Server 2008 : T-SQL (SS2K8)

How to insert multiple records from fields in select record - I am trying to take results from multiple fields from single rows that are not null and put them in...

Programming : General

Output of stored procedure to a txt file?? - Hello, I am trying to write the output of a stored procedure to a txt file. I am unable to...

Data Warehousing : Integration Services

Automaticaly Build and Deploy SSIS packages. - Hi we're trying to automatically build and deploy an SSIS package up to the Integration Services Catalogue when we check changes...

SQL Server 2005 : Administering

sql express 2005 database has dissapeared after restore. - This is live, old I know, but I really need advice. So I had a corrupt db.  Backups all screwed.  So...

How can I export all table names plus column names from sql? - Hi, I have to list all the tables in my database, plus the column names in each, and how they...

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