Capturing DBCC CHECKDB Output (DBW 2020-05-09)

 Database Weekly for May 9, 2020 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  Focus On The Positive We are living in some interesting times indeed. It requires no kind of stretch at all to find any number of downer, negative, even alarmist new stories. That’s because, in fact, there are some quite negative things occurring. If you’re at all struggling to cope with what’s happening, there’s a simple formula: focus on the positive. See, our brains are hardwired through thousands of years of living a hand-to-mouth existence, fighting against predators who, without our over-sized heads and opposable thumbs, frankly, outclassed us in every way, to focus on the negative. It was far more important to spot that saber-tooth tiger stalking us through the bushes than to notice that the bushes had some tasty berries. So we easily and readily take in all the bad things in our environment in order to prepare us to stay alive. It’s a fundamental survival mechanism. Yet. The overwhelming majority of us are not living on the plains where we must spot that tiger. [According to the UN]( we’re living in a golden age, with less hunger, more education, and longer lives, than ever in all of human history (NOTE: not a perfect world, just a better one). But we don’t feel that way do we? We feel like every day is worse than before because of two fundamental facts. First, we naturally [focus on the negative](. Second, the people vying for our attention through all the various screens around us, know that a negative headline will get more attention than a positive one. The classic “if it bleeds, it leads” is [at play all the time](. So we are saturated with negative messages and negative content and our brains, through evolution itself, lap it up. It’s no wonder so many are depressed. Instead, focus on the positive. Find the good stories around you. Acknowledge the success of your friends and co-workers. Spot as many good and positive things as you possibly can and build a habit of keeping them in mind. There are numerous [psychological studies]( supporting this attitude as a way to keep your brain and your mental health in a better place. Evolution will ensure that you still spot that tiger. It’s on you to see the berries on the bush so that you can come around and pick them tomorrow when the tiger is gone. I know that people are going to read this and go, pshaw! You’re just a Pollyanna, Grant. However, follow the links. Read what the science says. [Listen to this podcast](. I may be crazy, but that doesn’t mean I’m wrong. Take some time. Focus on the positive. You’ll feel better for it. You’ll do better with it. 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 [How to Add a Filter to an Existing SQL Change Automation Project]( Kendra Little demonstrates how to create a SQL Compare filter file and save it to a SQL Change Automation project folder, so that it will be used automatically during development. [Adding Reports Users to SQL Monitor]( SQL Monitor 10.0.5 now supports a user role called "Reports user". A user added to this role, by an administrator, will be able to 'self-serve' SQL Monitor reports but won't be able to configure any other aspect of the monitoring service. Jeremiah Peschka explains how it works. [Getting Started with SQL Data Masker: I Need to Mask some Columns]( Grant Fritchey explains the core rules and features of Data Masker, and how you go about using them to mask columns, so that when the data is used outside the production system it could not identify an individual or reveal sensitive information. Administration [Capturing DBCC CHECKDB Output]( If you haven’t experienced database corruption i... [SQL Server 2019 Disappointment: sp_estimate_data_compression_savings]( Missed It The First Time This is documented, but I know a lot of people are allergic to documentation, whether it’s writing or reading. In SQL Server 2019: Exciting stuff: In memory... [TSQL To List Recent Backups]( Doing some recent investigation to find out why backups where not showing up where they were expected to be I put together this script to help track down recent... Azure CosmosDB [Searching Azure Cosmos DB with a polygon using ST_INTERSECTS or ST_WITHIN]( I want to continue to develop our new map application for Azure Cosmos DB. So far, we can run a custom spatial query in Cosmos DB and display the results on a map. I want my users to create a polygon on map and search for data under this polygon. [Cosmos DB Profiler]( The very first product of Hibernating Rhinos was a profiler for NHibernate, to allow you to figure out exactly what is going between your database and application. Now I’m... Azure Synapse (SQL Data Warehouse and Data Lake) [Query Acceleration for ADLS]( Just announced is Query Acceleration for Azure Data Lake Storage Gen2 (ADLS) as well as Blob Storage. This is a new capability for ADLS that enables applications and analytics... The... Career Growth and Certifications [Opinion: On forums, don't do DBTs (drive-by trashings)]( I hear about frequent drive-by shootings in some c... Computing in the Cloud (Azure, Google, AWS) [Microsoft to add new cloud regions in Italy, New Zealand and Poland]( In the span of a week, Microsoft announced plans t... [90%+ price reduction for AWS IoT Jobs, Globally Available]( I have good news for AWS customers using the AWS I... [Tracking Costs in Microsoft Azure via Tags]( Moving to public cloud such as Azure, AWS or even private cloud services you need to be tracking costs and seeing if you are “effective”. What is the best... The... [Using the Clipboard in Azure Bastion]( When I’m RPD’ed into a server, I copy and paste things from my desktop to the server all the time. Be in code that I’ve got saved in a... Conferences, Classes, Events, and Webinars [TSQL for Beginners–#RGCommunityCircle]( As a part of the Redgate Community Circle, giving ... [Free Upcoming Live Classes]( So, we’re still under lockdown, huh? I see. Well, I guess I’ve got no choice but to keep y’all busy. Let’s get together for some free live classes: May... [Extending SQL Monitor using Extended Events]( Extended Events open up the whole world of special metrics and alerting available to you within SQL Monitor. Join Microsoft MVP Grant Fritchey in this webinar to discover how to extend what’s possible. Can't join for the live event? Register to receive the recording. Date and time: Wednesday May 13, 10-11am CDT / 4-5pm BST [How SQL Clone 4.4 enables fast onboarding for Database DevOps]( On Wednesday May 20, 10-11am CDT / 4-5pm BST join Microsoft MVP Kendra Little to see a demo of the latest innovations integrating Clone technology into DevOps tooling, enabling the fast roll out of Database DevOps across your organization. If you can't make it then be sure to register to receive the recording. [Announcing Two New Parameter Sniffing Classes]( During the quarantine downtime, I’m working on a couple of new classes that I think you’re gonna like. Both of them are 100% demos, no slides (other than introductions... [Free SQL Server Reporting Services Class]( As part of the Redgate Community Cares project, I’m teaching a seven-week class online class, “Introduction to SSRS”.  This class is perfect for people who need to learn SSRS... [EightKB – Schedule published]( Today we announced the schedule for EightKB EightKB was setup by Anthony Nocentino (b|t), Mark Wilkinson (b|t), and myself as we wanted to put on an event that delved... The... DMO/SMO/Powershell [Day 3 – Backup-DbaDatabase Filenames and paths – 31 days of dbatools backup and restores]( Day 3 – Backup-DbaDatabase Filenames and paths Yesterday we looked at the basics of using the Backup-DbaDatabase function. In all of those examples the backup files were going to... [Day 4 – Backup Encryption with Backup-DbaDatabase – 31 days of dbatools backup and restores]( Day 4 – Backup Encryption with Backup-DbaDatabase Now, we all take our db security very seriously (or at least I hope we do?). But a lot of people don’t... Data Mining / Data Analysis [Retail forecasting through a pandemic]( [Jessica Curtis and Adam Hillman, both Forecasting Advisors at SAS, were co-authors of this post] The world has been dramatically impacted by the recent COVID-19 pandemic. Many of us... Data Privacy, Compliance, and GDPR [Used Tesla Components Contain Personal Information]( Used Tesla components, sold on eBay, still contain personal information, even after a factory reset. This is a decades-old problem. It's a problem with used hard drives. It's a... Data Visualisation [picking the right colors]( In all of our workshops (including our virtual ones), we include time for free-form questions and answers. One topic that often comes up is how to use color effectively.... [#SWDchallenge: think like a designer](  ... ETL/SSIS/Azure Data Factory/Biml [Using Logic Apps in a Data Factory Execution Framework – Part 1]( Data Factory allows parameterization in many parts... [Azure Data Factory (ADF) Parent Activities don’t trigger ON ERROR OUTPUT when Child Activities Error… What happens?]( So that title is a big question that a client of ours came across that required some additional investigation… What does happen and how do we get around it?... [Deleting packages from SSIS Catalog]( I was fortunate to attend a training on SSIS by my good friend and SSIS expert Andy Leonard(b|t). We already use the tool for ETL purposes where I work... The... HA/DR/Always On/Clustering [Replication latency when an Availability Group replica is offline]( Assume you have configured a transactional replica... Hardware [Microsoft has 2 New Surface Docks, Surface Headphones Updated]( There are two new docks from the Surface team, one is an update to the existing dock and there is also a new “Travel” hub as well. The post Microsoft... MDX/DAX [Using USERELATIONSHIP in DAX]( This article shows how to use the USERELATIONSHIP ... Microsoft News [Microsoft makes new GitHub collaboration tools available to testers]( GitHub Codespaces, Discussions, code scanning and secret scanning are available in beta. And Private Instances are coming soon. Performance Tuning SQL Server [No, You Can’t Calculate the Tipping Point with Simple Percentages.]( This morning, Greg Gonzalez (who I respect) posted about visualizing the tipping point with Plan Explorer (a product I respect), and he wrote: The tipping point is the threshold... [Blocking with OBJECT_NAME()]( As a DBA, you probably use the OBJECT_NAME() funct... PowerPivot/PowerQuery/PowerBI [Power Query Formatter]( If you’ve ever used DAX Formatter to format your DAX code and wondered why there isn’t an equivalent for Power Query/M, then wonder no more: the nice people at... [Tips for a Successful Power BI Report Server Implementation]( Power BI Report Server (PBIRS) is a superset of SQ... [Fixing incorrect date formats in Power BI Report Server when using Chrome or Firefox]( Originally posted on: ... [Power BI Gets Personal: Easy Data Exploration for Any Viewer]( Visual personalization has arrived in Power BI, and it is a significant feature that expands viewers’ data exploration capabilities. [Calling The Power BI Export API From Power Automate, Part 3: Creating An Alerting Solution]( In my last two posts (see here and here) I showed you how you can call the new endpoints in the Power BI REST API for exporting a report.... Product Reviews and Articles [Pitfalls with SQL rollbacks and automated database deployments]( While it’s possible to perform SQL rollbacks to revert database changes, the question is, should you? Rolling back a database change isn’t as straightforward as rolling back a code... Product Upgrades and Releases [Announcing mssql-cli is now generally available on macOS and Linux]( We are excited to announce that mssql-cli is now generally available on macOS and Linux. [[Video] Updated First Responder Kit and Consultant Toolkit for May 2020]( We have quarantined all of the bugs. Many of the bugs. Okay, 7 of the bugs. Hey, we actually added more improvements than we fixed bugs this month! My... R Language [Using R to Analyze & Evaluate Survey Data – Part 1]( Are you interested in guest posting? Publish at DataScience+ via your RStudio editor. Category Advanced Modeling Tags Best R Packages Data Visualisation ggplot2 R Programming Survey data remains an integral part of organizational science and rightfully... SQL Server Security and Auditing [Could not obtain information about Windows NT group/user]( This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, ... Continue reading The post Could not obtain information about... Security News and Issues [The CISO’s Guide to Remote Working]( Click here to learn more about Anas Baig. The global crisis has forced employees from all over the world to work from home. Since employees are now confined to... [Microsoft Announces Combined Multifactor Authentication and Password Reset Registration]( Make it easier for Office 365 users to register for multifactor authentication and self-service password reset with Azure AD combined registration. The post Microsoft Announces Combined Multifactor Authentication and Password... T-SQL [Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ]( SQL Server supports transforming flat tabular SQL result sets into hierarchical structures by convention using the convenient FOR XML or FOR JSON syntaxes. This is really convenient and less... [SDU Tools: Extracting initials from a name in SQL Server T-SQL]( I recently came across a requirement to extract someone's initials from within their name. That was a new one for me, so we added a new function into our... [Tackling Imperial and US Customary Measurements in Databases]( The old measurements of length, area, volume and weight in the UK and the States refuse to die. They are known as the Imperial and US customary measurement systems... [Negative identity values don’t suck]( A quick(er) post this week, in response to Greg Low’s blog post from a few weeks ago titled “Don’t start identity columns or sequences with large negative values.” Greg... The... [T-SQL 101: #68 Current date and time in SQL Server T-SQL with SYSDATETIME and SYSDATETIMEOFFSET]( It's really common to need to know the current date and time in T-SQL code. Ever since the beginning of the SQL Server product, we've had a function called... [Database Fundamentals #24: More Filtering Data]( In this Database Fundamentals post we continue discussing the functionality of the WHERE clause. We started with the basics of the logic using things like AND, OR and LIKE... The... Tech News [NYT defeats Ajit Pai as judge orders FCC to provide net neutrality records]( FCC must reveal IP addresses and user-agent headers of net neutrality commenters. The Lighter Side [Bored highschoolers at home? Have them design a race car for the Moon]( The plan is to take two 5kg robot race cars onboar... [Isn’t the technical Community great?!!]( With everything that’s been going on in the world recently and all events being cancelled or postponed you might mistakenly think that people’s ability to learn and stay in... [Starter/Good/Great/Bananas Live Streaming Setups]( For the next year or two, we’re going to be learning and sharing online rather than in-person. I wanna look and sound as good as my budget (and my... [Daily Coping 4 May 2020]( I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each... The... Tools for Development [Best SQL Tools for Database Developers and Administrators]( Total: 1 Average: 5For a SQL database developer, i... [Executing PoSh line by line in VS Code]( Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve had to relearn this trick multiple times,... The... Virtualization and Containers/Kubernetes [Blog post about patching docker]( Over at � I blogged about patching my local copy of SQL Server, which is running in docker... [Getting Started with Docker in Windows]( The advent of containers within the computing worl... [Weird Docker Desktop Issues – Unable to Create Hyper-V VM]( I was setting up my new machine the other day and one of the first things I did was get Docker Desktop. I grabbed this and enabled Hyper-V at... The... XML, XPATH and XQUERY [Storing XML data in SQL Server]( Total: 1 Average: 4When working on the release of dbForge Transaction Log, among other tasks, our team had to puzzle out how to properly store typed XML data. To...  [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  - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -