Good Morning!

Good Morning!

Every day I’ve been at work since March 27^th, I’ve posted a “Good morning” tweet. In every one, I tried to provide a piece of positivity. A little something to help people at the start of the day (yeah, I know, time zones). They run the gamut from “Let’s be kind” to explanations of Chesterton’s Fence.

Why?

First of all, why would anyone listen to me? Honestly, I don’t know. I just thought it might help. I’m certainly no one special. I don’t hold Tony Robbins seminars or anything. I’m just some guy on the internet.

Being a more than slightly broken human, I’ve studied quite a bit on how to be a little less broken. I recognize that my own shortcomings have hurt people around me and sometimes limited my ability to do well. So, in the same way that I try to teach others about technology, partly based on the errors I’ve made, I try to help others be positive and find that inner fire to get things done.

That’s it. I’m just trying to, in my own small way, pitch in a little and help out.

My suggestion to you: do the same. Helping others is a reward in itself. However, helping others brings with it positive feelings that can help lead you to a healthier and happier place in general. Where and how you help is entirely up to you. I do however encourage it. Get engaged somewhere and pitch in. You’ll be doing good in the world, and you’ll be lifting yourself up at the same time. Neither of those things can be bad.

Grant Fritchey

Join the debate, and respond to the editorial on the forums

SQL Multi Script can easily be persuaded to run queries at the server level rather than the database level. It is also able to combine results from many databases even if the results aren't identical but have some different columns. Phil Factor demonstrates how this works, when collecting a set of performance counters from all databases on a distribution list of servers.

SQL Multi Script does one thing and does it well: it will run whatever script or scripts you select, on a list of databases, and collate all the results neatly. However, it has a surprising number of uses. Phil Factor explains how it works and then uses it to search 100 databases, for occurrences of a string, in about 7 seconds.

Phil Factor explains how to use SQL Prompt, or SQL Change Automation, to detect use of deprecated SQL Server syntax, during development, and Dynamic Management Views and Extended Events to track its use on working databases.

There are a number of knobs and switches that are available to database administrators that can be used to enable better performance.  There are three options in particular that... The...

SQL ConstantCare® analyzed over 3,000 of your SQL Servers this month. Here are the things we check for and the number of servers where we found this problem this month:...

The ability to use a parameter file (configurationfile.ini), for automating the installation of SQL Server, has been around for many…

Microsoft provides Azure DevOps for hosting your repos, setting up pipelines and more. In this article, Diogo Souza shows you how to get started using Azure DevOps.

Storing SQL Server database files in Azure blob storage is a great solution for all the databases that are often migrated between instances, servers, virtual machines, or would have...

What I want to do # create file local.users.yml user: - name: foobar1 email: foobar1@foobar.com - name: foobar2 email: foobar2@foobar.com - name: foobar3 email: foobar3@foobar.com locals { users_file = "local.users.yml" users_file_content =...

A few weeks ago, I wrote a post to announce the new AWS Graviton2 Amazon Elastic Compute Cloud (EC2) instance type, the M6g. Since then, hundreds of customers have...

Devices hybrid joined to AAD are not joined to AAD. But instead, joined to ADDS and automatically registered with AAD. The post Understanding Hybrid Azure Active Directory Join appeared first...

Key Details What: Data Platform Summit 2020Where: OnlineWhen: November 30th through December 8thRegister at the Data Platform Summit site. What I’m Presenting Monday, December 7th and Tuesday, December 8th, 12 PM...

Join me 30 Jul 2020 at 12:00 PM EDT for Updates to the SSIS Framework! The recording for this presentation is available here. “I cover a really good example...

This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task... The...

PowerShell isn't just a command-line tool for system administrators. Even savvy Windows 10 users can take advantage of the capabilities built-in to make changes to their OS. The post The...

At a typical annual meeting of the Association for...

Click to learn more about author Kyle McNabb. The ...

eWEEK DATA POINTS: Data science also helps businesses use advanced tools and technologies to automate complicated business processes linked with extracting, analyzing and presenting raw data. With rapid advancements...

Many people use entrenched processes for database ...

In the final article of this series, Edward Pollack demonstrates the maintenance of columnstore indexes. He also takes a look at nonclustered columnstore and memory-optimized columnstore indexes.

(2020-July-29) There is a well known and broadly advertised message from Microsoft that Azure Data Factory (ADF) is a code-free environment to help you to create ... The...

Intel this morning is taking the wraps off of a new Core i9 processor that it’s adding to its family of Comet Lake desktop CPUs. Taking its place as...

I was going to title this blog “MEDIANX and the X Functions”, but that sounded too much like a 2030s band, so I opted for MEDIANX returns blank in...

The most appropriate way to deliver Power BI content to your users is not always apparent. With Power BI Pro licensing, most people view your reports and dashboards in the...

I recently came across the need to build a screeni...

Overlapping Power BI visuals can be FRUSTRATING! A...

When starting a Power BI project, you have many choices to make. Decisions like how to source your data, where and how to create queries to cleanse, transform and...

Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge Can you write... The...

Learn how you can take conditional drill to the NE...

With weird discrepancies and fluctuations, COVID trackers say the data is less useful.

The folks on Twitter liked this, so sharing it her...

No discussion about storage is complete without thinking about security of the data. In this article, Robert Sheldon explains what must be considered to protect data in today's world.

FHE allows computation of still-encrypted data, without sharing the secrets.

Provider of GPS services for navigation and wearab...

There are many situations when you need to extract a DACPAC from an existing database in a SQL Server. These situations are usually related to devOps, we extract the...

     I wrote about finding distance between two...

Total: 4 Average: 5Do you use SQL subqueries or avoid using them? Let’s say the chief credit and collections officer asks you to list down the names of people,...

There are actually a couple of ways to create a pr...

Question: What is Full Outer Join With Exclusion??...

Watch this week’s video on YouTube. Imagine you need to join two tables of data and filter the results. Perhaps you also need to convert some of the values... The...

When In-Memory OLTP first came out, Microsoft liked to go around bragging at conferences that “Nothing stops a Hekaton transaction.” I remember hearing that and kinda chuckling at the...

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One thing that helps ensure your data is... The...

Uber and Lyft argue their drivers are not employees, but some courts disagree.

So far, this test flight has been a great success....

Analysis shows costs—and subsidies—are falling rapidly.

The cabin design looks nice. But why are these renderings?