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

Becoming a Data Scientist

Data Science is hot. There are lots of companies excited by using machine learning and AI to enhance their applications. There are new jobs, some of them well paying, and certainly not enough people to fill them. In many ways this reminds me of previous "hot" areas, such as Novell Networking in the late 80s/early 90s. Companies wanted new CNEs and paid dearly for them. The same thing happened in the mid 90s with MCSE's for Microsoft networks. Many of the people hired weren't remotely qualified, having just completed some multi-week boot camp.

You could go to school. If you have completed college, there are a list of data science graduate programs that you could choose from and pursue a masters degree. There's even a blog where someone is documenting their masters degree path to becoming a data scientist. This isn't a quick or easy path, but it is one way to gain data science skills.

If you don't want to spend the time or expense of a formal college program, Microsoft has a data science curriculum on the EdX platform that you can complete. These are low cost programs that you can complete to get a certificate. The value of that certificate is debatable, but the same could be said for any program. A few people that are working through this program have found it to be a good set of resources that is teaching them valuable skills. Again, this isn't easy or necessarily quick, but it does put you on a path to understand more about the topic and decide if it is something you find enjoyable.

There are other options, no shortage of books, blogs, and other resources on data science and data analysis techniques. It's up to you, however, to learn what you need to know and become competent at a level that is useful for some organization to pay you. I dislike people choosing to study a topic for a job, so I would say that if you wish to go down this path, do so because you enjoy the work and find it interesting. Build some skills, build a portfolio of data science projects, and best of luck.

Our industry has thrived for a long time on simple analysis, and I think there will be jobs in this area for some time to come. I do expect that better looking reports and dashboards are going to be expected rather than simple tables, so I'd suggest everyone work on their visualization and report polishing skills. I also think that more complex data science techniques will be in demand, though I wouldn't expect job growth here that overwhelms current jobs. Tackle data science if you like, but be aware this isn't a simple or easy chore. There are lots of math and statistics involved and it looks like this is more science than just reporting on data.

Steve Jones from SQLServerCentral.com

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

ADVERTISEMENT
SQL Source Control

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more.

Database DevOps

Library of articles for DevOps, DLM, & Continuous Delivery

Discover best practices and processes for more agile methods of database delivery. Find out how automating the build, test and deployment of database changes reduces risk and speeds up the delivery cycle. Read more on Simple Talk.

Featured Contents

 

Obsoleting Unused SSRS Reports

Amarendra Reddy Thummeti from SQLServerCentral.com

Learn about programmatically obsoleting unused SSRS reports from your Report Server. More »


 

SQL Clone Trivia Quiz - win a $10 gift card every weekday in April

To celebrate the recent launch of their new database provision tool, Redgate are giving you the chance to win a $10 Amazon or Starbucks gift card every weekday this month. To enter the prize draw, just answer the daily SQL Clone trivia question on the right-hand side of the homepage. More »


 

Free eBook: Fundamentals of SQL Server 2012 Replication

Press Release from Redgate

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book introduces you to the technologies that make up replication, and then walks you through setting up different replication scenarios. When you've finished reading, you should be able to implement your own multi-server replication setup while following the principle of least privilege. More »


 

How to setup a tabular data model in SSAS Azure

Additional Articles from MSSQLTips.com

Microsoft announced the availability of SQL Server Analysis Services (SSAS) on Azure late last year. Siddharth Mehta walks through how to quickly set up a tabular data model in SSAS Azure. More »


 

From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 47 – Line Dot Chart)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Line Dot Chart Power BI Custom Visual.  The Line Dot... More »


 

From the SQLServerCentral Blogs - Query tuning 101: What’s a probe residual?

Daniel Janik from SQLServerCentral Blogs

Query tuning is an important process that will probably never go away and sharpening your tuning skills is always a... More »

Question of the Day

Today's Question (by Steve Jones):

I see this code in an R script:

24 -> x

What does this do?

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: R Language.

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

Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I am connected to a SQL Server instance in Azure and want to create an Azure SQL Data Warehouse database. One of the important parameters is the edition. What are my possible values?

Answer: DataWarehouse only

Explanation:

The parameter for Azure SQL Data Warehouse databses is just "DataWarehouse".

Ref: CREATE DATABASE - click here


» Discuss this question and answer on the forums

Featured Script

Table Valued Function to factorize numbers up to 100 trillion

Jonathan Roberts from SQLServerCentral.com

To use this function you will need a populated table of primes. See script: http://www.sqlservercentral.com/scripts/Prime+Numbers/155286/
Theoretically the maximum number that can be guaranteed to be factorized is the maximum value of a bigint (9223372036854775807) but to guarantee factorisation you will need all primes up to the square root of that value in the dbo.Primes table.
To factorise any number up to 100 trillion you will need a Primes table with all prime less than 10,000,000. To do this use the the script here to generate a table of 10 million primes.
Sampe call to factorise a number: 
SELECT * FROM dbo.PrimeFactors(99999820000081) 

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 2016 : SQL Server 2016 - Development and T-SQL

SSIS trace end of iteration in container - In SSIS I have a container with a few tasks inside. The container iterates through a rowset or files (does...

sysdatabases vs sys.databases - Currently we have a query that re-indexes all databases but fails when it gets to a "read-only" database since it...


SQL Server 2014 : Administration - SQL Server 2014

Deadlock with two update statements - Hi Guys, I am getting a deadlocks recently on one of my instance of SQL Server. Below are the two statements...

Uninstallation Logs - Hi All, Is there any way we can find who has uninstalled SQL Server. I have checked Windows logs but could not...


SQL Server 2014 : Development - SQL Server 2014

Help with SQL Loop Query - Hi Guys, I am using below While Loop Syntax but for some reason, I can't update the records or it...

Still driving me nuts: selecting several timelines from several lines from multibale tables - So, I called in your help a week ago on this post: https://www.sqlservercentral.com/Forums/1869218/Driving-me-nuts-selecting-valid-timelines-from-several-lines-in-a-table It helped me out for a first part, but...


SQL Server 2012 : SQL 2012 - General

Database mail error - SQL Server 2012 . I have set up a profile and account. use msdb GO EXEC

Giving Access to Only One View - I have created a user and a server role and assigned the role to the user. I can now connect...

Index analysis is not working in my SQL sentry tool , Any experts ? - Index analysis is not working in my SQL sentry tool , Any experts ?

creating new partition files on table - hello all,   I have a table that has 2,948,231,398 billion rows...I know...last week I had to figure out how to...

SQL Server core usage - Hi all I've been doing a bit of a check on some our servers and found something odd in the logs. I've...


SQL Server 2012 : SQL Server 2012 - T-SQL

Convert name field from Colunm1: FirstName LastName to Column2 as LastName, FirstName - I have a column FullName with data as follows:    John Doe    Joe Doe    Jane Doe I want a result in a new...


SQL Server 2008 : T-SQL (SS2K8)

INSERT INTO, EXCLUDING ONE COLUMN - Hi Is there a way I can: INSERT INTO TableA SELECT * FROM TableB but exclude one column from TableB? My TableB has ID which is...


SQL Server 2008 : SQL Server 2008 Administration

database not restoring to original physical names ndf files in backup - Hi All, I have a backup db and running RESTOREFILELISTONLYFROM


Cloud Computing : SQL Azure - Administration

Is High availability group the way to go? - Hello, We have developed four azure databases.  As we are planning the production environment, I have been given some requirements. 1.  Highly available. 2. ...


Reporting Services : Reporting Services

parameters list: Allow multiple values not working - I have a parameters (drop down list) containing all text values that I built by manually providing the values in...


Reporting Services : SSRS 2012

Carriage return in sql is not working when exporting to SSRS - This is just a part of my sql function.  I am inserting carriage return for getting next line behaviour. But...


Programming : XML

XQuery error - I am trying the following: declare @packXML XML = '<Pack> <PackID>1</PackID>   <Item>   <ItemNumber>1</ItemNumber>   <Qty>1</Qty>   </Item> </Pack> <Pack> <PackID>2</PackID>   <Item>   <ItemNumber>1&


Data Warehousing : Integration Services

SSIS 2016 Installation fails - Hi Folks, I have an installation of SQL Server 2016 CTP3 on my laptop, a Windows 10 machine, as a test...


Data Warehousing : PowerPivot

Insert PowerBI graph into Powerpoint - Inserting Excel objects into PowerPoint is easy... Any idea how to insert a PowerBI graph in there? Don't know if...

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