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
 

Be Professional

There are a lot of challenges in our current situation. Most of us reading this are likely stuck at home, dealing with the challenges there. Some of us reading this may be going through the insanely tough challenge of looking for employment. There also are likely some of us with health issues or dealing with the health issues of those around us. Through it all, there’s a relatively high likelihood that you’re on social media of one form or another, trying to connect with your co-workers, family, friends and acquaintances. The one piece of advice I can offer you that applies any time, but doubles in importance during our current situation, is that you act, communicate, and be, professional.

There can be a lot of baggage associate with the idea of professionalism. Is it about simple competency? Punctuality? Responsibility? Sure, it’s all those. In order to be professional, you must strive for a level of competency. You also have to show up on time, deliver on the things for which you’re responsible, and generally get your work done. That’s all taken for granted. However, there is more to it.

A professional is also able to deal well with others. The easy part is communicating your work and your responsibilities to your teammates and others. The hard part is dealing with adversity. In adversity the professional shines. They listen to others respectfully and actively. The professional doesn’t lash out and get emotional if confronted. The professional largely treats others as they would like to be treated. All this is more important than ever on social media because that public post, that’s forever.

Future customers, clients, co-workers and friends can find that moment when you decided that a sick burn or a hot take or an ad hominem rant was more important than being a professional. The best way to be professional is to act professional. That’s been true in the past and it will be true in the future. Keep it in mind as you engage with others on social media today.

Grant Fritchey

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

 
Redgate SQL Source Control
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

Take the 2020 State of Database Monitoring Survey

The State of Database Monitoring survey is open. How are you currently monitoring your database estate? Are you working cross-platform? Tell us your opinions in our annual survey on the State of Database Monitoring for your chance to win a $500 Amazon voucher. Take the survey.

Administration

SQL Server In Place Upgrades: Too Expensive?

About eight years ago, I wrote a (kind of long) an...

SQL Server and CPU Hyper-Threading in Virtual Environments

I recommend leaving the hyper-threaded logical cor...

sp_execute_external_script and Bytecode Version Mismatch

You may run into some trouble with sp_execute_external_script and R when you pass in CHAR and/or VARCHAR "string" data as part of your input data set. Here is an...

SQL Agent Job Generator: Building the Base Rig and Managing Categories

In the previous entry in this series, I implemented Environment Variables that will let me have one code base that can easily generate jobs in DEV, PROD, or whatever...

Removing the default trace – Part 2

Aaron Bertrand continues his series on replacing the default trace with a more efficient and more complete Extended Events session. The post Removing the default trace – Part 2 appeared...

Azure SQL Database

Azure SQL Database – Error Logs?

Ok, so Azure SQL doesn’t really have its own err...

Career Growth and Certifications

How the Company-Startup Thing Worked Out For Me, Year 8

It’s time for my annual update on the wild ride. If you want to catch up, check out past posts in the Brent Ozar Unlimited tag. This post covers...

Want SQL Server Training? Copy/Paste This Email To Your Boss.

Well, that escalated quickly, huh? Just a few short months ago, we were all making plans about what we wanted to learn in 2020. We sketched out our goals,...

Learning Postgres:Installation

I had the opportunity of working on a project converting a postgres database to a sql server based one at work. I used this opportunity to learn more of... The...

Redgate SQL Prompt
Community Interests and PASS

Covid Thoughts, So Far

I’ve gathered a bunch of notes from conversation...

Community Circle – Together we learn

Covid-19 has taken a toll on communities across the globe, impacting lives in unprecedented ways. The stresses and strain of course vary depending on your situation, but there’s one...

Computing in the Cloud (Azure, Google, AWS)

Reading a SharePoint List with Azure Logic App

Sometimes in life you have to do things you really...

Disks performance in Azure

In our earliest post, we have discussed in detail ...

Conferences, Classes, Events, and Webinars

Webinar: How to unlock the value of frequent deployments

I’m doing a webinar next week, on Wednesday, Apr...

How to unlock the value of frequent deployments

Date and time: Wednesday April 15, 4-4.30pm BST / 10-10.30am CDT - Frequent deployments can give you greater flexibility in meeting changing business requirements, but if code quality is poor this may cause major headaches for your customers and your whole organization. In this 30-minute webinar, Steve Jones will share how you can achieve frequent deployments without constantly needing to hotfix your production system. Can't join us live? register to receive the recording.

DevOps essentials from Abel Wang and Steve Jones

Date and time: Thursday April 23, 4-5pm BST / 10-11am CDT - Microsoft's Principal Cloud Advocate & DevOps Lead, Abel Wang joins Redgate's Steve Jones to discuss what DevOps really is, and how it can enable you and your organization to adapt. Can't join us live? register to receive the recording.

The easy way to Extended Events

Date and time: Wednesday April 29, 4-5pm BST / 10-11am CDT - Join Microsoft Data Platform MVP Grant Fritchey to discover not only know why you should be using Extended Events, but also how to get going in Extended Events the easy way. Can't join us live? register to receive the recording.

Join me (virtually) in Adelaide!

I will be presenting a session to the Adelaide SQL Server User Group on April 15th, 2020, and if you’re awake at that time (it’ll be 9pm on April... The...

DMO/SMO/Powershell

#PowershellBasics: Using environment variables ($env:ProgramFiles)

The other day Kendra Little (blog|twitter) mentioned that she was trying to get a command in Powershell working. Specifically one ... Continue reading The post #PowershellBasics: Using environment variables ($env:ProgramFiles)...

Comparing ThreadJob to PSJobs in PowerShell 7 on Linux

There have always been a few options for running background asynchronous tasks within PowerShell. Traditionally, PowerShell (PS) Jobs was the go to method as a job could be started...

Data Visualisation

what is an area graph?

This article is part of our back-to-basics blog se...

DevOps and Continuous Delivery (CI/CD)

Document Your Pain

In this article, Grant Fritchey explains how leavi...

ETL/SSIS/Azure Data Factory/Biml

ADF.PROCFWK V1.3 – METADATA INTEGRITY CHECKS

This open source code project delivers a simple metadata driven processing framework for Azure Data Factory (ADF). The framework is delivered by coupling ADF with an Azure SQL Database that houses execution stage and pipeline information that is later called using an Azure Functions App.

Switching between different Azure Data Factory environments

When working with Azure Data Factory, it’s possible you have multiple ADF environments. For example, you can have one for dev, one for test and one for production. Unfortunately,... The...

Transforming JSON data with the help of Azure Data Factory - Part 3

(2020-Apr-06) Traditionally I would use data flows in Azure Data Factory (ADF) to flatten (transform) incoming JSON data for further processing. Recently I've found a very simple but very effective... The...

HA/DR/Always On/Clustering

A Smattering of Thoughts About Applying Site Reliability Engineering principles

What's This about I figured I'd go ahead and take this article which I've gutted several times and share some thoughts, even if it's not an authority on the topic....

Hardware

SK Hynix Sampling New PCIe 4.0 96L SSDs, 128L 4D NAND Enterprise SSDs

SK Hynix today announced that they’ve begun sampling of its first ever PCIe 4.0 enterprise SSDs in the form of the new 96-layer 3D-NAND U.2/U.3 form-factor PE8010 and PE8030...

Storage 101: Data Center Storage Configurations

In this article in the series, Robert Sheldon explains the differences between direct-attached storage, network-attached storage, and storage area networks.… The post Storage 101: Data Center Storage Configurations appeared first...

Microsoft News

Microsoft makes more tweaks to its M365 services in light of increased remote-work demands

Microsoft is continuing to make adjustments to various Microsoft 365/Office 365 services with the aim of providing continuity during the coronavirus pandemic.

Microsoft’s Conference Strategy Reboot

Microsoft is not planning to have an in-person event until after July of FY2021 concludes and is re-thinking its entire conference strategy. The post Microsoft’s Conference Strategy Reboot appeared...

NoSQL

Quick Guide: Data Structure in a Document Database vs. Relational Database

Click to learn more about author Niels Brinch Experts in relational database structure may find it very confusing to structure data in a document database. However, there are actually...

Performance Tuning SQL Server

The SQL Server Performance Tasting Menu: Common Table Expressions

“Common” Is Not A Compliment …

[Video] How Can I Measure If My Database Does More Reads Than Writes?

When someone asks you, “Is this database read-intensive or write-intensive?” you probably look at sys.dm_io_virtual_file_stats to measure the file activity – but that isn’t really correct. After all, your users...

The SQL Server Performance Tasting Menu

*clinks glass* This post will have links to all the demo videos for my presentation, The SQL Server Performance Tasting menu. Since the demos change over time with whatever I...

PowerPivot/PowerQuery/PowerBI

I Need Your Questions about Power BI and Paginated Reports

For a new series of posts to include tutorials and "how to" demonstrations for Power BI, SQL Server Reporting Services (SSRS) and Paginated Reports, I need your help...

Row-Level security in Power BI

Row -Level Security or managing roles in Power BI is not something new. But environments, where there is a need for securing read access for end-users based on their...

Creating calendar tables with DAX using Power BI

By Nick Edwards In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX. Dates are important if we want to perform time...

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel

One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the...

Product Reviews and Articles

Make Database Code Reusable in SQL Source Control with Deployment Filters

When I first began working with databases, I was lucky to land a job at a little start-up which had solid development and operations processes: all our code, including... The...

Designing an automated database deployment process: case study

In my previous article, How to design an automated database deployment process, I wrote about the steps companies and organizations should take to introduce automation to their database deployments....

Product Upgrades and Releases

SSMS 18.5 Fixes from Redgate

I wrote yesterday about the issues with SSMS 18.5 ...

SQL Server Security and Auditing

Has this login been used recently?

I get asked this every now and again, along with the companion When was the last time this login was ... Continue reading The post Has this login been used...

What Prevents You From Securing Your Servers?

Reading about how hackers are using SQL Server instances that are exposed on the internet AND have weak passwords to work into systems, I’m sitting here wondering why. I... The...

Security News and Issues

Frontier bungles redaction of network audit that it doesn’t want you to see

Blacked-out text is readable, revealing 952,000 po...

Kubernetes Security

Attack matrix for Kubernetes, using the MITRE ATT&...

Cybersecurity During COVID-19

Three weeks ago (could it possibly be that long already?), I wrote about the increased risks of working remotely during the COVID-19 pandemic. One, employees are working from their...

RSA-250 Factored

RSA-250 has been factored. This computation was performed with the Number Field Sieve algorithm, using the open-source CADO-NFS software. The total computation time was roughly 2700 core-years, using Intel...

Attackers can bypass fingerprint authentication with an ~80% success rate

Fingerprint-based authentication is fine for most people, but it's hardly foolproof.

Zoom brings in former Facebook security head amid lawsuits, investigations

Company is playing catch-up as pandemic magnifies every flaw.

Hardware-Enforced Stack Protection Preview Arrives For Windows 10

Microsoft announces support for protection against Return-Oriented Programming based control flow attacks in Windows 10 Insider builds on the Fast Ring. The post Hardware-Enforced Stack Protection Preview Arrives For Windows...

T-SQL

The Many Flavours of the Arcane SQL MERGE Statement

The SQL MERGE statement is a device whose mystery ...

Fundamentals of table expressions, Part 1

Itzik Ben-Gan starts a new series discussing the fundamentals of table expressions, a commonly misunderstood feature in T-SQL. The post Fundamentals of table expressions, Part 1 appeared first on SQLPerformance.com.

JSON Challenges for DEVS in SQL Server

     FOR JSON lets you return the data in JSON format. As you might know, SQL Server can return and query JSON documents, but It doesn't have a...

T-SQL 101: #64 Changing the offset of a datetimeoffset value in SQL Server T-SQL using SWITCHOFFSET

The datetimeoffset data type was added in SQL Server 2012 and allowed us to not only store date and time values, but to also store a time zone offset...

Tech News

COVID-19 tests are going unused due to hospital IT challenges

Lab director: Hospitals are “astonishingly unpre...

Testing Software

Unit Testing Dependencies: The Complete Guide

In this article, we’ll review the types of unit testing dependencies. This is more of a reference article, to which I’ll be referring in future posts. Still, this topic...

The Lighter Side

The Car Game

I started this on Facebook, privately with friends...

University libraries offer online “lending” of scanned in-copyright books

Books are only available to patrons of participati...

Scientists ponder how jugglers seem to defy limits to human reaction times

The accuracy required is a measure of how unstable and difficult a juggling pattern is.

The 2020 World Car of the Year awards are out, and the winner is…

The awards were supposed to be announced at the NY International Auto Show.

Virtualization and Containers/Kubernetes

Adjusting pod eviction time in Kubernetes

One of the best features of Kubernetes is the built-in high availability. When a node goes offline, all pods on that node are terminated and new ones spun up... The...

Building A Sandbox Environment for A Big Data Cluster With microk8s

At work we are seeing a burgeoning demand for Kubernetes test and development environment, as such we have been looking at simple and rapid ways to provision clusters. I...

 
RSS FeedTwitter
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

 

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -