| A community of more than 1,600,000 database professionals and growing |
| | Data Science en Masse GE is an amazing company. They seem to have so many divisions and produce a wide variety of products. Their financial investment success amazed the world and made Jack Welch an icon to many businesspeople. I remember reading about revolutionary management techniques at one of their jet engine plants that dramatically increased efficiency and performance of that location, similar to the ways that DevOps can produce better software. They have transformed the company from light bulbs to televisions to nuclear power and more across the decades. And they're not done yet. GE is building a workforce for the 21st century, teaching many of their employees about data science and machine learning. The company is working to retrain scientists and help them explore new ways of using AI techniques to build better software. There are machine learning and data analytics courses available to employees, with the aim of creating hybrid employees that add digital skills to the knowledge they already have in other areas. Why is GE looking to transform it's workforce with data science skills? They are creating AI software for their products and hoping to expand this further into more areas. With the competition from many other vendors, the ability to generate better results for clients, even just slightly better, might be enough of a differentiator to allow them to continue to grow as a leading industrial company. Would this work for your company? Your import organization, service company, retail business? Perhaps. Machine Learning isn't perfect and doesn't produce the best decisions, but if it can slightly improve the performance of your organization, perhaps it's worthwhile. Microsoft is certainly making some of practical elements cheaper with the easy to use with new products, such as Azure Machine Learning. The challenge is that this is just the final element. Your company still needs someone that has built some knowledge of the deep mathematical concepts behind machine learning and has spent quite a bit of time experimenting with your data, building models and determining the relevant features needed. Preparing and loading data is also a challenge, which is why I think one of the core skills future data professionals need is the ability to quickly and effectively build ETL pipelines. If you can get those things done, a tool like Azure ML might be just the thing to add a few efficiency (or profitability) points to your bottom line. 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.8MB) 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 | | Using SQL Census to audit SQL Server permissions Redgate have just released SQL Census, a prototype tool that makes auditing SQL Server user access permissions much easier. In this post, Ally Parker shows how it works, tells us what's up next in the tool's development, and explains how you can download it for free. Try the free prototype |
| | New SQL Monitor Reporting Module SQL Monitor now includes a new Reporting module. It allows you to create customized reports, combining the individual server performance metrics available in SQL Monitor with summary information on your entire SQL Server estate. These reports can then be exported to pdf and emailed to you on a scheduled basis. Download SQL Monitor now and get a 14 day free trial |
|
|
|
| | | Gregory Larsen from SQLServerCentral.com This level of the stairway details the creation of a relational database, as well as filling in some of the history of the relational database model. More » |
| Press Release from Redgate Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks". More » |
| Additional Articles from SQLPerformance.com Aaron Bertrand shows a quick demo that illustrates why you should be very careful about oversizing varchar / nvarchar columns. More » |
| Kenneth Fisher from SQLServerCentral Blogs Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured... More » |
| Andrew Pruski from SQLServerCentral Blogs Microsoft have announced the availability of SQL Server 2017 RC1 and I wanted to check it out in a container... More » |
|
|
| | Today's Question (by Steve Jones): I have this R code > values <- -10:10 > absolutes <- abs(values) I want to plot a graph that looks like a greater than symbol (>). Which plot does this? |
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 | The company's new IT initiative, code named Phoenix Project, is critical to the future of Parts Unlimited, but the project is massively over budget and very late. The CEO wants Bill to report directly to him and fix the mess in ninety days or else Bill's entire department will be outsourced. Get your copy from Amazon today. | | |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I have this sample data CREATE TABLE EncryptedData ( MyID INT , MyVal VARBINARY(max) ); GO INSERT dbo.EncryptedData ( MyID, MyVal ) VALUES ( 1, ENCRYPTBYPASSPHRASE('ProtectThIs!', CAST(100000 AS VARCHAR(100))) ) GO I want to decrypt it, but this is what I get. SELECT MyID, DECRYPTBYPASSPHRASE('ProtectThIs!', MyVal) FROM dbo.EncryptedData; MyID ----------- -------------------- 1 0x313030303030 What should my SELECT be to get this data back? Answer: SELECT MyID, CAST( DECRYPTBYPASSPHRASE('ProtectThIs!', MyVal) AS VARCHAR(200)) Explanation: When the data is decrypted, it is returned as varbinary. In order to read it, the data must be cast back to a character value. Ref: DECRYPTBYPASSPHRASE() - 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. how to deploy 10 T-SQL scripts across 200 databases - Hi , Can any one suggest an efficient way where we can apply about 10 T-SQL scripts on about 200 databases... SQL Server geo-cluster 2016 - Dear Everyone Ikeep reading online that its not recommended to virtualize SQL Server clusters (4 nodes) Need help in SQL table for updating NULLS - Changing type from INT to BIGINT why so slow? - I was hoping SQL Server 2016 could handle change in types. With this table of numbers it takes an age to... Index Usage Question - OK, I feel like a dummy because I thought I knew\understood this but I am putting together a very basic... Should I Re-design table? - This table has high transactions with select, insert, update, delete and It index got fragmentation about 90% after rebuild 3-4... High level performance report aimed at senior management - Hi all, I've been in the SQL space for a number of years now and recently been asked to act as... SQL Server 2012 Express edition installation error! - Hello, I'm urgently trying to install SQL server express onto my Windows 7 laptop (x64) but keep receiving the setup error... SQL Server 2012 Exam 70-462 practice questions - Hi guys, I'm currently studying for the 70-462 exam using the Administering Microsoft® SQL Sever® 2012 Databases. i have been through... Find Missing Rows Comparing Two Tables - I have two tables - prod table shows employees and prod id that they are allowed to sell. Inv table has invoice... Login error - The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452) - Hi All, I am getting below error while trying to connect SQL from remote server. Local login is working fine. Can... Need to setup a sql alert on “waiting tasks” - similar to “waiting tasks” in Activity Monitor - My manager has asked me to work upon a request. I am not sure if it is reasonable or weird... SSRS Result Set Question - I'm trying to change this sql query from if-else to set-based. However, the first set-based query is picked up by... SSRS Report Security - - SSRS 2012 -we have aset of report all using the same data source: XXXXX Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' - Hi guys I have installed SQL Server 2016 development edition with CU3 including SQL Database Engine, SSRS, SSAS, SSIS all on... No Columns Listed in OLE DB Source Editor Window - Hello, I am trying to set up an integration services package to export the results of a query to a .csv... Database Mirroring ( Principle , disconnected) - Hello All, i have two databases set up as database mirroring on sql server A. connect to SQL SERVER B. every thing... Database in Recovery Pending State - One of my databases is in Recovery pending state. I tried to run an Alter command on the database to... Calculated Query Help - Hi, I am struggling to grasp on how to calculate in SQL where there is a fixed Qty in stock and... Potential presentation idea: So you want to be a SQL Saturday speaker? - This idea is based on a 'blog article of the same name that I wrote a while back. I was just... |
|
| 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 |
|
|