Make the most of your PASS Summit Evenings (Database Weekly 2019-10-26)

 Database Weekly for October 27, 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  Become a Technological Historian I’m a huge fan of history. I think I like it most because there is romance to it. The stories, all true, can be as amazing and wonderful as any fiction (minus light sabers, talking lions, and space battles). However, reading history also exposes you to facts, lots of horrifying facts about the choices made by our ancestors, evil and good those choices may be. As a technologist, history also matters. It’s very easy to look at a given situation, spot the poor technology choices that were made to arrive at that situation, and announce the general stupidity of your technological forebears. However, like so much of the world outside our computers, just because we can easily spot the bad decisions made by those who came before and can easily announce what should have been done under our, more enlightened and benevolent rule, making changes to the existing situation is actually quite difficult. A more thorough understanding of exactly why those who came before us made the choices they did actually can help to make the necessary changes to improve things. Ignoring the history of how we got to where we are, why the choices were made, what lead to the decisions that arrived at our current position, can actually make it harder to improve the situation, let alone sell others on the idea that we need to improve the situation. So, be a technological historian. Understand why the compromises were made on the technological debt you’re currently dealing with. Yes, the old decisions may have been stupid or ill-informed, but there may also have been very good reasons why those decisions were made at the time. A good understanding of why things were done will help you to better improve them. Also, for what it’s worth, documenting why you’re making the choices you make could help some future historian understand why you made, what may be in the future, a really stupid choice. Let’s be fair, you’re just as likely to make a bad choice as those who came before you based on the knowledge and understanding you have today, that will prove to be wrong or inadequate in the future. Grant Fritchey [Join the debate, and respond to the 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. Vendors/3rd Party Products [Why you should include the database in your 2020 IT strategy]( With 2020 just around the corner, organizations of all shapes and sizes are considering what the next 12 months plans should look like. Here is what you need to know about including the database in your plans. [Make SQL Server monitoring part of your deployment process for 2020]( As we approach 2020, demand for more frequent deployments continues to rise. With this, management of SQL Server availability needs to evolve. Now’s the time to consider how SQL Server monitoring could improve your deployment performance. In this whitepaper, learn how SQL Server monitoring can help your development and DBA teams work together to remove bottlenecks and enable faster, more reliable deployments. AI/Machine Learning/Cognitive Services [[Build 2019] Machine learning with ML.Net]( As i updated you earlier, ML.NET is a free, cross-... Administration [SQL SERVER – Upgrade Rule Failure Error: No Custom Security Extensions]( Let us learn about upgrade the rule failure error ... [Database Restoration and the Plan Cache]( Andy Mallon has some tests for us: If you restore ... [Auto-Deleting SQL Agent Jobs]( Dave Bland takes us through SQL Agent job auto-del... [Want to be more comfortable with the Extended Events Viewer?]( I’ll admit, I’m a lot more comfortable with tr... [SQL: Accessing SQL Server Express localdb from another computer]( I saw a discussion on a forum the other day about ... [SQL SERVER – Upgrade Error: The Specified Service Does Not Exist as an Installed Service]( During an upgrade, as soon as they enter the produ... Azure CosmosDB [Ordering in Cosmos DB Queries]( Hasan Savran shows how you can order data in Cosmo... [Redgate University]( Azure SQL Database [Azure SQL Database Failover – Grace Period?]( The Azure SQL Database service triggers an automat... Azure SQL Managed Instance [SQL Server database consolidation in Azure SQL Database Managed Instance]( Overview With the introduction of Azure SQL Databa... Career Growth and Certifications [11 things I wish I could tell myself as a Junior Software Developer – Michael’s Coding Spot]( I’d like to tell my junior self that in 10 years... [Invest in Yourself Stop Making Excuses]( Bob Pusateri (B|T) tweeted a quote image that real... Conferences, Classes, Events, and Webinars [SQLSaturday #916 - Bangladesh 2019]( SQL Saturday comes to Bangladesh on Nov 16. [How to make your 2020 monitoring strategy a success]( Wednesday November 20 16.00-17.00 GMT/ 10.00-11.00 Central - Are you ready for growth in 2020? Join Tony Maddonna, Microsoft Platform Lead & SQL Server Enterprise Architect at BMW Manufacturing and Redgate's Arneh Eskandari to discover how to prepare for successful estate growth in 2020 [What we learnt at PASS Summit]( On Wednesday November 13 16.00-17.00 GMT/ 10.00-11.00 Central PASS President Grant Fritchey is joined by fellow Microsoft MVPs Kendra Little, Steve Jones and Kathi Kellenberger to discuss their highlights and learnings from PASS Summit 2018, the largest Microsoft Data Platform conference. [SQLSaturday #920 - Oregon 2019]( SQL Saturday comes to Oregon on Nov 2 [PowerShell at #SQLSatOregon with @DBAduck]( Mastery Session – Leveling Up with PowerShell fo... [SQLSaturday Orlando 2019 Summary]( Our 13th SQLSaturday is done. Some quick notes abo... DMO/SMO/Powershell [#PowershellBasics: Multiple run spaces in ISE]( As you know from the last few posts, I’m in a cl... [Arrays in PowerShell–#SQLNewBlogger]( Another post for me that is simple and hopefully s... [#PowershellBasics: Get-Help -Online]( One of the other things I learned from the Powersh... Data Privacy, Compliance, and GDPR [Protecting Data Privacy in the Era of Digital Trading]( Click to learn more about author Samuel Bocetta. T... DevOps and Continuous Delivery (CI/CD) [Introduction to DevOps: Database Delivery]( Before including the database in your DevOps pipeline, you’ll need to decide if you are going to use a state-based or migrations-based approach. In this article, Robert Sheldon explains the difference between them and discusses the benefits of each. DocumentDB/Key-Value/Graph/other NoSQL Databases [More Genealogy with SQL Graph]( Mala Mahadevan continues a series on genealogy wit... ETL/SSIS/Azure Data Factory/Biml [SSIS Scaleout: Cannot open certificate store on the machine]( When attempting to connect a worker node to the cu... HA/DR/Always On/Clustering [“Basic” Availability Groups – Some Rumors Persist]( The post “Basic” Availability Groups – Some ... [Read-only Replica -AG]( Read only replica is a great concept where we can ... [Finding an Availability Group’s Primary Node]( David Fowler shows how you can find the primary no... [MSDTC Best Practices with an Availability Group]( In this article we are going to look at some guide... [SQL Always On Availability Groups: Computer Objects]( Total: 0 Average: 0SQL Server Always On Availabili... [SQL SERVER – Log Shipping Error: Only Members of the Sysadmin Fixed Server Role Can Perform This Operation]( They have observed that Log Shipping Copy and Log ... [What the heck is Accelerated Database Recovery?]( Last week, I wrote about the SQL Server Version St... Hardware [Micron Pulls No Punches, Claims 'World’s Fastest SSD']( eWEEK NEWS AND PRODUCT ANALYSIS: All in a day's wo... [Glenn’s Tech Insights For October 23, 2019]( (Glenn’s Tech Insights… used to be part of our... [Team Group Quietly Launches 32 GB DDR4 Memory Modules]( Team Group has quietly added 32 GB unbuffered DDR4... [The Microsoft Surface Laptop 3 (15-Inch) Review: AMD Ryzen Surface Edition]( This year at Microsoft’s somewhat annual Surface... [Details About 3rd Generation Ryzen Threadripper Appear: 24 and 32 Cores, Up to 280 W]( AMD has already officially confirmed plans to laun... MDX/DAX [Analyzing DISTINCTCOUNT performance in DAX]( This article describes how to analyze the performa... Microsoft News [Microsoft wins $10 billion U.S. Department of Defense JEDI cloud contract]( Microsoft has emerged as the winner of the estimat... [Microsoft beat expectations with strong Windows revenue, but Xbox had a rough quarter]( Surface didn't post good numbers, but that could c... [Microsoft’s Cloud Pushes Revenue Higher, Office Passes 200 Million Subscribers]( Microsoft has reported it's Q1 FY earnings with Of... [Microsoft to enable end users to buy Power Platform licenses without administrative approval]( Microsoft is planning to roll out a major change i... Performance Tuning SQL Server [SQL SERVER – Identifying Query Generating Malicious Wait Type]( In this blog post, we will learn about how to fix ... [15 Reasons Your Query Was Fast Yesterday, But Slow Today]( In rough order of how frequently I see ’em: Ther... [How to Think Like the SQL Server Engine: What’s the Tipping Point?]( In our last episode, I’d expanded our query to i... [Isolation Level Locking]( Different Engines I seem to have gotten quite a fe... [How to Think Like the SQL Server Engine: What’s a Key Lookup?]( In our last couple of queries, we’ve been using ... [Every Execution Plan Is An Estimated Plan]( I consider myself to be the most responsible for m... [How to Think Like the SQL Server Engine: So Index Seeks are Great, Right?]( In our last episode, we added a nonclustered index... PowerPivot/PowerQuery/PowerBI [Remove CONFUSION in your Power BI report with this little feature]( Patrick shows you a little known Power BI feature ... [Refresh Power BI Dataset using Logic Apps]( A recent blog on the Power BI website announced th... [One little change to improve Power BI slicer performance (BANANAS!!!)]( Patrick shows how you can make one little change t... [Introduction To M In Power Query And Power BI]( Since last week’s post proved very popular (it t... [Worst pie chart ever in Power BI & swords (Roundup | October 21, 2019)]( Thanks for watching this week's Power BI news roun... Product Reviews and Articles [Unwrapping, Unboxing and Installing SQL Clone]( If you are evaluating a tool such as a text editor... Product Upgrades and Releases [Updated First Responder Kit and Consultant Toolkit for October 2019]( This is a pretty doggone big release. There are a ... Reporting Services [SDU Tools: List user access to Reporting Services]( Continuing my recent theme of running queries agai... SQL Server Security and Auditing [Dynamic Data Masking in SQL Server for beginners]( Total: 0 Average: 0The article introduces the basi... [Sharing: Feature Restrictions in SQL Server 2019 – a warning]( Solomon Rutzky posted some thoughts on the new “... Security News and Issues [Johannesburg’s network shut down after second attack in 3 months]( Attackers claim to have full control of network an... [Protecting Your Data At Conferences]( In less than two weeks, we will mark the start of ... [Report: Microsoft’s new Secured-core PC initiative]( Secured-core extends the root of trust past the bo... [NordVPN Breached]( There was a successful attack against NordVPN: Bas... [Passwords = A Good Thing]( Those my friends are, in my opinion, one of the si... [Calculating the Benefits of the Advanced Encryption Standard]( NIST has completed a study -- it was published las... [Google says a fix for Pixel 4 face unlock is “months” away]( Google says to use the "lockdown" feature to stop ... Software Development [Accessibility, the future, and why Domino’s matters]( Is the Web subject to the ADA? "Of course," says c... [Adding a License to GitHub]( I’ve rarely thought about licensing my code, but... T-SQL [What Does PERCENTILE_CONT Do?]( In this article, Kathi Kellenberger takes on a logic puzzle in trying to understand how the windowing function, PERCENTILE_CONT, works [SQL SERVER – Group By Orders Data by Columns Ascending]( The question was about Group By Orders Data by Col... [Cursor : Loop Tables]( Cursor to loop tables. I use this pattern a lot in... [Analytic Functions in SQL Server]( Total: 0 Average: 0Aggregate and Analytic function... [SQL Server Stored Procedures vs Functions vs Views]( Watch this week’s episode on YouTube. SQL Server... [Retrieve TOP 10 Rows Without Using TOP or LIMIT? – Interview Question of the Week #247]( Question: Retrieve TOP 10 Rows Without Using TOP o... [T-SQL 101: #40 String data types in SQL Server]( You'll notice when we discuss strings that there a... The Lighter Side [Make the most of your PASS Summit Evenings]( At this year’s PASS Summit, I’ll only be aroun... [Two women completed a seven-hour spacewalk on Friday]( "You know, for us, this is really just us doing ou... Tools for Development [Undercover TV Podcast – Scripting Options in SSMS]( In this episode of the podcast, Adrian looks at th... Virtualization and Containers/Kubernetes [Using the GitHub Package Registry to store container images]( The GitHub Package Registry is available for beta ...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -