| A community of more than 1,600,000 database professionals and growing |
| | | Democratic Data Science I know quite a few people that are jumping on the data science bandwagon, brushing up on statistics, learning R, and hoping to land one of those lucrative data scientist positions. I wish you good luck, and some of you will succeed, but I wouldn't count on there being lots and lots of data science positions in the future. The work is hard, and it will take a lot of learning and practice to become good. Plus, perhaps we won't need as many data scientists as some are predicting. There seems to be a lot of work being done with intelligent agents and "bots" that can perform some lower level analysis of data and interact with humans. However, there is also work being done with more capable software that might analyze data and find patterns by applying different algorithms and analysis to make it easier for business analysts to comb through the mountains of data. After all, the growth of IoT, of more metrics and measurements being made in all kinds of applications mean that we can't just throw bodies at problems. We need better ways to work with large amounts of data. This work isn't really aimed at eliminating data scientists or data analysts. Rather, this is aimed at trying to free up their time to do the creative, thoughtful work of examining data. The grunt work of playing with algorithms and testing them according to some measure of success is handled by software. I think that this is a mantra that will be repeated over and over in the next couple decades in computing. Grunt work is automated, thoughtful work is done by (well-paid) humans. If you're not doing the latter, you might not have a job with the former. I do think there is still plenty of opportunity for data professionals, after all, we need to manage all that data, find ways to ensure it's available and can be queried, data is somewhat clean, and certainly that we have some idea of what the data means to our business. I'm not sure software agents will easily be able to set those things up, though certainly they'll do the work of applying our rules to large sets of data. There will still be plenty of data science roles, and certainly humans need to be watching the software to be sure it's working well. There will always be tuning efforts, and perhaps always reports that users need help in building. However, as software becomes more sophisticated, there will certainly be less grunt work in our industry, just like many other industries have seen lower, or at least lower mid-level positions reduced in number. We should be prepared to prove our value and ensure our skills are useful to our organizations. Steve Jones from SQLServerCentral.comJoin the debate, and respond to today's editorial on the forums |
| | The Voice of the DBA Podcast Listen to the MP3 Audio ( 3.0MB) podcast or subscribe to the feed at iTunes and LibSyn. 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 | | | | Automate
database
changes
using continuous integration
&
automated deployment | | A fast, reliable way to test and deploy your SQL Server database changes. | | |
|
|
|
| | | | | John F. Tamburo from SQLServerCentral.com Risk-averse managers are reticent to upgrade to the latest and greatest. Why is this the case and how can the savvy DBA make the case for and get ready for a newer version of SQL Server? More » |
| | Additional Articles from MSSQLTips.com The solution here was to slightly modify the slow queries, so the index could be fully used. We made the queries Search Argumentable, or "SARGABLE." More » |
| | Allison, one of Redgate’s designers, is working to make their website easier to use. Could you spare five minutes to help her out? All you need to do is fill in this quick survey, and as a thank you, you’ll also be entered into a draw for an Amazon voucher worth $50. More » |
| | Devin Knight from SQLServerCentral Blogs In this module you will learn how to use the Radar Chart, a Power BI Custom Visual. The Radar Chart... More » |
| | Colleen M. Morrow from SQLServerCentral Blogs This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging... More » |
|
|
| | | Today's Question (by Ben Kubicek): When doing a backup of a database, what does the Copy-only Backup option 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: Backup. 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 | | Power Query for Power BI and Excel Power Query for Power BI and Excel is a book for people who are tired of copying and pasting data into Excel worksheets. Power Query, part of the Microsoft Power BI suite, is a tool that automates the process of getting data into Excel and will save you hours of dull, repetitive, and error-prone work! Power Query makes it easy to extract data from many different data sources, filter that data, aggregate it, clean it and perform calculations on it, finally loading that data into either your worksheet. Get your copy from Amazon today. | |
|
|
|
|
|
|
| Yesterday's Question of the Day |
| | |
| | | | Sheraz Mirza from SQLServerCentral.com Getting Previous is next values is always a need for any database professional, specially Analyst and Developers, SQL Server provide built in Functions for this purpose which are introduced in SQL Server 2012, This Script is useful to get same results in Earlier versions like 2008, 2008R2 etc. We can get our result in three easy steps 1. create a Table and insert some dummy records for Demo. 2. Inserting Dummy Records 3. Query to see LEAD and LAG Values Here is your Previous Values /LAG Function Result and here is your Next Values /LEAD Function Result See you next time guys ..... 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 RTM (13.00.1708.0) Database Mail Not working - Hi Does anyone have database mail working with SQL 2016 (Standard Edition) and the Critical update 3164398? I've configured DB mail on... Reduce Log Database - Dear good day , I have a database of Dynamics NAV , this overgrown in the week do a FULL, every day... SQL 2014 design with SSAS - Hello! Can you help me with SQL 2014 SSAS design? I am planning to install SQL 2014 on two servers and... Change Port of a Default Instance - I'm trying to test changing the port on a default instance to something other than 1433. I don't want to... Best way to filter columns - Hi, I have an application where we gather RSS news feed from around the world into this staging table. From that staging... LS DR Testing on Always On setup - Hi All, I need your experience and advice for below test. I have setup like Always on setup with on... Need Help in Understanding - Hello, I have written 2 queries, and want to get combined result from them. First query gives me purchases. [code="SQL"]select tblP.Product_Code, tblC.DescriptionLanguage_1, sum(tblPIID.QtyReceived1 + tblPIID.QtyReceived2 + tblPIID.QtyReceived3... distribute available quantity between stores - i have this table with this data [code="vb"] ID Store SKU AvailableQty ReceivingStore QtyDemand Transferred 1 ST1 100 20 ST2 14 14 ... Merge statement with conditions - Hello, I am trying to merge a temp table (@TempTable) into a table(@MasterTable). I have 6 fields I need to compare... Return string between 2 characters from the end of the string - I have data in a field that looks like this: 'INV CRT IS15000467 1', 'INV CSH 144934 1', 'INV CSH... Reporting Services - Passing Parm String to Stored Procedure ? - I am a R.S. noobie. Another guy here develops in it a bit, so we need "RS for Dummies " help. We... Convert multiple rows to columns Dynamically - I need to convert my data set from multiple rows to columns and sum by multiple fields. Below is sample... Generate n random int subsets - Howdy SSC, I'm trying to generate some realistic test data to do some load testing. The app I'm testing takes a... Need algorithm for Complex looping logic - Dear All, Hope all are good. I am Sql developer but i was in support ,now in developement, i am... What's the reason? - Hi Friends, I had a question during my interview, as saying that What could be the reason when I am trying... SSRS Returns Wrong End Date Parameter - Hi i have this problem with my date parameter: from my internet page/portal I generate my report: [url=http://localhost/BOPortal/Reports/View/Events?FromDate=2016-06-22%2022:00:00&ToDate=2016-06-23%2021:59:00&Language=en-GB&User=admin]http://localhost/BOPortal/Reports/View/Events?FromDate=2016-06-22%2022:00:00&ToDate=2016-06-23%2021:59:00&Language=en-GB&User=admin[/url] When portal send t SSRS show trend chart by up and down arrow over column chart per series groups - chart data Values- No of Itemsold Group-Product(ProductA,ProductB,ProductC...) Series -Year(2013,2014,2015,2016) I have to show the trend of the item sold for each group by a... How to propagate relationships for calculated members in SSAS? - I am stuck in a situation which I believe should have a ready solution because it looks like a common... SQL Server replication requires the actual server name to make a connection - Hi, I'm working on a virtual server with SQL Server 2005 installed. The server was called VM_NNNN_ABC1 and the SQL Server had... "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT' could not be opened. Operating system error code 5(Access is denied.). - I've created a set of SSIS packages which run fine in our test environment. The packages access a SQL server... |
|
| 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 ©2015 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com |
|
|
