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

Is This Data Science?

In looking at the preliminary results of his salary survey, Brent Ozar noticed that female salaries seemed to be lower than males. The post focused on a simple analysis of data, the kind that many of us have done in our organizations. We will look at some data, notice some anomalies, and produce some report that allows others to look deeper or make a decision.

The examination of the salary data was taken a bit further by Eugene Meidinger, who wrote a post that started the title with "Practicing Statistics". His analysis was interesting, not trying to determine the reasons or causes, but just decide if there were some significant patterns in the data. Whether you think there are or aren't issues with salary, I thought the statistical analysis was done well, and really a basis for what I would call data science.

Data Science is a hot topic right now in many organizations. In fact, for the last year, quite a few organizations are trying to incorporate more data science into their applications, and the hiring of "data scientists" is rising, with higher salaries being paid. There are various definitions of the practice, with none being standardized. There are many curriculums out there from colleges, and even one from Microsoft. In fact, quite a few SQL Server people have completed that coursework.

Data Science seems to mean many things, which is both good and bad. Like being a DBA, there is a lot of room for interpretation and quite a bit of variance in what we may do as a job. I've often made a good living as a DBA, being slightly out of the normal reporting structure, having autonomy at work, and usually able to make a difference to a variety of groups. However, I've also found that many places don't want to hire a DBA or don't think they need one, preferring to let some Windows admin or developer perform those duties. Microsoft doesn't have DBAs as a job title inside the company, usually using IT Ops staff for those duties. That means it can be hard to find a job at times if many companies don't think they need that position, which might be the case for data scientists as well.

I prefer to think positively, that data science and data scientist positions are going to grow and be profitable for some of us. We'll need to learn to have some statistical basis for our analysis, and certainly regularly improve our knowledge of the tools for things like machine learning, but we will find ways to perform data analysis that's beyond what most business people would complete in Excel. I think we'll find that those of us that work with data analysis will have lots of opportunities in the future, no matter what we're called. 

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.

ADVERTISEMENT
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

Database DevOps

Continuous Delivery for SQL Server Databases

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

Featured Contents

 

Azure DWH part 23: Data Mining

Daniel Calbimonte from SQLServerCentral.com

SQL Server on-premises includes a module to create Data Mining models. We will show how to create them using ASDW. More »


 

Free eBook: SQL Server Internals: In-Memory OLTP

Additional Articles from SimpleTalk

In this free ebook Kalen Delaney introduces and explains how the 2016 In-Memory OLTP engine works. The Hekaton internals knowledge offered in this book will help you migrate existing tables or databases to Hekaton, and get faster performance from your SQL Server applications than you ever thought possible. More »


 

GDPR: Why We Stopped Selling Stuff to Europe

The EU’s new General Data Protection Regulation (GDPR) is a set of rules that give consumers rights about how their data is stored, used, and deleted. In this post Brent Ozar provides some handy resources, and sparks some interesting debate. More »


 

From the SQLServerCentral Blogs - A Better Way To Script Database Objects

Bert Wagner from SQLServerCentral Blogs

Photo by Andy Beales on Unsplash Happy New Year! My New Year’s resolution for 2018 is to help you become a... More »


 

From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 84 – ChartAccent – BarChart)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the ChartAccent BarChart Custom Visual. This visual is a custom bar... More »

Question of the Day

Today's Question (by Steve Jones):

I have a PowerShell script where I've gathered results of Get-SqlDatabase for a database in the $db variable. I want to check if the Recovery Model is set to Full with a simple script. I have this:

 if () { # Run a log backup } 

What code should I insert in between the parenthesis for the IF statement?

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

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

Securing SQL Server: DBAs Defending the Database

Protect your data from attack by using SQL Server technologies to implement a defense-in-depth strategy, performing threat analysis, and encrypting sensitive data as a last line of defense against compromise. The multi-layered approach in this book helps ensure that a single breach doesn't lead to loss or compromise of your data that is confidential and important to the business. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Evgeny Garaev):

Imagine you have a table like this:

 create table dbo.sortme ( col1 int NOT NULL, col2 int NOT NULL, col3 int NOT NULL);

You have inserted several records in this table like this:

 insert into dbo.sortme(col1, col2, col3) values (1, 2, 3), (2, 3, 1), (3, 1, 2);

Then you have executed a select statement:

In which sorting order the result set will be returned?

Answer: col2 which has name 3

Explanation:

From click here:

A sort column can be specified as a name or column alias, or a nonnegative integer representing the position of the column in the select list.


» Discuss this question and answer on the forums

Featured Script

Find Most Expensive View (By Execution Count)

Yusuf Kahveci from SQLServerCentral.com

An important step in optimizing a system is to take a holistic approach and look at View that are called very often. These procedures can often be the backbone of a system. Sometimes optimizing these procedures can have a dramatic effect on relieving the physical bottlenecks of the system and improving end-user experience.
The following DMV query shows the execution count of each View, sorted by the most executed View first.

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

Migration of SQL Server - Hi all,  We have a 20 TB of databases, which is the best method of migration. Kindly suggest on this.

Metldown and Spectre - Has anyone deployed any of the patches released for SQL 2016 and SQL 2017 to any of their environments.  Is anyone...

Temporary tables in TEMPDB - Hi all,  As i noticed in tempdb temporary tables that many tables are starting with #A..#B as shown below, for what...


SQL Server 2016 : SQL Server 2016 - Administration

IN-Memory tables - Hello All! I would like to know what is the the pros & cons of In-Memory tables in SQL Server 2016 In addition...

Splitting TempDB across multiple files - I have a question regarding the splitting of TempDB in SQL Server, I know its a must in production environments...


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

Adding indexed computed column to vendor system-any negative impacts? - I have this vendor system I have to work with...it is perhaps the most horrible system ever made ;) Anyway, it...


SQL Server 2014 : Administration - SQL Server 2014

Can not kill this session - Hi all I am trying to restore a database ,but can not kill one  connection.This is the query that is running...

Data transfer - I got 100 million rows to export data from one table to another table. Do you think import/export wizard is...

extended events captures duplicated records - 1. here is the extended events: dropeventsession onserver declare @ServerName asnvarchar(max)=replace(@@SERVERNAME


SQL Server 2014 : Development - SQL Server 2014

Convert from datetime to varchar to int - Hi All, So I've been working on an SSIS package and part of it involves pulling data from a table's datetime...


SQL Server 2012 : SQL 2012 - General

STORED PROCEDURE - Hi following is my stored procedure, its will help me calculate went a particular staff is due for promotion and...

Transactional replication keeps applying snapshot - Hi, I created a new snapshot and applied it.  It ran the scripts to truncate all the tables and drop the...

AlwaysOn Database Not Synchronizing / Suspect - We have a database in an AlwaysOn Availability Group that has gone into a state of Not Synchronizing / Suspect on...


SQL Server 2012 : SQL Server 2012 - T-SQL

Searching strings - Hi all We've got a 3rd-party application and an associated database. We need to join two tables together but, unfortunately, there's no...


SQL Server 2008 : SQL Server 2008 - General

Composite Key Assistance - Hello, While I've searched this topic with some hits, I've never been able to fully digest this to my satisfaction.  My...


SQL Server 2008 : T-SQL (SS2K8)

I have to get a count of orders placed between 1 pm yesterday and 1 pm today by day - The table looks like this OrderNo, OrderDate 908, 1/3/2018 13:20:34 909, 1/3/2018 15:18:41 910, 1/4/2018 09:15:21 911, 1/4/2018 17:09:44 912, 1/4/2018 18:20:35 913, 1/5/2018 22:20:35 Expected Result Date, Count 1/4/2018,...


Data Warehousing : Integration Services

OLE DB provider Microsoft.ace.oledb.16.0 is not registered. - We have a SSIS package that is going to run on a SQl Server 2014 instance. I use Visual studio 2017 to...


Data Warehousing : Analysis Services

I've a question on career direction and what to concentrate on, and would like you opinions please. - Hi, My question is more at career guidance in the data world than anything specific, but as it focuses more on...


Database Design : Relational Theory

Is My Foreign Key Table Unnecessary? - I'm sure this has been addressed many times here but none of the search terms I've tried have surfaced anything...


SQL Server 2005 : Administering

Drop failed for jobs - I have a problem with some jobs, disabled since not useful, which I cannot drop. The message returned is TITLE:...

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