SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

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.com

Join 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. 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
Foundry

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

SQL Monitor

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

Featured Contents

 

Stairway to T-SQL DML Level 3: Implementing a Relational Model in SQL Server

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 »


 

Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA

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 »


 

Performance Myths : Oversizing string columns

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 »


 

From the SQLServerCentral Blogs - Default Instance Reports – Configuration Changes History

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 »


 

From the SQLServerCentral Blogs - Running Linux Containers on Windows

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 »

Question of the Day

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 Phoenix Project: A Novel about IT, DevOps, and Helping Your Business Win

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.

SQL Server 2016 : SQL Server 2016 - Administration

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)  


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

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


SQL Server 2014 : Administration - SQL Server 2014

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


SQL Server 2014 : Development - SQL Server 2014

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 : SQL 2012 - General

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


SQL Server 2012 : SQL Server 2012 - T-SQL

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


SQL Server vNext : SQL Server 14 - Administration

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


SQL Server 2008 : SQL Server 2008 - General

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


Reporting Services : SSRS 2012

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


Reporting Services : SSRS 2014

SSRS Report Security - - SSRS 2012  -we have aset of report all using the same data source: XXXXX  


Reporting Services : SSRS 2016

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


Data Warehousing : Integration Services

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


SQL Server 2005 : Administering

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


SQL Server 2005 : SQL Server Newbies

Calculated Query Help - Hi, I am struggling to grasp on how to calculate in SQL where there is a fixed Qty in stock and...


Career : Presentations and Speaking

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