Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News by SQLServerCentral.com
Hand-picked content to sharpen your professional edge
Editorial
 

Moving on but not far

During my technical career, I’ve changed companies several times. I even worked as an independent contractor for three years. One thing I have never done before was switch departments and roles within one company. That’s about to change in a couple of weeks as I move from Simple Talk Editor and DevOps Advocate in Marketing to Customer Success Engineer which is part of Sales. Like any job change, I’ve also planned a buffer week when I’ll be taking a few days off.

Many people have asked why I would want to give up this dream job (hmmm, reminds me of when I left pharmacy to work in technology). Well, for one thing, I’m not leaving Redgate. It’s the best company I’ve ever worked for and, hopefully, the last.

The answer might have something to do with The Great Resignation, and, of course, tech people do change often. I just want to do something different, and the CSE job sounds like I would enjoy it. I’ve missed working with customers, and this will give me a chance to focus on Redgate’s products.

One thing I didn’t think about was how difficult it is to change jobs within a company. When leaving a job, you just put in a notice and leave when it’s time. In this case, since I’m staying at the same company, I’m aware of how replacing my responsibilities is going. I’ve worked hard on Simple Talk over the past four and a half years, and I want that success to continue. It’s not easy to let go, but I also can’t do both jobs. Moving to the new role does feel similar to a move to a new company, but harder.

One of my responsibilities has been writing an editorial for the Database Weekly newsletter every three weeks or so. This is my last one, so I hope you have enjoyed learning a bit about SQL Server from me. I’m moving on, but I won’t be far.

Kathi Kellenberger

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

Why Database Monitoring Tools are Important for Senior Leaders

Matt Gordon is a Microsoft Data Platform MVP and the Director of Data and Infrastructure at Rev.io. In this short video, he talks us through the 3 key reasons database monitoring tools are essential for him as a Director, and how they help him to lead a team successfully and productively.

10 Benefits of Database Monitoring for Business Leaders [Video]

A third-party database monitoring tool is an investment that drives enormous value for the bottom line of your business in ten key ways. Here's how a tool like Redgate SQL Monitor can save you money, time and assist with security and compliance concerns.

Administration of SQL Server

Daily SQL Monitoring – SQL Server Versions for May

From Steve Stedman

Here listed is the current percentages of SQL serv...

Always Backup WITH CHECKSUM?

From Callihan Data

When you’re specifying WITH CHECKSUM as you’re backing up databases, SQL Server will use checksums to help catch any inconsistencies with pages. This seems like a setting that you...

Azure CosmosDB

How to retrieve Indexing Metrics for your Cosmos DB queries?

From Hasan Savran

Azure Cosmos DB indexes all properties by default. It is great to not worry about which property should be indexed in your database but after a while,...

Azure SQL

How to setup email alerts to monitor automation jobs for Azure SQL DB maintenance

From Azure Database Support Blog

When we automate Azure SQL DB index and statistics...

Azure SQL Managed Instance

How to fix “Connect Timeout” and/or “Cannot open server xxx requested by the login” when connecting to Azure SQL Managed Instance in redirect mode

From T-SQL Tech

Here is something that will save you lots of time ...

Connecting SQL Server 2016 to Azure - SQL Managed Instance link | Data Exposed

From Azure SQL

Link feature for Managed Instance is a new feature providing a hybrid connection between SQL Server 2016 (Enterprise, Developer and Standard editions) hosted anywhere and the fully managed PaaS...

Azure Synapse (SQL Data Warehouse and Data Lake)

Are you following best practices with Azure Synapse Analytics?

From Guy in a Cube

How do you know if you are following best practice...

Implementing Fact-to-Dimension Mapping on Lakehouse using Synapse Mapping Data Flow

From MSSQL Tips

In this article we cover a common fact processing task which is fact-to-dimension mapping and how this can be done with Azure Synapse Analytics.

Computing in the Cloud (Azure, Google, AWS)

Snowflake + Azure Privatelink

From SQLServerCentral Blogs

Azure Privatelink provides private connectivity fr...

Conferences, Classes, Events, and Webinars

Database DevOps: Standardize, Automate, Monitor & Protect

See how our end-to-end framework for extending DevOps to your database enables your organization to balance the demand to deliver software fast with the need to protect and preserve business critical data.

Data Mining / Data Analysis

A Beginner’s Guide to Data Modeling and Analytics

From Dataversity

As more and more companies start to use data-relat...

Data Privacy, Compliance, and Governance

Data Projects Should Start with Data Governance

From Dataversity

The hallmark of any successful Data Governance imp...

Database Design, Theory and Development

Why You (usually) Want a Clustered Index

From FLX SQL

Note: I originally wrote this a few years ago but ...

MDX/DAX

DATESBETWEEN – DAX Guide

From SQLBI

DATESBETWEEN: Returns the dates between two given ...

DATEADD, SAMEPERIODLASTYEAR – DAX Guide

From Sqlbi

DATEADD: Moves the given set of dates by a specified interval. https://dax.guide/dateadd/ SAMEPERIODLASTYEAR : Returns a set of dates in the current selection from the previous year. https://dax.guide/sameperiodlastyear/

Oracle/PostgreSQL/MySQL/other RDBMS

Comparing SQL Server Full Text Search and Oracle Text Search

From MSSQL Tips

In this article we look at SQL Server Full Text Search and Oracle Text Search to compare the similarities and differences of how they work.

A Week In Other Databases: IO in PostgreSQL: Past, Present, Future

From Erik Darling Data

Cool Cool Cool A while back, the CMU Database group started hosting a series of database talks that gave the folks behind new and interesting databases a chance to talk...

Optimizing my.cnf for MySQL performance

Database systems often need tuning for best performance. Lukas Vileikis explains to how to optimize my.cnf for MySQL performance.

Performance Tuning SQL Server

The SQL Query Alias Conundrum – Order of Execution

From Purple Frog Systems

So, you have just written a query, hit execute and...

Understanding Memory Fractions

From SQL Server Fast

Some time ago a reader reached out to me with a request for help. He showed me a query and accompanying execution plan, and asked if I could help...

Simple Parameterization and Trivial Plans — Part 4

From SQLPerformance.com

Paul White continues his series explaining how the parser affects simple parameterization and trivial plans. Learn more in part 4. The post Simple Parameterization and Trivial Plans — Part 4...

PowerPivot/PowerQuery/PowerBI

(Livestream Replay) Let Me Sell You on Power BI Goals - with Tommy Puglia

From Havens Consulting

Quite possibly one of the most underrated features...

Power BI connectors to Azure Synapse

From SQLServerCentral Blogs

When using Power BI and pulling data from Azure Sy...

Building A Reporting Solution Using Excel Power Query – Where Are We Now?

From Chris Webb's BI Blog

Seven years ago I gave a presentation at SQLBits c...

Changing Columns & Measures in Visuals Easily with Field Parameters!

From Havens Consulting

Learn about the new Field Parameters feature in Po...

Set Power BI Data Color: All Visuals to Follow Same Color for the Same Data Point

From RADACAD

You can set the color in every visual in Power BI ...

Professional Development

How to become a SQL Server Developer

From SQLShack

In this article, we will talk about what SQL Server developers do and which main skills are required to get a job as a SQL developer. Introduction In this...

Python

Memory profiling in Python with tracemalloc

You can find memory leaks in Python code with tracemalloc. In this article, Priyanka Nawalramka demonstrates how to use tracemalloc to find the leaks.

SQL

SQL Database Overview

From MSSQL Tips

Learn about what a SQL database is, what is stored...

SQL Server News

New SQL Update from Microsoft

From Steve Stedman

Today Microsoft released a new update for SQL Serv...

T-SQL and Query Languages

Lever the TSQL MAX/MIN/IIF functions for Pinpoint Row Pivots

From SQLShack

Introduction For a recent Tsql development project...

Left and Right Deep Hash Joins

From Forrest Shares Stuff

There’s a lot already written about left versus ...

How to Write a SQL SELECT Statement

From MSSQL Tips

In this article we look at how to use the SQL SELE...

How to write readable T-SQL queries

From SQLShack

This article intends to give some beneficial sugge...

Tools for Dev (SSMS, ADS, VS, etc.)

Getting Started with Query History and Table Designer in Azure Data Studio

From MSSQL Tips

In this article we look at how to add the query hi...

Virtualization and Containers/Kubernetes

Public preview: Container Storage Interface extensible API for AKS

From Azure Updates

You can now disable and enable any of the AKS supp...

VMware & SQL Server 823-824 alerts

From SQLServerCentral Blogs

We’ve been tracking a weird state with SQL Serve...

General availability: Azure Backup support for trusted launch Azure Virtual Machines

From Azure Updates

Configure backup of your trusted launch Azure...

 
RSS FeedTwitter
This email has been sent to newsletter@newslettercollector.com. 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

 

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