Understanding Machine Learning (SQLServerCentral 3/6/2018)

[SQLServerCentral - www.sqlservercentral.com]( A community of more than 1,600,000 database professionals and growing Featured Contents - [Understanding Machine Learning]( - [The Many Levels Of Concurrency]( - [Killing A Service Broker SPID]( (From the SQLServerCentral Blogs) - [Power BI Custom Visuals Class (Module 91 – Smart Filter by OKViz)]( (From the SQLServerCentral Blogs) Featured Script - [Unused Indexes in your databases]( The Voice of the DBA Predictions for the Future There is no shortage of predictions that we all make every day. Long before [PREDICT]( and the popularity of Machine Learning/R/Python and more, each and every one of us has regularly made guesses about what will happen in our world. Some of us make large predictions, like faxes will be used forever, and some of us make small ones, like it's going to snow more than the forecast tonight. Our world shows us data and we make guesses. Many of us are data professionals and we are looking to grow our careers and improve our skills on a regular basis. At least, I hope you are. A friend mentioned to me that it's hard to decide where to focus energy and attention these days, as SQL Server grows and expands, and time is limited. Are there topics that might be better or worse for us to learn about? After all, no one wants to be the person that invested a year of their time in the next Notification Services. I don't have any great predictions for SQL Server, but I did think about the possibilities recently. I was [interviewed by Mohammad Darab](, and had to answer a number of questions looking forward. As I re-read the interview, I think I waffled a bit, mostly because the world doesn't change at an even pace. Some companies will advance fast, and some slowly. I think it is important to expand your skills and consider the cloud and related technologies, but there will certainly be some companies that never move. There are [other interviews]( in his series, and as I read them, I think about the different perspectives. We're all close in what we think, but with perspectives that skew slightly away from each other. Most people seem to view the world as changing, but not nearly as fast as some articles and talks would lead you to believe. Grab 3 or 4 random interviews and compare them. While I do think that data and databases, including SQL Server, will grow in importance and relevance, I also think that we will have a constantly growing opportunity of potential jobs and projects to tackle. Where I become cautious, and the reason I advocate continuing to learn, is with convenience. Will those jobs be in your company? Or your town? Will your job continue on until you retire? It's entirely possible that the world will change and potentially force you to make drastic changes in your life. Change careers, move to a new location, or endure conditions that make you unhappy. The future has one certainty; it's uncertain. I tend to hedge my chances of minimizing disruption through education. I'd encourage you to do the same. 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.0MB) 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 [SQL in the City]( Free data protection and privacy livestream Many of you will be aware that the new GDPR legislation comes into effect in May and, in light of this, Redgate recently hosted a livestream that included sessions to help you become best equipped to deal with the challenges GDPR brings to compliant database management. [Watch the recording]( [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  [] [Understanding Machine Learning]( Narendra Bhogavalli from [SQLServerCentral.com]() This article describes about the understanding Machine Learning and bits of Artificial Intelligence as it’s a superset of Machine Learning.[More »](learning/167368/) ---------------------------------------------------------------  [] [The Many Levels Of Concurrency]( Additional Articles from [Brent Ozar Unlimited Blog]( When designing for high concurrency, most people look to the hardware for answers. And while it’s true that it plays an important role, there’s a heck of a lot more to it.[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Killing A Service Broker SPID]( MarlonRibunal from [SQLServerCentral Blogs]( Killing a SPID shouldn’t be complicated. Execute the command KILL [SPID] and that should kill the session. But there are situations...[More »]( ---------------------------------------------------------------  [] From the SQLServerCentral Blogs - [Power BI Custom Visuals Class (Module 91 – Smart Filter by OKViz)]( Devin Knight from [SQLServerCentral Blogs]( In this module you will learn how to use the Smart Filter by OKViz. The Smart Filter works similar to...[More »]( Question of the Day Today's Question (by Steve Jones): I have a database, named Accounting, that is encrypted with TDE. After a few years, I realize that my certificate is expired. I create a new certificate on my instance with this code: CREATE CERTIFICATE NewTDECert WITH SUBJECT = 'My Valid TDE Certificate'; go What code do I execute in the Accounting database to rotate the new certificate into my TDE database? 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: Transparent Data Encryption (TDE). 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 [SQL Server T-SQL Recipes]( SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. [Get your copy from Amazon today](. Yesterday's Question of the Day Yesterday's Question (by Evgeny Garaev): Which operating systems are supported for SQL Server 2017 on Linux installations? (choose 3) Answer: - Red Hat Enterprise Linux 7.3 and 7.4 - SUSE Linux Enterprise Server v12 SP2 - Ubuntu 16.04 Explanation: Currently (Mar 2018) officially supported versions of SQL Server are: - Red Hat Enterprise Linux 7.3 and 7.4 - SUSE Linux Enterprise Server v12 SP2 - Ubuntu 16.04 Ref: Installation guidance for SQL Server on Linux - [click here]( --------------------------------------------------------------- [» Discuss this question and answer on the forums]( Featured Script [Unused Indexes in your databases]( Rabie Harriga from [SQLServerCentral.com]() Run this Script in the context of your database [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 2017]( : [SQL Server 2017 - Administration]( [SSRS 2017 data source type]( - I did an in place SQL server reporting server upgrade for 2017 SSRS. The server has both database engine and SSRS... [deadlocks and Stats]( - Hi I was getting alerts about deadlocks continuously every min on the server, I updated stats and alerts stopped. Again after ... [Always on and SSISDB]( - Hopefully someone more knowledgeable than me can help with this one. I am building out a SQL 2017 Always on availability... [oracle quctions]( - hi frinds i have one table. 100 records is hear. i want delete the 400 to 500 records only how to... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Administration]( [Multiple instances in one server]( - Hi, I have a client that has almost 4.000 databases, each for a customer. We are restructuring the server and migrating to SQL... [Strange - Availability Grorup Issue]( - I have a database which is part of Availability Group across 3 servers. All servers are at same patch i.e... [Help me in designing table and its indexes]( - [Verify backup files. How much does it help?]( - Since I start my DBA career, as the best practice, I always verify backup to make sure it is complete... [AlwaysOn Availability Groups Cluster Name vs. Listener Name]( - Hi, I've been working on setting up AOAG for the first time. I see a lot of benefits to having this... [SQL 2016 Always Encrypted feature]( - Hi All, Can we setup the always encrypted feature using tsql? What I mean is, if i want to enable... [SQL Server 2016 cluster issue]( - Hi, We have installed SQL server 2016 Standard (SP1)  in two-node Windows 2016 Fail-over cluster successfully.. When we restart SQL... [SSD server with 1 logical drive]( - We are looking to upgrade to a solid state drives only server. It will be raided. Does it make any... --------------------------------------------------------------- [SQL Server 2016]( : [SQL Server 2016 - Development and T-SQL]( [Moving Annual Total cross tab by month with Difference in one column]( - Hi I'm trying to create the below without relying on Excel, but am struggling to get the difference value and % difference showing... --------------------------------------------------------------- [SQL Server 2014]( : [Administration - SQL Server 2014]( [FileTable issue]( - Hi Experts, I have created a filetable with full access and created a trigger on Filetable to insert the filename and... --------------------------------------------------------------- [SQL Server 2014]( : [Development - SQL Server 2014]( [updates are not happening through ssms]( - hi, I have created after insert ,update,delete trigger for one of the table.The table does not have any primary key.When we... [How does SQL Server handle concurrent operations?]( - Hello, We are having an issue which I suspect is database related. We have a web application on which we can... [Is this Deadlock due to Lock Partitions?]( - The same update ran a few miliseconds apart. It causes deadlock. Col2 is primary clustered key. In execution plan, It's... --------------------------------------------------------------- [SQL Server 2012]( : [SQL Server 2012 - T-SQL]( [Manipulate a field that contains a specific format]( - Hi, Please can anyone assist with my SQL problem? Here's an example of the contents of a single field: abcdef 01/01/2018 08:15:13 This is... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server 2008 - General]( [How can I leave only only 10 days of SQl Server logs in sql server???]( - Dear Fiends inside "Management> SQL Server Logs" I want to automatically delete old logs How can I leave only only 10 days... --------------------------------------------------------------- [SQL Server 2008]( : [SQL Server Newbies]( [How to bring database just before the delete occurred.]( - Good Morning Experts, We are taking full backup every saturday at 9PM, differential backup daily at 9PM and transaction log backups... This email has been sent to {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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com