Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate Database Devops
The Voice of the DBA

Looking Back at the Year

Just two days left in 2019, and I thought this would be a good day to look back at the year. It's been a busy and long year, but a great one for me. I hope many of you feel the same, but if it's been a hard year, I hope next year is better.

I started the year doing more learning for myself and some coaching 13 year old kids at volleyball. Those tasks kept my busy for the first third of the year, and I managed to get through a few books, learn a few skills, and enjoy some time with SQL Server. It was still busy, as I didn't get a weekend off between Jan and April with either my daughter's team or mine playing in a tournament.

After April, I picked up the pace with events. I'll close out the year with 9 SQL in the City Summits and 7 SQL Saturdays. That was most of my year traveling, apart from the pre-con days at the PASS Summit. I normally go to a few more conferences, but decided not to this year. This was not as much speaking, but a lot of travel. This was my biggest year, where I flew over 140,000 miles and spent nearly 90 nights away from home. Fortunately, about 40 of those were with my wife, which makes it much more enjoyable.

This year saw a new release of SQL Server, one that I think is a milestone and will change the way we look at the platform. It will take a decade before most of our instances are at the 2019+ level, but this is the start of new ways to look at the platform with containers and scale out clusters. I'm excited by the possibilities and I look forward to how people will build systems in the future.

It seems that security was less of a news item this year, though there were still plenty of incidents. I was amazed that after all the press about security issues that so many Elasticsearch servers are still out there with no password. There really is not good reason for this. I'd like to think that this is the line in the sand, and if you install a server with no password after today, you're just terminated. Or arrested. That happened this year.

Redgate turned 20 this year, which was amazing for me. I've known the company for 18 years and watched it grow and change in that time. I've worked there for 12 years, and hope to see 20. Next up is 20 years for SQLServerCentral, which will be just over a year away.

I had a great year overall, and I'll write more on my blog if you're interested. I am looking forward to 2020, and I hope you are as well.

Steve Jones - SSC Editor

Join the debate, and respond to today's editorial on the forums

  Featured Contents

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1

Ginger Keys Daniel from SQLServerCentral

Learn how to get started uploading data from a SQL Server to Azure Blob Storage.

Quickly Find and Mask Sensitive Data with Data Masker 6.3.1

Additional Articles from Redgate

Khie Biggs, a software developer on the Data Masker team at Redgate, explains how a recent set of Data Masker improvements should make it significantly easier and faster both to determine what data needs to be masked, and then to apply the masking, to protect sensitive and personal data in the tables and columns of your SQL Server databases.

Storage 101: Welcome to the Wonderful World of Storage

Additional Articles from SimpleTalk

Understanding all the storage options available to...

From the SQL Server Central Blogs - What happens if I disable the clustered index?

Kenneth.Fisher from SQLStudies

You are probably already aware that you can disable an index. This can be handy when you have a large ... Continue reading

From the SQL Server Central Blogs - Who needs data access? Not You!


With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:

When Too Much is Not a Good Thing December 13,...


  Question of the Day

Today's question (by Steve Jones - SSC Editor):


The Extra Columns

sys.sql_logins includes extra columns that aren't in sys.server_principals. What are they?

Think you know the answer? Click here, and find out if you are right.



  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

The directory creation time

I have this code in PoSh:

$directory = Get-Item 'C:\Program Files\Microsoft SQL Server'
$message = "SQLDirectory Creation: $directory.CreationTime"

What is stored in $message?

Answer: $message contains "SQLDirectory Creation: C:\Program Files\Microsoft SQL Server.CreationTime"

Explanation: This is a place where variable expansion doesn't quite work. I to get the variable expanded, but the property of CreationTime is not evaluated. The result is: SQLDirectory Creation: C:\Program Files\Microsoft SQL Server.CreationTime Ref: Powershell: Everything you wanted to know about variable substitution in strings -  

Discuss this question and answer on the forums




Database Pros Who Need Your Help

Here's a few of the new posts today on the forums. To see more, visit the forums.

SQL Server 2017 - Development
Need Correct Query Code Please? Thx. merry Christmas SQL Kids - Compose a SQL query to retrieve all products with its most recent two orders? Products that haven’t been ordered should be listed  also. Use ERD below. Whats Correct Query Code?  
importing text file, bulk insert to populate table - I have to import a text file to build a table and all of the date fields currently are in integer form. It comes in three different ways. The first two are like '20191223' or '0' if there is no date. The third way in the text file is like '2170915', missing the second character. […]
Working with variable length number - please assist I have table 1 and table 2, join them on account number. the problem is that table 1 has extra zeros in the middle and while table 2 does not have extra zeros in the middle, the account number is not always of the same length. see below I need to match the […]
Hadoop for SQL Developers - Hello People I am a newbie in the field of SQL Development and have a silly query. I am doubtful about a thing that if Hadoop is easy to learn for SQL Developers. Is it essential to be aware of Hadoop if I'm totally into the field of SQL Development? How much SQL is required […]
SQL Server 2016 - Administration
Basic Availability Group in Sql Server 2016 Standard edition setup - Hi, I am trying to setup Basic Availability Group in Sql Server 2016 Standard edition SP-2-CU11 and i'm having few issues/questions:My Primary DB is encrypted with Master Key.We have built another Sql server for Always ON but no user DB yet.On Primary Sql server DB, We are taking Transaction Log Backup every hour and FULL DB every […]
Finding Auto Increment value for each table in DB - Hi, I am trying to get the max value of auto identity column with table name and column name. Below is the query I am using which GIVES me table and column name BUT NOT the MAX value. SELECT OBJECT_SCHEMA_NAME(tables.object_id, db_id()) AS SchemaName, As TableName, as ColumnName FROM sys.tables tables JOIN sys.columns columns […]
SQL Server 2016 - Development and T-SQL
Truncate or Insert data with conditions - Good day, I have two tables where A is the source and B is the destination, so what needs to be achieved, when A has no data don't truncate B when A has data truncate B and insert data from A. Need help if (select count(*) from [A]) > 0 truncate table B Insert into […]
Administration - SQL Server 2014
Offline vs Online index operation - As I know, while online index rebuilding, SQL Server virtually creates an index and then at the end it swaps the existing old index with the new created one and then finally drops the old index. I would like to know if these operation same for offline index rebuild. Will SQL Server create virtually an […]
Language conversion Japanese to English for MSSQL Server DB - Hi All, I have MSSQL Server Database  installed on windows in Japanese language. Also OS  ( windows  ) installed in Japanese language. I am as English user not able to any administration on MSSQL Server Database. So Can any one please let me know how I can change the MSSQL Server Database console language to […]
High Page File Usage - Page File Usage in one of our production database server is continuously up-to more than 200% of the total available memory. Is it a signal to add more physical memory?
Development - SQL Server 2014
Reusable Variable - hello, I know there's gotta be a way here, but I'm struggling.  Let's say I have a last name parsing sql statement (using the first few letters) but the rules are complex in the event of hyphenated names, Sr's Jr's etc...  Anyway, I have all that sorted out using SELECT CASE.  This works great, but […]
SQL Server 2012 - T-SQL
Migrating databases - error on login 4064 (cannot open default database) - Hello, I am trying to figure out how to create a script to generate Login mappings to databases. I've search a lot, plenty of cases and examples, but none seem to match my problem. Here a brief explanation: I have daily backups of databases I copy to my new server. No Logins, etc. I restore […]
Reporting Services
VS 2019 TargetServerVersions - I am trying to find out which SQL Server versions are supported in VS 2019 /SSDT for Reporting Services. We have  SQL Server 2008 R2. My Infrastructure team is building a new computer with Windows 10 and it will have VS2019 on it. Our Report Server is SQL Server 2008 R2 and I want to […]
Integration Services
Has anyone used BIML to create Memory optimized tables. - I was hoping to experiment with memory optimized tables for my staging layer to speed up the process. Googling "BIML Create Memory Optimized Table MEMORY_OPTIMIZED=ON" is not giving me nay results. This seems like it would be a common setting for a table used in a staging layer. I am using the table.GetDropAndCreateDdl() code to […]
Article Discussions by Author
Performance Tuning Using Extended Events: Part 2 - Comments posted to this topic are about the item Performance Tuning Using Extended Events: Part 2


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
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


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