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

The New Year: A Chance to Start Over

January 1st is the beginning of a new year thanks to Julius Caesar and Pope Gregory XIII. This date is somewhat arbitrary, and many religions and cultures celebrate their own beginning of a new year at different times. Even though these celebrations don’t fall at the same time, I think the sentiment is similar.

The end of one year and the beginning of the next is significant to us because it is a chance to take stock of the previous year’s accomplishments and come up with new resolutions. These resolutions might involve health, fitness, relationships, work skills, or even bucket list items like writing a book. These are often broad statements such as “This year, I will get in shape” or “This year, I will earn that promotion.” Many of us are disappointed as we fail to meet these resolutions but are sure that things will change the following year.

One example is vowing to become more physically fit by buying a gym membership. I typically visit the gym twice a week and usually don’t have to wait for the equipment I want to use. I know that, starting the first week of January, things will change. For about three weeks, I’ll have trouble finding a parking space and may have to wait around to get my turn on the equipment. Gradually, things will get back to normal, and I can return to my routine.

As February approaches, people find excuses to skip their workout, cheat on their diet plan, or watch a movie instead of working on that online class. Some people say that “life gets in the way,” but often it is just waning enthusiasm.

Instead of making broad resolutions that you won’t keep, consider making specific, smaller goals. Here are some career-related ideas you may consider:

  • Start a blog and publish a post every month
  • Present a session at your local user group or SQL Saturday
  • Learn git, PowerShell, or running SQL Server in a container
  • Spend 30 minutes every day reading articles from SQL Server Central or Simple Talk
  • Better yet, begin writing articles for these publications
  • Try out the new features of SQL Server 2017 and 2019 that improve performance without code changes (Intelligent Query Processing)

To help you stay accountable, add your goal related activities to your calendar and tell your team members or manager. Take stock each day or week to see if you are doing things that get you closer to your goals. (There are countless articles and books on this topic if you want more ideas.)

I must admit that I have let some of my goals slide (I’m still not taking voice lessons), but, overall, this approach has helped me accomplish quite a bit over the past 20 years, often surpassing the original goal more than I could ever have imagined.

Kathi Kellenberger

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

Redgate University
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

Using Aliases in SQL Prompt

Phil Factor explores the role of table aliases, ex...

AI/Machine Learning/Cognitive Services

Man vs. Machine: Why AI is Not a Threat to Human Jobs

Click to learn more about author Thomas Ash. A lot of the concern about artificial intelligence in the workplace appears to be based on what people have seen in...


No-Longer-Necessary Trace Flags

Monica Rathbun points out some of the trace flags ...

Find Index Create Date

This article shows a quick script to help determin...

Azure DevOps

Why You Should Take the 2020 State of Database DevOps Survey today (video)

In this six minute video, I explain why you should...

Big Data

Choosing a SQL Platform on Hadoop

Sagar Kewalramani walks us through the choices for...


Installing PowerShell for SQL Server – #SQLNewBlogger

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

Data Visualisation

Data Visualization in R and Python

Michelle Golchert contrasts libraries for visualizing data in R and Python: Unlike R, Python – as a “general-purpose” programming language – does not include data…Continue readingData Visualization in R...

Database Design, Theory and Development

SQL Server Truncating Numbers to Asterisks

Bert Wagner points out that some numeric types han...

From SQL Server to Cassandra

Shel Burkow has started a new series: A subset of ...

Redgate SQL Monitor
ETL/SSIS/Azure Data Factory/Biml

SSIS Layout Formatting Options

Most folks I know go to one extreme or the other w...

Azure Data Factory Templates and Source Control

Cathrine Wilhelmsen continues a series on Azure Da...

Formatting SSIS Packages

Tim Mitchell shows us different options available ...

Checking SSIS Variable Values During Runtime

As anyone who reads my blog on a regular basis kno...


Automating JSON to Tables

Dave Mason has a stored procedure for us: The code...



Marco Russo shows us how to build the equivalents ...

DAX Studio Parameters Dialog

Originally posted on:

DAX Studio – What do all those numbers mean in the server timing output?

Originally posted on:

Machine Learning

Setting Management Expectations in Machine Learning

Click to learn more about author Edward Wong. Data scientists and analysts spend most of their day interacting with data problems – preparing data for analysis, writing and testing...


Monitoring Oracle on Azure

Kellyn Pot’vin-Gorman covers several tools which are available for working with Oracle databases in Azure: The Oracle SQL Developer product has come a long way since it’s…Continue readingMonitoring Oracle on Azure

Performance Tuning SQL Server

Batch Mode On Row Store Is Fickle

Thanks Though I’m excited about this feature. I?...

SQL SERVER – Parameter Sniffing and Local Variable in SP

The question I had received was about Parameter Sn...


I consider myself fortunate that I receive a follo...

Blocking with OBJECT_NAME()

As a DBA, you probably use the OBJECT_NAME() function quite a bit. I know I do. If you aren’t familiar with it, you can read the documentation if you...

Calculating the Pain of UDFs

Taiob Ali points out something added to SQL Server...

How to Make SELECT COUNT(*) Queries Crazy Fast

When you run a SELECT COUNT(*), the speed of the results depends a lot on the structure & settings of the database. Let’s do an exploration of the Votes...

Fun with (columnstore) compression on a very large table – part 1

Aaron Bertrand starts a series looking at using clustered columnstore indexes and page compression to address storage footprint for a 1TB table. The post Fun with (columnstore) compression on a...

Implicit Conversion Is A SARGability Problem

Concerns If you compare the things that non-SARGab...


Data Virtualization in SQL Server 2019

Some of the most eagerly anticipated features now ...


New “Diagnose Step” Power Query Feature In Power BI

One new feature that was introduced in the December 2019 release of Power BI Desktop, but which wasn’t mentioned in the release blog post, is the “Diagnose Step” button...

Fixing incorrect date formats in Power BI Report Server when using Chrome or Firefox

Originally posted on:

Power BI – Fixing Dates from Sharepoint Lists (converting UTC Dates to Local Dates)

Originally posted on:

Custom Power BI filter pane with hide/show feature

Having as much possible Power BI estate when it comes to putting the visuals for data exploration, is everyone’s dream. But the slicers for “slicing and dicing” the data...

Professional Development

Free Stuff for People Who Give Back: Announcing 2020 Scholarship Application

Do you work for a charity or non-profit organizati...

Learn MySQL – New Technology Week

This is the last week of the year and most places ...

Reporting Services

Using the JOIN Function in Reporting Services

The JOIN() function in SQL Server Reporting Servic...

SQL Server Security and Auditing

Database Security, People and Processes

Protecting data is not easy, but it is critical. In this article, David Poole discusses database security and the behaviors needed to build secure systems.… The post Database Security, People...

Backwards Compatible Symmetric Keys in SQL Server 2017+

I discovered recently that there was a change made...

SQL Server 2017 and Column-Level Encryption

Steve Jones notes a change between SQL Server 2016...


Book Review: T-SQL Window Functions by Itzik Ben-Gan

A couple of years back Itzik Ben-Gan (the T-SQL gu...


Slava Murygin finds a nasty bug in SQL Server: Dat...

T-SQL 101: #49 Using REPLICATE to repeat strings in SQL Server

REPLICATE is an easy function to work with. It tak...

Temporal Tables, and how to deal with computed columns

Long time readers will know I’m a big fan of Tem...

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 This newsletter was sent to you because you signed up at Note: This is not the 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.


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