Living Life

It's a holiday weekend in the US this weekend. As such, many of you will be taking a break from work and enjoying time with family, as well as remembering some history in the US. If you're in the rest of the world, hopefully you have a holiday coming up soon you can enjoy.

One of the important things about holiday and vacation is getting away from work and refreshing and recharging yourself. Finding a balance is important for you enjoying life, but also being more creative and focused at work. Many of us work hard, but we also need to learn to really enjoy life.

If any of you have been following Brent Ozar, you know he's in Iceland for a few months. He's living and working there, and recently updated his Epic Life Quest to show he completed Level 15. Whether you want to visit Iceland or not, the idea of tackling things in life that matter to you is important. You should be living the way that you want to live, doing the things that matter to you and your family.

Lots of people have a bucket list of some sort, including me. I've had a "life list" for a long time, and have worked to knock a few things off. I'm not as organized or focused as Brent, but I'm happy with the things I've been doing.

This year I've started to be a little more excited in the world with things happening outside of work. With the pandemic making much of work and life boring, it was nice for me to get away for some short trips with my wife, and having volleyball coaching as something to engage me in life. It was an exciting season for my girls, as they went 49-4.

There's lots of technical stuff to learn, and some fun things in this newsletter, but I hope that you remember to tackle things in life that excite you. Things that make life worth living and fun. We work to live, not the other way around, so whether you want to plan things out or take advantage of opportunities when you can, make your own dreams and wishes come true.

Steve Jones - SSC Editor

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

In this blog, David Yard at Kingston Technology shares his favorite SQL Monitor features and how they’re helping him to make sure their large SQL Server estate performs at its best.

How to save all your different types of SQL code snippets in a central library of JSON Snippet Collections, where you can search and edit each collection and then write them out as individual code snippets, for use in SQL Prompt, SSMS or your programmer's clipboard.

How to exploit the branching and merging capabilities of Git for scaling up team-based development, when doing Flyway migrations.

If, somehow, you’ve managed to see this error in your errorlog then congratulations, you’ve won an instance of SQL Server that probably won’t be doing much.

I have been doing more and more replication work l...

Businesses who need high availability and disaster recovery usually want three servers: A primary SQL Server where all the writes & reads take place A high availability SQL Server...

Interesting conversation with an app owner about s...

The only way to derive meaning from the massive amounts of data collected today is to develop innovative high-performing, high-capacity storage solutions. In this book, Robert Sheldon explains the many types of storage currently available and what's on the way.

Andrew Weaver, et al, take us through security practices for running Databricks on AWS: In this article, we will share a list of cloud security…Continue readingSecuring Databricks on AWS

Life’s little moments of success can pass us by so easily. If we don’t track the things we’re proud of, we lose track of how far we’ve come. Steve Kamb’s Epic Quest...

I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading The post The WITDC Mental Health and...

The other day I saw something that I wasn’t sure I’ve ever see again. The call for speakers for the PASS Data Community Summit went out. After the dissolution... The...

Since Amazon Elastic Container Service (Amazon ECS) was launched in 2014, AWS has released other options for running Amazon ECS tasks outside of an AWS Region such as AWS...

Calling all data platform speakers! Whether you’re a brand-new speaker or a seasoned presenter, now’s your chance to submit your abstract and be considered for this year’s free online PASS Summit Data Community SUMMIT. Make your submission today and sign up to receive the latest conference updates.

Join Flyway expert Carlos Robles in this session to explore and discuss the new features of Flyway v7 which make it one of best database version control and migration tools in the market.

Director at ThoughtWorks Pramod Sadalage explores trends such as rapid digital transformation and an ever-changing tech landscape, that'll change the way we work with databases and DevOps in the next 20 years.

Finally, I came up with a practical example using the Powershell Secret Management module for storing SQL credentials. This is an excellent way of keeping your SQL connection strings information out of your scripting code. This way we just have it stored in our Vault.

I was looking at the new vcpkg website, and starting to peruse the code (available here). From the website:

In the comments here I was asked about using Resto...

A Developer asked how to find the powershell cmdle...

Click to learn more about author Ray Brosnan. Facilities management is a broad discipline that involves the management and optimization of a business’ environment, property, equipment, and people to...

In the final post of our "Better Together" blog se...

To communicate effectively with data, it’s impor...

I thought it would be worthwhile to put together this SQL Server Build and Support Date Cheat Sheet that combines some useful information from two main sources. The first is information and links about the latest public CU build of each major version of SQL Server going back to SQL Server 2005.

GPU-Z is a very useful, free utility from TechPowerUp. This utility shows a lot of detailed information about your video card(s). It is quite handy for both desktop and laptop systems.

Prior to the release of Intel's 11th Generation Ro...

DATE: Returns the specified date in datetime forma...

Learn the differences between eager evaluation and...

DATEDIFF: Returns the number of units (unit specified in Interval) between the input two dates. https://dax.guide/datediff/ YEARFRAC: Returns the year fraction representing the number of whole days between start_date...

This is the third article where I have covered bui...

The changes in 21H1 are mostly minor—much bigger...

A few weeks ago I made a rather embarrassing disco...

SQL Server performance tuning can seem overwhelming when you don’t know where to start. In this article Robert Sheldon explains 9 best practices for performance tuning. … The post SQL...

There are different approaches to having a dynamic...

Starting today, the Apache Spark 3.0 runtime is now available in Azure Synapse. This version builds on top of existing open source and Microsoft specific enhancements to include additional unique improvements listed below. The combination of these enhancements results in a significantly faster processing capability than the open-source Spark 3.0.2 and 2.4.

I am so excited to announce scripting in SSIS Fram...

With Amazon Redshift, you can use SQL to query and combine exabytes of structured and semi-structured data across your data warehouse, operational databases, and data lake. Now that AQUA...

How to find dataset differences in R, when the pieces of information are changing between datasets it’s a difficult task to identify the same.

A short one for today: in this post we will learn ...

DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses those options in this article.

Repetition Is Everything I know what you’re thin...

Canard People still tell me things like “I only ...

Lamp This issue is one that could be linked to other times when the optimizer defers certain portions of optimization to later stages. It’s also something that could lead...

It works when I run it this way™ but not when I ...

Another post for me that is simple and hopefully s...

Apple patches vulnerability that malware used to b...

Apostle seems to be a new strain of malware that d...

Presently sponsored by: Tired of poor coverage and...

Kremlin-backed group uses hacked account to impers...

Russia’s Sunburst cyberespionage campaign, discovered late last year, impacted more than 100 large companies and US federal agencies, including the Treasury, Energy, Justice, and Homeland Security departments. A crucial...

Total: 2 Average: 5The SQL DROP statement is a command that deletes existing database components or the entire databases with all their data permanently. There are other SQL commands...

Fix the CONSTRAINT create failed Msg 1752, Level ...

You can create foreign keys using TSQL roughly the...

What do you do when you want to check the history ...

If you’ve done work with stored procedures, you ...

One of the important settings on SQL Server is the...

This is part 4 of a 19 part series on TSQL Basics. You will first gain an understanding of the differences between each of these types of joins, and...

I used to always see the STUFF function in passing...

Total: 1 Average: 5 Understanding Table Relations SQL server adds foreign keys to implement relations between tables in a relational database. A table can have one-to-one, one-to-many, or many-to-many...

Demand for 5G smartphones is reaching an all-time ...

Date: Tuesday, June 22, 2021 Time: 02:00 PM Eastern Daylight Time Duration: 1 hour You’ve scoured the web for recommendations, and read countless articles and comment threads, but the question remains: do I really need...

USTelecom's "Broadband Pricing Index" doesn't meas...

Retro-futuristic styling, 18-minute charge times, ...

The company has rarely used such a "young" rocket ...

The stylish and spacious electric sedan goes into ...