The Complete Weekly Roundup of SQL Server News
In this issue:
T-SQL
- [Can you prevent deletes and inserts without a WHERE clause from running?](#30709)
- [Renaming a Columnâ#SQLNewBlogger](#30680)
The Lighter Side
- [The 2017 Christmas List of Best STEM Toys for kids](#30698)
- [SpaceXÂ has a momentous launch this week [Updated]](#30687)
- [Ready Player One arrivesâabundant references intactâin its first full trailer](#30686)
- [Check out this awesome Ralph McQuarrie-inspired The Star Wars concept trailer](#30683)
Tech News
- [Why the Role of Chief Data Officer Is Gaining Influence in Enterprises](#30710)
- [Ajit Pai offers no data for latest claim that net neutrality hurt small ISPs](#30684)
SQL Server Security
- [SQLÂ SERVER â FIX: Msg 15150 â Cannot Alter The User âdboâ.](#30695)
- [Understanding Keys and Certificates with Transparent Data Encryption (TDE)](#30674)
SQL Server on Linux
- [Configure SQL Server 2017 on Linux with mssql-conf, the Linux way](#30703)
- [Reset SA password on SQL Server on Linux](#30682)
SQL Server News
- [Whatâs new in SSMS 17.4: SQL Vulnerability Assessment](#30691)
- [Try mssql-cli, a new interactive command line tool for SQL Server](#30690)
Software Development
- [An introduction to regular expressions](#30697)
Security news and thoughts
- [Have You Been 'Pwned' in a Hack Attack? Troy Hunt Can Tell](#30693)
- [Hundreds of HP Laptops, Tablets Found with Pre-Installed Keylogger](#30692)
- [Hackers hit key ATM network in crime spree that clears $10 million](#30685)
R Language
- [RÂ in the Windows Subsystem for Linux](#30705)
PowerShell
- [Install SQL Server 2017 Using PowerShell Desired State Configuration and SqlServerDsc](#30707)
PowerPivot/PowerQuery/PowerBI
- [Scatter RViz: Power BI R Custom Visual](#30701)
- [Power BI Custom Visuals Class (Module 81 â Social Network Graph)](#30677)
- [List.Accumulate Hidden Gem of Power Query List Functions in Power BI](#30668)
- [The Power BI Gateway; All You Need to Know](#30667)
- [Dynamically change chart axis in Power BI](#30666)
Polybase/HDInsight
- [Troubleshooting Failed PolyBase Installation in SQL Server 2017](#30699)
Performance Tuning SQL Server
- [Is Your Database Overweight?](#30704)
- [Query Plan Oddities: Two Identical Missing Indexes](#30688)
- [Execution Plan Metrics and Units of Measure](#30676)
Microsoft News
- [Microsoft adds more AI-powered updates to Bing, Cortana, Office 365](#30706)
- [Microsoft Takes Path Less Traveled to Build a Quantum Computer](#30671)
Hardware News
- [Corsair Launches 'Worldâs Fastest' DDR4 SODIMM 32GB Memory Kit](#30696)
- [Volta-Powered GPU Delivers 110 Teraflops of Deep Learning Horsepower to Researchers](#30669)
Graph Databases
- [Bring clarity to complex data with graph databases on SQL Server 2017](#30700)
DevOps and Continuous Delivery (CI/CD)
- [What is database DevOps, and why is it important for DBAs?](#30708)
Computing in the Cloud (Azure, Google , AWS)
- [PaaSÂ and the ever changing role of the DBA](#30679)
Career Growth
- [Tell Us What You Make: The 2018 Data Professional Salary Survey](#30689)
- [BKâs Professional Learning Plans for 2018 #tsql2sday](#30675)
- [T-SQLÂ Tuesday #97 â Learning Goals for 2018](#30673)
Backup and Recovery
- [Installing the âOla Scriptsââ¦quick and easy database maintenance](#30670)
AI/Machine Learning/Cognitive Services
- [Machine Learning Services and Result Sets part 3](#30702)
- [Accessing AzureML models through SQL Server in-database R services](#30681)
Administration of SQL Server
- [SQLÂ SERVER â FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller](#30694)
- [SQLÂ Server Failed to Open Loopback Connection â What?](#30678)
- [Centennial apps/desktop bridge, SQL Server and error "The data area passed to a system call is too small."](#30672)
[Database Weekly - www.databaseweekly.com](
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge
SQL Server News for 2017-12-18
[SQL Prompt]( Could your SQL coding be more efficient?
Data Platform MVPs and SQL Server experts share their tips on how to standardize formatting whilst stripping out the repetition of coding with SQL Prompt. Over these 20 short videos we will help you write better, shareable SQL faster. [Check out the tips](
[SQL Source Control]( How to track every change to your SQL Server database
See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. [Learn more](
draft
Editorial - Understanding Your Value
Many of us work for some organization and get paid to do so. We might work for ourselves or others, but every so often we hope to get some renumeration for our efforts. For most of us, we negotiated some pay rate and then hope to get annual raises the reflect our work product.
The interesting thing that I've learned in many years of changing jobs and negotiating pay is that many of us have no idea what others doing similar jobs are being paid. There isn't a set scale of pay, unlike many other industries, and since our jobs can vary dramatically from organization to organization, despite having similar titles, we may learn that our compensation deviates dramatically from others in similar situations. I have found in the past that many people base their salary request on what they were previously making, not on what the market might be for others doing similar work.
Last year SQLServerCentral ran a salary survey and then [released the aggregated data](. This was a quick attempt to help you understand where you might stand relative to others, and it was very popular. Brent Ozar took our survey a step further, with [a more detailed set of questions and data](. This week Brent has beat us to the punch, with [a new survey for 2017](. I encourage you to participate and help build a useful data set. I plan on doing our own in the new year, and hopefully we'll have two good sets of data that you can review and analyze.
Most of us are data professionals, and we know that having more information helps us to make better decisions. Filling out these anonymous surveys can help others understand where they might stand relative to others. This is the type of data that can enable you to better negotiate your own pay in the future. I've had good luck asking for adjustments when I had information and confidence. You'll get both of these from the results of the survey, so take a few minutes and submit your information.
Steve Jones from [SQLServerCentral.com](
» [Join the debate, and respond to today's editorial on the forums](
---------------------------------------------------------------
The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit. These headlines are gathered throughout the week and are posted in real time at the [website](. Check there for information throughout the week or enjoy this weekly summary of the SQL Server world.
T-SQL
[]
[Can you prevent deletes and inserts without a WHERE clause from running?]( - File this under bad idea thong In the tradition of Klaus Aschenbrenner wanting to prevent people from writing SELECT * queries, I thought it might be nice to prevent people from running deletes or updates without a WHERE clause. In a vaguely scientific ......[(more)](
[]
[Renaming a Columnâ#SQLNewBlogger]( - Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One of the things I rarely do is rename objects. There are good reasons to do so, but often the changes required in other objects ......[(more)](
The Lighter Side
[]
[The 2017 Christmas List of Best STEM Toys for kids]( - In 2016 and 2015 I made a list of best Christmas STEM Toys for kids! If I may say so, they are still good lists today, so do check them out. Be aware I use Amazon referral links so I get a little kickback (and you support this blog!) when you use these ......[(more)](
[]
[SpaceXÂ has a momentous launch this week [Updated]]( - Enlarge / The rocket launching Tuesday first flew on June 3, 2017, and then (shown here) landed back on the Florida coast. (credit: SpaceX) SpaceX will attempt to launch its 17th mission of 2017 on Tuesday, a cargo supply flight to the International ......[(more)](
[]
[Ready Player One arrivesâabundant references intactâin its first full trailer]( - It's here, folks. After an initial glimpse at this summer's San Diego Comic-Con, the first full trailer for Ready Player One premiered this weekend. Author Ernest Cline brought the footage to his hometown theaterâAustin, Texas' Alamo Drafthouseâand ......[(more)](
[]
[Check out this awesome Ralph McQuarrie-inspired The Star Wars concept trailer]( - While most Star Wars pieces you'll see this week are focused on the soon-to-be-revealed adventures ......[(more)](
Tech News
[]
[Why the Role of Chief Data Officer Is Gaining Influence in Enterprises]( - A Gartner research report finds that the role of the corporate chief data officer is gaining in importance and influence in enterprises that recognize the value of data analytics to drive growth in revenue and profits. ...[(more)](
[]
[Ajit Pai offers no data for latest claim that net neutrality hurt small ISPs]( - With days to go before his repeal of net neutrality rules, FCC Chairman Ajit Pai issued a press release about five small ISPs that he says were harmed by the rules. Pai "held a series of telephone calls with ......[(more)](
SQL Server Security
[]
[SQLÂ SERVER â FIX: Msg 15150 â Cannot Alter The User âdboâ.]( - One of my clients was deploying SharePoint and they were following some documents to make sure it is as per their standard deployment. They were seeing below error while updating the login from dbo to some other login from user mapping window (for login ......[(more)](
[]
[Understanding Keys and Certificates with Transparent Data Encryption (TDE)]( - Iâve been taking a bit of a deep dive into understanding Transparent Data Encryption (TDE). As part of that Iâve been reading a lot of blog posts, stack overflow answers and technical documentation to try and deepen my knowledge. Within that Iâve found ......[(more)](
SQL Server on Linux
[]
[Configure SQL Server 2017 on Linux with mssql-conf, the Linux way]( - The configuration of any system plays a vital role in its working efficiently. However, configuring a system needs not necessarily be a daunting task. There are several tools that help with the process. SQL Server on Linux provides a wide range of options ......[(more)](
[]
[Reset SA password on SQL Server on Linux]( - This article is about how to proceed when you forgot the password of your SQL Server âsaâ account, Password was entered wrong many times then âsaâ account got locked, or someone wants to reset the password without using SQL Server management studio (GUI). The ......[(more)](
SQL Server News
[]
[Whatâs new in SSMS 17.4: SQL Vulnerability Assessment]( - This post is authored by Ronit Reger, Senior Program Manager, SQL Data Security and Alan Yu, Program Manager, SQL Server We are excited to announce the release of SQL Server Management Studio (SSMS) 17.4! Download SSMS 17.4 and review the Release Notes ......[(more)](
[]
[Try mssql-cli, a new interactive command line tool for SQL Server]( - We are excited to announce the Public Preview release of mssql-cli, a new and interactive command line query tool for SQL Server. This open source tool works cross-platform and is a proud ......[(more)](
Software Development
[]
[An introduction to regular expressions]( - Decoding simple regex features to match complex text patterns.Many data science, analyst, and technology professionals have encountered regular expressions at some point. This esoteric, miniature language is used for matching complex text patterns, and ......[(more)](
Security news and thoughts
[]
[Have You Been 'Pwned' in a Hack Attack? Troy Hunt Can Tell]( - Troy Hunt has collected a trove of 4.8 billion stolen identity records pulled from the darkest corners of the internet -- but he isn't a hacker. Instead, he uses that repository to help ordinary people navigate the growing scourge of the corporate data ......[(more)](
[]
[Hundreds of HP Laptops, Tablets Found with Pre-Installed Keylogger]( - A security researcher has found that hundreds of different models of HP notebooks, tablets and other devices include a keylogger that could track and record every keystroke a user makes. Linked to touchpad drivers made by Synaptics, the keylogger is ......[(more)](
[]
[Hackers hit key ATM network in crime spree that clears $10 million]( - A previously undetected hacker group has netted around $10 million in heists on at least 20 companies, in some cases by targeting the transfer networks banks use to transfer money, ......[(more)](
R Language
[]
[RÂ in the Windows Subsystem for Linux]( - R has been available for Windows since the very beginning, but if you have a Windows machine and want to use R within a Linux ecosystem, that's easy to do with the new Fall Creator's Update (version 1709). If you need access to the gcc toolchain for ......[(more)](
PowerShell
[]
[Install SQL Server 2017 Using PowerShell Desired State Configuration and SqlServerDsc]( - How many times have you clicked through the SQL Server installation interface just clicking the same old buttons, entering the same old information, not giving it much of a second thought? Then the installation finishes and the realization of "I forgot ......[(more)](
PowerPivot/PowerQuery/PowerBI
[]
[Scatter RViz: Power BI R Custom Visual]( - ScatterRViz ScatterRViz is a custom visual for showing three variables in one chart. There is a possibility to zoom in and zoom out on the chart. This custom visual needs 1-     X-axis as the first variable 2-     Y-axis as the second variable 3-     ......[(more)](
[]
[Power BI Custom Visuals Class (Module 81 â Social Network Graph)]( - In this module you will learn how to use the Social Network Graph Custom Visual. The Social Network Graph allows you to visualize relationships between people or items in your data. Module 81 â Social Network Graph Downloads Power BI Custom Visual ......[(more)](
[]
[List.Accumulate Hidden Gem of Power Query List Functions in Power BI]( - There are a number of List transformations available in Power Queryâs graphical interface. However, the number of functions in the graphical interface is very limited. In this post, Iâm going to explain about a function that is really powerful and is ......[(more)](
[]
[The Power BI Gateway; All You Need to Know]( - Power BI is a data analysis tool that connects to many data sources. If the data source for Power BI is located in an on-premises location, then the connection from cloud-based Power BI service, and on-premises located data source should be created with ......[(more)](
[]
[Dynamically change chart axis in Power BI]( - In this video, Patrick builds on a blog post from Scott Senkeresty to dynamically change the axis of your visual within Power BI. This uses a combination of Power Query and DAX. Chris Cook - @Finalyst89 Scott Senkeresty â @ScottSenkeresty Dynamically ......[(more)](
Polybase/HDInsight
[]
[Troubleshooting Failed PolyBase Installation in SQL Server 2017]( - This article shows you how to troubleshoot a failed installation of SQL Server and how to implement a workaround to allow SQL Server 2017âs PolyBase feature to be installed when version 9 of the Java Runtime Environment (JRE) is present. An installation ......[(more)](
Performance Tuning SQL Server
[]
[Is Your Database Overweight?]( - The obesity epidemic is much in the news these days. The list of health issues related to being overweight is long, and admonitions to watch what we eat and to exercise regularly and stay active abound. But itâs not just people that can be affected adversely ......[(more)](
[]
[Query Plan Oddities: Two Identical Missing Indexes]( - As Iâve been building labs for my Mastering Query Tuning class, Iâve been spelunking through data.stackexchange.com. Itâs where anybody can write queries against the Stack Overflow databases, and share them with friends. For example, Daniel Vandersluis ......[(more)](
[]
[Execution Plan Metrics and Units of Measure]( - Have you ever looked at the properties inside an execution plan and wondered what the units of measure were? I know I have. I also get the question pretty frequently about all sorts of properties. What does EstimatedAvailableMemoryGrant display itâs ......[(more)](
Microsoft News
[]
[Microsoft adds more AI-powered updates to Bing, Cortana, Office 365]( - Bing, Cortana and Office 365 are getting more features that Microsoft is categorizing as powered by AI. Here's what's coming. ...[(more)](
[]
[Microsoft Takes Path Less Traveled to Build a Quantum Computer]( - On Monday, the company unveiled a new programming language called Q# â pronounced Q Sharp â and tools that help coders craft software for quantum computers. ...[(more)](
Hardware News
[]
[Corsair Launches 'Worldâs Fastest' DDR4 SODIMM 32GB Memory Kit]( - Corsair announced that its new Vengeance SODIMM DDR4 4,000MHz 32GB (4x8GB) memory kit asâsurprise!â the âworldâs fastest.â These modules arrived just a few short weeks after G.Skill announced that its SODIMM DDR4 modules were the fastest on the planet. ...[(more)](36110.html)
[]
[Volta-Powered GPU Delivers 110 Teraflops of Deep Learning Horsepower to Researchers]( - According to a recent press release, âNVIDIA today introduced TITAN V, the worldâs most powerful GPU for the PC, driven by the worldâs most advanced GPU architecture, NVIDIA Volta. Announced by NVIDIA founder and CEO Jensen Huang at the ......[(more)](
Graph Databases
[]
[Bring clarity to complex data with graph databases on SQL Server 2017]( - SQL Server 2017, in addition to processing relational data, now fully integrates with graph database models, all on the same familiar system. This will bring clarity to the increasing amounts of data businesses generate every day. Whatâs the difference ......[(more)](
DevOps and Continuous Delivery (CI/CD)
[]
[What is database DevOps, and why is it important for DBAs?]( - Iâve had many conversations at conferences where people have asked me about the role of the traditional DBA being phased out. When I ask why they think thatâs the case, thereâs a variety of answers: âThe introduction of the cloud will take care of everything ......[(more)](
Computing in the Cloud (Azure, Google , AWS)
[]
[PaaSÂ and the ever changing role of the DBA]( - Iâve never been a fan of a GUI for DBA work. Give me a hand crafted script or a list of DMVs and Iâm a happy camper. Perfmon is probably my best friend. Itâs always there and happy to tell me the truth. It seldom falters and has helped me get to root ......[(more)](
Career Growth
[]
[Tell Us What You Make: The 2018 Data Professional Salary Survey]( - Not what youâre worth, dear reader: we know your worth cannot possibly be calculated in base-10 numbering systems because youâre just so awesome, but what you make. How many stacks of Paul Whites are you pulling down? A few things to know: Itâs totally ......[(more)](
[]
[BKâs Professional Learning Plans for 2018 #tsql2sday]( - With 2018 coming, Iâve thought about the question, âWhat do I want to be when I grow up?â I ask this question every few years because it helps me develop a plan of attack with respect to learning and opportunities to pursue. As a result, this T-SQL Tuesday ......[(more)](
[]
[T-SQL Tuesday #97 â Learning Goals for 2018]( - This monthâs T-SQL Tuesday is brought to us by Mala Mahadevan. Mala has challenged us to set some goals for our own learning in 2018. This could be learning to improve our social skills, technical skills, or perhaps some other area of our lives. The ......[(more)](
Backup and Recovery
[]
[Installing the âOla Scriptsââ¦quick and easy database maintenance]( - I was recently in a conversation about the best way to go about setting up maintenance (Backups, Integrity Checks, Indexes and stats) for a group of SQL Servers, with minimal hassle, and easy to deploy to new servers. The factors that came into play ......[(more)](
AI/Machine Learning/Cognitive Services
[]
[Machine Learning Services and Result Sets part 3]( - To quickly recap the last couple of posts, the set of data returned by sp_execute_external_script has no column names by default. The column names (and data types) can be defined by using the WITH RESULT SETS options of the EXECUTE statement. But you ......[(more)](
[]
[Accessing AzureML models through SQL Server in-database R services]( - In a previous article I discussed the various methods available in SQL Server 2016 & 2017 to perform in-database analytics. In the article I used a model that was stored directly inside SQL Server to perform predictions. But what if your models are not ......[(more)](
Administration of SQL Server
[]
[SQLÂ SERVER â FIX: SQL Service Does Not Start After Promoting the Machine as Domain Controller]( - One of my blog reader contacted me to check if I can help him via phone to fix a show-stopper issue with SQL Server. I offered him On Demand (55 minutes) and he readily accepted it. Let us learn in this blog post how to fix an error related to domain ......[(more)](
[]
[SQL Server Failed to Open Loopback Connection â What?]( - I could not read my error log on one of my local SQL Servers, when I executed the following code: EXEC sp_readerrorlog I received the below: Msg 22004, Level 16, State 1, Line 2 Failed to open loopback connection. Please see event log for more information. Msg ......[(more)](
[]
[Centennial apps/desktop bridge, SQL Server and error "The data area passed to a system call is too small."]( - The title of the blog may throw someone off a little. After all, SQL Server is not a centennial app and the error message doesn't appear to have anything to do with SQL Server. So please bear with us while the whole scenario is explained. Note: Here ......[(more)](
---------------------------------------------------------------
Administrative
To be removed from this list, please click [here](
Note: This is not the SQLServerCentral.com daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can [change your profile]( or follow the instructions on the daily newsletter.
---------------------------------------------------------------
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. Contact: webmaster@sqlservercentral.com