SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Citizen Scientists

The last few years have seen quite a bit of demand for people that can analyze data. Certainly the Microsoft platform has embraced more ways to import and visualize data with tools like Power BI, more intelligent analysis with SQL Server Machine Learning and Azure Machine Learning. I think this is because there's been quite a demand for data scientists, and with all the media attention, plenty of IT executives are searching for these people.

It's a good time to change to that type of career, if it's what you want. You certainly should investigate what's involved if you have any interest. Buck Woody has a Data Science series that can help you. Microsoft has a Professional Program in Data Science, and there are not shortage of R and Python resources that can help you experiment with data analysis in a new way. SQL queries work well, but you might find that having other tools in your toolbox is helpful. 

As much as there is a demand for professionals, Microsoft, Amazon, Google, and others are trying to find ways to reduce the cumbersome nature of the tools so that anyone that understands the science part can do the work. Will this mean the average business analyst be able to leverage tools and platforms to perform complex data analysis? Maybe, but I don't believe these citizen scientists will remove the need for dedicated professionals. There's an argument in this piece that they might, so you'll have to decide what you think.

The danger is that it becomes so easy to perform some analysis and create a visualization that we will likely have lots of people building reports and drawing conclusions without really understanding how they've aggregated or filtered data, perhaps without even understanding the implication of making these changes. I could see all sorts of poor decisions being made because a manager thinks anyone can use a tool to extract information from data, so they let just anyone do so. 

Maybe this is where the data scientist steps in. Help users to refine their analysis, understand the problems when data is put together or taken apart with these tools. Certainly they should ensure that users have good, clean data sets. The last thing we want is another IT bottleneck, but perhaps using highly technical people to review other analysis and ensure no fundamental mistakes are being made by the analysts is a good use of IT skills.

This is another place where we need to ensure that different groups inside of a company can work together to be more effective for the organization. That's the DevOps mentality. We get things done, regardless of who does the work or whose responsibility it is on paper.

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

Database DevOps Demo Webinar

Learn how to automate your database deployments alongside your app code in this free demo webinar. Register now

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

Featured Contents


WorkPlace Encounters: Grappling With ASYNC_NETWORK_IO Waits

Kenneth Igiri from SQLServerCentral.com

An account of a recent encounter we had with a peculiar wait event which was initially misdiagnosed. More »


Automated Database Provisioning for Development and Testing

Additional Articles from SimpleTalk

If your development team needs to work on anonymised copies of the current production database, and if changes are being delivered rapidly as well, that could mean a lot of time and routine DevOps work copying databases. SQL Clone was designed for tasks like this. Grant Fritchey investigates whether you save time, effort and scripting over the more traditional approach, and at what point it makes sense to use it. More »


How to examine differences with SQL Compare Summary View and SQL View

In this video, Steve Jones introduces the new Summary View that's now available in Redgate SQL Compare. More »


From the SQLServerCentral Blogs - Power BI Custom Visuals Class (Module 71 – Timeline Storyteller)

Devin Knight from SQLServerCentral Blogs

In this module you will learn how to use the Timeline Storyteller.  The Timeline Storyteller is a great way to... More »


From the SQLServerCentral Blogs - Toolbox - Fix Your FILEGROWTH

Andy Galbraith from SQLServerCentral Blogs

One of the items we usually flag in reports is FILEGROWTH by percentage.  It doesn't help that for most versions... More »

Question of the Day

Today's Question (by Steve Jones):

The event counter target is used to count the number of times each specified event occurs. How does this processing occur?

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: Extended Events (XE).

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


T-SQL Querying (Developer Reference)

Squeeze maximum performance and efficiency from every T-SQL query you write or tune. Four leading experts take an in-depth look at T-SQL’s internal architecture and offer advanced practical techniques for optimizing response time and resource usage. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

A smalldatetime type uses half the storage of a datetime or datetime2 type. In which year will I run out of storage capability for smalldatetime?

Answer: 2079


The precision of smalldatetime goes from 1900 to 2079 in years. Actually June 6, 2079.

Ref: Stairway to Advanced T-SQL Level 9: Compare, Modify, Derive and Validate Date and Time Values

 Smalldatetime - https://docs.microsoft.com/en-us/sql/t-sql/data-types/smalldatetime-transact-sql

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

Delete DB, where physical files are missing - Got a situation, the storage location where the physical DB files existing is been deleted by storage team. Now, i'm...

SSMS version for SQL Server 2016 - We are in the process of upgrading our servers from SQL Server 2008R2 to 2016. What version of SSMS would...

Reset SA password - Hi, I have RDP access to windows server but i doesn't have access to SQL instance. I doesn't have SA password. How to...

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

Using Date in Where Condition - I Have issues in selecting records when using date in  my where clause   1 )  I am trying to fetch records for...

Having clause - Hi, Need to add having clause as tansaction_count>1 after group by clause in below query . Transaction_count is exist in table dbo.TABLEW Any...

SQL Server 2014 : Administration - SQL Server 2014

Replication between versions - Howdy all.   I am attempting to set up transactional replication between on prem SQL 2014 SP1 to AWS SQL server 2016....

SQL Server 2014 : Development - SQL Server 2014

query format - CREATE TABLE .(  NULL,   (50) NULL ) ON INSERT INTO .(,) VALUES(1,'Architect') INSERT INTO .(,) VALUES(2,'Developers') INSERT INTO .(,) VA

SQl to calculate average time for call centre agents - A row is created in the CALLSTATUSLOGGING table every time an agent's state is changed. A row is also inserted...

Comparing 2 functions for any differences in the result set. - Recently, we've done some optimizations to the functions and now the BI Manager has tasked me with a request to...

SQL Server 2012 : SQL 2012 - General

Determining cost threshold for parallelism - I have this query to find the cost of plans that use parallelism, but not sure how to proceed as...

SQL 2005 Migrate to SQL 2012 in VM Server ISSUE - We are migrating SQL Server 2005 database to SQL Server 2012 on VM Server. The VM Server OS is Windows 2012...

SQL Server 2012 PREEMPTIVE_OS_CRYPTOPS Wait - Hi, I do not see any documentations by Microsoft on SQL Server 2012 PREEMPTIVE_OS_CRYPTOPS Wait type, any suggestion on this as...

SSRS average column group value for a row group - Hi All, So I'm having a fight with Reporting Services at the minute when trying to compute an average at the...

SQL Server 2012 : SQL Server 2012 - T-SQL

expecting ID or quoted_ID. Help! - error i'm getting  from the below query: Incorrect syntax near '@DatabaseName'. DECLARE @DatabaseName as NVARCHAR(200); DECLARE DatabaseCursor CURSOR FOR SELECT Name FROM sys.databases WHERE...

Compare two columns - Hi guys,   need quantity from previous row , when prev_orderid=orderid from previous row. for ex:  If prev_orderid=44086564 matches orderid = 44086564 then i need to...

Require help with creating a view with YTD balances and period - Hi, I have to implement a view that has account number, year, period (month), balance, and Year-end balance. We already have...

SQL Server 2008 : T-SQL (SS2K8)

Stored procedure to pass date ranges - I would like to write a stored procedure that use the date range for the different sum and count functions....

Reporting Services : Reporting Services 2008 Development

Long-running script with IE11 - Hi guys, I am currently facing an issue with SSRS 2008 and I will like to get your support regarding this. I...

Data Warehousing : Integration Services

failure precedence - Hello, Package has several tasks connected to each other... I am introducing a failure precedence so I set the task1 to fail...

Argument "" for option "maxconcurrent" is not valid. The command line parameters are invalid. - Hello We have a strange problem, using SQL Server 2016, project development model. High level, the flow is as follows: Generate a...

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