| The Complete Weekly Roundup of SQL Server News | Hand-picked content to sharpen your professional edge |
| 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 |
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. |
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. |
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. |
If you haven’t experienced database corruption i... |
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... |
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... |
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. |
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) |
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 |
I hear about frequent drive-by shootings in some c... |
Computing in the Cloud (Azure, Google, AWS) |
In the span of a week, Microsoft announced plans t... |
I have good news for AWS customers using the AWS I... |
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... |
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 |
As a part of the Redgate Community Circle, giving ... |
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... |
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 |
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. |
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... |
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... |
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... |
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 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 |
[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, 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... |
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.... |
ETL/SSIS/Azure Data Factory/Biml |
Data Factory allows parameterization in many parts... |
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?... |
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 |
Assume you have configured a transactional replica... |
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... |
This article shows how to use the USERELATIONSHIP ... |
GitHub Codespaces, Discussions, code scanning and secret scanning are available in beta. And Private Instances are coming soon. |
Performance Tuning SQL Server |
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... |
As a DBA, you probably use the OBJECT_NAME() funct... |
PowerPivot/PowerQuery/PowerBI |
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... |
Power BI Report Server (PBIRS) is a superset of SQ... |
Originally posted on: http://staffofgeeks.net/darr... |
Visual personalization has arrived in Power BI, and it is a significant feature that expands viewers’ data exploration capabilities. |
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 |
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 |
We are excited to announce that mssql-cli is now generally available on macOS and Linux. |
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... |
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 |
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... |
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... |
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... |
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... |
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... |
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... |
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... |
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... |
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... |
FCC must reveal IP addresses and user-agent headers of net neutrality commenters. |
The plan is to take two 5kg robot race cars onboar... |
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... |
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... |
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... |
Total: 1 Average: 5For a SQL database developer, i... |
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 |
Over at http://blogs.lobsterpot.com.au/2020/05/08/patching-sql-in-docker/ I blogged about patching my local copy of SQL Server, which is running in docker... |
The advent of containers within the computing worl... |
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... |
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... |
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. |
|
|