Job Start Whenever the CPUs Become Idle

 Database Weekly for September 29, 2019 Problems displaying this newsletter? [View online](. [Database Weekly]( The Complete Weekly Roundup of SQL Server News Hand-picked content to sharpen your professional edge Editorial  Celebrate Success In addition to being a history nerd, I can be a bit of a current events junky. Because of this, I read a lot of news. Frankly, the “news” is bad. No, this isn’t a political statement in support of or against any individual or policy. I just mean that a very healthy chunk of the news is almost always very negative. This occurs despite the fact that there are extremely positive things going on in the world all the time. Scientific advances and individuals helping people just because they can, all sorts of things that just about anyone can agree is a net positive, yet they aren’t covered by the news.  Same thing happens at work. Every time you have a failed restore, a unsuccessful deployment, or a failed data load, everyone knows about it. Meetings are scheduled to discuss what happened, who caused it, and, hopefully, a remediation course so it doesn’t happen anymore. There is a non-stop list of all the stuff that is bad. Granted, if we can’t restore our databases, this is something that needs to be fixed, without delay. However, in addition to that failed restore, not discussed was the successful one (or six). A big part of our job as technologists is to prevent bad things from happening, so we can focus a lot of attention there. However, to inspire us to more and better work, I’d argue a good and regular does of positivity is needed. Did your DR process work? Scream that from the mountain tops. WE ROCK! WE DID A GOOD JOB! List out how you saved the company money because your monitoring solution has enabled you to be proactive in disk management rather than reactive to the downtime caused by the lack of the same. Celebrate your successes as loudly, louder, than you trumpet your failures. You’re doing hard work, and doing it well, make darned sure your organization is aware of that fact. Focusing only on the negative aspects of your job (or life on this planet), can make work (and living) a pretty dark and depressing activity. While we have to address and deal with the bad things as they occur, focusing on and celebrating the positive things will make dealing with the negative things easier. Grant Fritchey [Join the debate, and respond to the editorial on the forums](  [Redgate Database Devops]( 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. Vendors/3rd Party Products [Integrating SQL Server Tools into SQL Change Automation Deployments]( Phil Factor shows how to integrate use of SQL Change Automation, SSMS registered servers, SMO, and BCP to automatically build or update a database on all servers in a group. [Learn the fundamentals of Redgate Products]( Redgate invite you to look around their newly refurbished University. If you are new to their tools there are simple, easy to follow courses to get you up and running, and if you are a long-time customer you can check out the recently added courses which take you through some more technical tips, tricks and troubleshooting. .NET Related Articles [Apache Spark for .NET Developers]( You can now write applications in C# or F# that take advantage of Apache Spark. In this article, Edward Elliott walks you through installing everything you need and creating your first Apache Spark app. [Working with React Components]( The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application. AI/Machine Learning/Cognitive Services [Building Machine Learning Models to Solve Practical Problems]( Machine learning is a skill that many data profess... Administration [Dropping Database Users and Logins: How it Can Go So Very Wrong, and How You Can Easily Fix It]( I don't normally drop users and logins in producti... [SQL SERVER – Strange Error Related to Alias]( They immediately paid for Comprehensive Database P... [SQL SERVER – SQL Agent – Job Start Whenever the CPUs Become Idle]( Recently I was asked by the customer of Comprehens... [Query Store Questions: 24HOP follow up](  A couple weeks ago I presented for the 24HOP Su... [Documenting Maintenance Plans]( I'm not a regular user of Maintenance Plans for SQ... [The Ironic DBA—Back to Basics]( Welcome back to The Ironic DBA Files, a series whe... [A Bug With OBJECTPROPERTYEX And Column Store Indexes]( No, Not That Bug There’s a known bug with partit... [Basics of SQL Server Task Automation]( This is an introductory article about automation i... [SQL: Fix – Login failed for user 'NT AUTHORITYANONYMOUS' Azure SQL Database Error 18456]( At one of my customer sites, I recently started ha... [sp_LockDetails – Get Details of all Locks Taken Out Against a Database.]( Be sure to get the latest version of this script f... [Instantaneous Transaction Rollback with SQL 2019]( If you’ve read about the Accelerated Database Re... [Troubleshooting NUMA Node Inbalance Problems]( (Be sure to checkout the FREE SQLpassion Performan... [Redgate Database Devops]( Azure SQL Database [HammerDB for Azure SQL DB]( Bench marking your environment is an important ste... [Azure SQL DB Design Note: Choosing the Right Database Reservation Size]( Azure SQL Database originally started off with ver... Computing in the Cloud (Azure, Google, AWS) [AWS DataSync News – S3 Storage Class Support and Much More]( helps you to move large amounts of data into or ou... Conferences, Classes, Events, and Webinars [Pre-Con in Denver]( As prep for our pre-con at the PASS Summit, Kendra... [DevOps Essentials from Abel Wang and Steve Jones]( Date and time: Thursday October 10 16.00-17.00 BST/ 10.00-11.00 Central - Join Microsoft's DevOps Lead, Abel Wang and Microsoft MVP, Steve Jones to discover what is DevOps and the lessons Microsoft learned from their DevOps transformation. [How SQL Change Automation helps you deliver value faster]( Date and time: Wednesday October 16 16.00-17.00 BST/ 10.00-11.00 Central - Microsoft MVP, Kendra Little will show you how Redgate tools enable you to speed up software delivery with reliable, repeatable processes that remove the database bottleneck. [Successfully Migrate Your Databases to Azure]( Date and time: Wednesday October 2 16.00-17.00 BST/ 10.00-11.00 Central. Join John Sterrett, CEO of Procure SQL, to learn the difference between Azure SQL Database, SQL Managed Instances, Elastic Pools, and SQL Virtual Machines. [SQLSaturday #870 - Memphis 2019]( On Oct 5, 2019, a free day of SQL Server training in Memphis, TN, USA [SQLSaturday #907 - Pittsburgh 2019]( On Oct 5, 2019, a free day of SQL Server training in Pittsburgh, PA, USA. [SQLSaturday #912 - New York City 2019]( On Oct 5, 2019, a free day of SQL Server training in New York City, USA [SQLSaturday #915 - Bucuresti 2019]( Come for a free day of learning in Bucuresti, Romania on October 5, 2019. DMO/SMO/Powershell [Quick Blog: Run PowerShell Core from the PowerShell Integrated Console]( Run whichever version of PowerShell Core from the ... Data Mining / Data Analysis [Why intelligent dashboards do not always lead to intelligent decisions](  Data Privacy, Compliance, and GDPR [Microsoft's new 'Data Dignity' team could help users control their personal data]( Microsoft is staffing up a new Data Dignity team i... [Google wins case as court rules “right to be forgotten” is EU-only]( Europeans have the right to be forgotten, but only... [AT&T tells court: Customers can’t sue over sale of phone location data]( AT&T files motion to compel arbitration in cas... Data Science [Data Science in 90 Seconds: Choosing a Machine Learning Approach]( Click to learn more about video blogger Laura Kah... [Data Science Pioneers: Conquering the next frontier, a documentary investigating the future of data science]( This is a keynote from the Strata Data Conference ... Database Design, Theory and Development [Data Sublanguage Part 2: Data vs. Retrieval Sublanguage]( In Part 1 we showed that Codd intended in 1969 to ... DevOps and Continuous Delivery (CI/CD) [Increased Database Security: Another Reason to Adopt DevOps]( The tooling necessary to incorporate DevOps practi... DocumentDB/Key-Value/Graph/other NoSQL Databases [Simple Graph Queries]( In this post we saw how to create some graph table... [Graph – Shortest Path]( ‘Shortest path’ is by far the most feature of ... ETL/SSIS/Azure Data Factory/Biml [Manage SSIS Catalog Size]( A few days ago, I (along with some smart people) w... [SSIS Term Extraction]( Tim Mitchell takes us through term extraction in S... [Using the SSIS Term Extraction for Data Exploration]( Data exploration is an essential piece of any new ... General [Handling dates and times in R: a free online course]( If you ever need to work with data involving dates... [Generate Random List of Numbers in Power BI Dataset Using Power Query]( I’ve been asked from one of my friends who were ... Hardware [SSDs are on track to get bigger and cheaper thanks to PLC technology]( Storage of five bits in every NAND cell is coming,... [HP’s E344c: A 34-Inch Curved Ultra-Wide Productivity Monitor]( Having launched a variety of curved ultrawide disp... [AMD’s Ryzen 9 3950X, Threadripper on hold until November]( The delay on Ryzen 9 3950X's launch makes sense, g... [ADATA Releases the XPG SX8100 SSD: Make It Fast & Hold the Bling]( While many gaming-branded components come adorned ... Microsoft News [Microsoft says Windows 10 1903 is officially 'ready for broad deployment']( Microsoft has designated Windows 10 1903 ready for... [Microsoft: Windows 10 now on more than 900 million devices]( Windows 10 is finally closing in on the 1 billion ... Performance Tuning SQL Server [Silly Execution Plan Warnings]( First Time, Long Time I’ve written about all of ... [Nested Loops Joins and Performance Spools]( Paul White on performance spools, and how they can... [Why Does My Serial Query Have Parallel Waits?]( Harkening In dramatic fashion, I’m revisiting so... PowerPivot/PowerQuery/PowerBI [Power BI for Communication and Marketing]( We often focus on deep analysis and insights gener... [A comprehensive guide to Power BI performance tuning]( While it’s easy to make reports in Power BI, it ... [Power BI – Fixing Dates from Sharepoint Lists (converting UTC Dates to Local Dates)]( Originally posted on: ... [Query Dependency in Power Query / Power BI Desktop]( Patrick shows how you can see query dependencies w... [Using Custom Format Strings in Power BI Desktop]( Patrick walks you through how to use custom format... [Power BI Paginated, relationships and more… (Roundup | September 23, 2019)]( Thanks for watching this week's Power BI news roun... PowerShell [PowerShell and Secure Strings]( Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server. Product Reviews and Articles [Redgate SQL Toolbelt over Microsoft SSDT: My Biased Opinion]( Back in the article How Redgate Helped Define our ... [Where SQL Server monitoring fits into your tech stack]( This article explains the basic components of a te... Product Upgrades and Releases [Database Health Monitor – September Release]( Earlier today I had the opportunity to release the... [Updated First Responder Kit and Consultant Toolkit for September 2019]( This month’s release has a lot of new feature go... [Now Available – EC2 Instances (G4) with NVIDIA T4 Tensor Core GPUs]( The NVIDIA-powered G4 instances that I promised yo... Python [Deploying the Obscure Python Script: Neuro-Styling of Portrait Pictures]( Click to learn more about author Rosaria Silipo. C... [Videos: Building computer vision models with Python and Deep Learning]( This series of videos spotlights a very powerful A... [Linear Regression using Python (Basics – 2)]( Are you interested in guest posting? Publish at Da... [Linear Regression using Python (Basics)]( Are you interested in guest posting? Publish at Da... SQL Server Security and Auditing [Restarting SQL Server after adding a new SQL login]( At a project, we asked if we could get a SQL Serve... Security News and Issues [DoorDash hack spills loads of data for 4.9 million people]( Intruders got access in May. DoorDash only found o... [Unpatchable bug in millions of iOS devices exploited, developer claims]( "Checkm8" exploit works on devices from iPhone 4s ... [IE zero-day under active attack gets emergency patch](  [Medicine show: Crown Sterling demos 256-bit RSA key-cracking at private event]( Demo of crypto-cracking algorithm fails to convinc... [France Outlines Its Approach to Cyberwar]( In a document published earlier this month (in Fre... Software Development [Advanced error handling techniques]( This post describes some (more) advanced error han... T-SQL [Be Careful When You Alter Indexed Views]( Yo, Is That Mary? [SQL: Maintaining Online Website Data during Full Data Refreshes – Part 2 Code Example]( I had a number of responses to my blog post about ... [SQL SERVER – Table Variable or Temp Table – Performance Comparison]( In this blog post, we will talk about Performance ... [Where is Table Variable Created? – Interview Question of the Week #243]( Question: Where is Table Variable Created? Answer:... [T-SQL 101: #36 Exact whole numbers in SQL Server]( I previously mentioned that SQL Server supports a ... [SQL SERVER – Table Variables or Temp Tables – Performance Comparison – SELECT]( Today we are going to discuss the performance comp... [Debugging techniques (focusing on T-SQL)]( tl;dr; Add PRINT and/or SELECT statements. Comment... [Database Fundamentals #22: Using the Join Operator, CROSS JOIN]( While the CROSS JOIN is not used much, and, depend... The Lighter Side [Pedaling with extra power: A look at Trek’s new electric bike]( Ars takes Trek's latest electric bike for a spin a... Tools for Development [Automate Your SQL Notebooks with Two New Options]( There are two new options for automating your SQL ... Virtualization and Containers/Kubernetes [The Next Evolution of Cloud Management: Container Management]( Click to learn more about author Jay Chapel. As we...  [RSS Feed]( 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. 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 follow the instructions on the daily newsletter. ©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved. webmaster@sqlservercentral.com  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -