SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Can Data Save the World?

Years ago I read one of the Freakonomics books. It was an interesting look at how we might examine our world in unexpected ways, using lots of data. While I didn't always agree with the conclusions of the authors in different areas, I did find the idea of using data to probe and examine for patterns in our world to be fascinating.

Recently I caught a podcast with the authors, and the opening question caught my eye. It was "can data save the world?", and I was hooked, needing to stop and listen to the episode. That's because I think data is the most important asset in the world today, and data is what really powers all the software we have. We need data, and we need to ensure our data has a high level of quality and integrity in order to glean information from all those bits and bytes to get value from software. Certainly software matters, but data, to me, is more important.

The authors' position is interesting in that they see data as an important part of analyzing data. The type of data, industry, organization, etc. doesn't matter, but the data also isn't necessarily enough to change someone's mind or convince them of an argument. There needs to be a story as well, which requires a different skill from that needed for analyzing data. I do think that often the way in which we present an analysis can be just as important as the data. Perhaps even more so.

What I do find interesting in the podcast is that younger companies (and people) are willing to embrace more data driven approaches. I see that often. There have been no shortage of clients in my career that were sure they knew the answer to some question about their business job without referring to any data analysis. They trusted their experience. Even if there was data that might show their conclusions were slightly erroneous, they often didn't want to change their decision or conclusion.

Humans are creatures of habit. Even those of us that embrace some change will find that we like change in some parts of our lives, but not others. If someone has had success in their career without using data to support or alter their opinions, it can be hard to get them to change. I wish I had a good method for convincing people to get started using more data, but really I think that the best idea is to find a different person to convince. If you can do so, and produce real results, then you may be able to go back to the first person and show them some evidence.

The one part of the podcast that I wish turned out different is at the end, where the authors note there isn't a good way to teach someone how to analyze data and tell a story. They thought about creating their own curriculum, but gave up. It's too much work, and apparently they weren't sure they could do a good job.

They imply this is harder than teaching someone to program, which is disappointing as we have lots of programmers that need help as well. If we can't teach programmers at any scale, what does that mean for data scientists? The one part I would agree with them on is that data science is a great area to move towards your career if you have the talent.

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.3MB) 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 Monitor

Don’t just fix SQL Server problems, prevent them from happening

SQL Monitor helps teams looking after SQL Server be more proactive. Not only does SQL Monitor alert you to current issues, it gives you the information you need to stop them happening in the future. Download SQL Monitor now and get a 14 day free trial

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


Keeping tables online during loading with schema swapping using SSIS

Shubhankar Thatte from SQLServerCentral.com

In this article, we discuss how schema swapping method can be used to keep tables online during the load process. More »


Book Review: Database Reliability Engineering by Campbell & Majors

Additional Articles from Brent Ozar Unlimited Blog

Brent Ozar explains why DBAs should read this book about the future of database administration at scale. More »


Introducing the updated HTML comparison report in SQL Compare 13.1

In SQL Compare 13.1, Redgate have updated the interactive HTML comparison report type, providing simpler cleaner reports that focus on the differences between the compared databases. This blog post looks at the details of what's new. More »


From the SQLServerCentral Blogs - Biml for a Task Factory Dynamics CRM Source Component

meaganl from SQLServerCentral Blogs

I recently worked on a project where a client wanted to use Biml to create SSIS packages to stage data... More »


From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 79 – Venn Diagram MAQ Software)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Venn Diagram Custom Visual by MAQ Software. The Venn Diagram... More »

Question of the Day

Today's Question (by Harsha Bhagat):

What will be the column  names of the result sets from this code in the SSMS grid?

declare @count int,
@scripts varchar(200),
@script2 varchar(20)

select @count = 10
select @script2 = '10000'+ convert(varchar(10),@count)
select scripts = @script2

select @scripts

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: Assigning Result Set Column Names.

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 Practice Problems: 57 beginning, intermediate, and advanced challenges

It's easy to find basic SQL syntax and keyword information online. What's hard to find is challenging, well-designed, real-world problems—the type of problems that come up all the time when you're dealing with data. Learning how to solve these problems will give you the skill and confidence to step up in your career. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

How can I disable soft-NUMA in SQL Server 2016?



The ALTER SERVER CONFIGURATION command is used. There is a soft_numa parameter that is set to OFF. This does require an instance restart.

Ref: Soft-NUMA - 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

SSMS 17.3 Start Powershell give s error - No SQL Server cmdlets found on this computer - This is a Win 10 desktop and I've installed the sqlserver module via install-module sqlserver -force. I can import it...

Import 2014 Registered Servers - My dev box was replaced on Friday, as SQL 2016/2017 would not install on Win7. I have just finished installing SQL 2017,...

How do I log into SSMS v17 on a home network? - I've got SSMS v17 installed on a new laptop. And I've got SQL Server 2016 Developer Edition on a desktop...

SQL 2017 Standard Core Licensing Limits - I'd like to know if there is a limit to how many SQL Standard Server licenses you can put on...

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

Sorting after records deleted - CREATE

Need vertical table as horizontal table in SQL - Hi Team, can you please help me to get create table company ( name varchar(100) ) insert into company select 'IBM' UNION ALL select 'Goolge' UNION ALL select 'Microsoft' UNION...

SSIS: Error converting to date - Hello: I have a variable that uses the following colamnd:   (DT_DBTIMESTAMP2, 0)   ((DT_STR, 10, 1252)    (SUBSTRING(LEFT(RIGHT(@, 12), 8), 1, 4)...

Using CSS to control formatting in dbmail - I have written a query and currently have a job that runs and sends an email using sp_send_dbmail in a...

SQL Server 2014 : Administration - SQL Server 2014

Bulk insert into table from csv - Hi, i have table in CSV: As you can see there are a lot of columns.  My source table data types fields are:

MSSQL Schema Export Only - Is there an easy way to do schema only exports in mssql

Read TXT File - problem with importing from flat file source ssis - hi Guys, I have txt file where i have 14 million rows from Qlikview and SAP exported. Now i want to...

SQL Server 2014 : Development - SQL Server 2014

Resolving many to many linkage - USE GO /****** Object: Table .  Script Date: 11/29/2017 9:52:07 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE .(  &nbs

SQL Server 2012 : SQL Server 2012 - T-SQL

sql injection help - Hello All,  I have an unusual request today. My company has a very old Access VBA application, this application uses inline sql...

How to resolve Multiple lookup operation in execution plan for same index - In a Query Block, We are using a table (CustomerOpenOrder) multiple time to join with other tables. In Execution plan,...

SQL Server 2008 : SQL Server 2008 - General

Bulk insert statement cannto open file on the share - I am trying to execute a bulk insert statement in SQL management studio. BULK INSERT PSStudentAccess FROM '\\servername\pj_sharepoint\external\autosend\myfile.txt" WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '' ) Cannot bulk load because...

Programming : General

Call sp from a Case statement - Hi, I am trying to execute a Stored Procedure after two other jobs in the schedule have completed successfully, so I am...

SQLServerCentral.com : Articles Requested

Mathematics/Algorithms in SQL - All, I am looking for some article which explain what are all the mathematics concepts and algorithms used in SQL.

Bad Scalar Functions (or other UDF) - If you can share a story of a real scalar or multi-statement table UDF and how you fixed it, I'd...

Bending strings - Based on this, which is an interesting problem: http://www.sqlservercentral.com/Forums/Topic1625170-2799-1.aspx Show how to move rows to a delimited string and then summarize.

Career : Certification

70-473 Anyone studying for this, or passed it? - Hello, I'm studying for this exam, just wondering if anyone else was? Regards, D

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