SQLServerCentral - www.sqlservercentral.com

A community of more than 1,600,000 database professionals and growing

Featured Contents

The Voice of the DBA

Looking Back at the Summit

Last week I was fortunate enough to attend the PASS Summit in Seattle. I've been lucky enough to have been able to go to most of these conferences, and it's always been an exciting week. Since I get to attend a lot of events throughout the year, I often see a lot of the information from Microsoft that gets repeated at the Summit. I'll also see many presentations throughout the year that will be presented in Seattle. Most speakers alter and enhance their sessions for the Summit, so even if you've seen a session before, you might learn something new, especially if a new version of SQL Server gets released mid year, as happened this year.

Looking back at last week, here are some of the highlights that I think are interesting to data professionals. There were a number of pre-cons this year, and 

The leadership of PASS regularly changes, and we see that again this year with three new board members starting this January. I'd like to welcome John Martin, Diego Nogare, and Chris Yates to the board, and I hope they both enjoy the experience, and find ways to make the organization better. Denise McInerney will leave the board, and we should all thank her for her service. The PASSion award winner this year is Rebert Fonseca. I don't know Robert, but I had the chance to meet him and he had quite a long list of ribbons on his badge. Congrats to him for his volunteer efforts, and I everyone, for helping to ensure that PASS continues to run a great event. 

One small note that I missed, but learned about at the Summit, is that Catherine Wilhelmsen is leaving as our SQL Saturday Community Evangelist. Catherine has done a great job, with 14 first time events, 3 new countries with events, and eleven new cities this past year. We've also made it to SQL Saturday #700, coming in March. This means we need someone to help continue to support SQL Saturdays in the future, and I'm hoping that we find someone that wants to fill this role.

The Keynotes were interesting this year. Wednesday had Rohan Kumar, the General Manager of database systems at Microsoft. He talked about SQL Server 2017, of course, and various features including the new servicing model. We saw various cloud and container advances as well as managed instances, which you can read about in Erin's post.  The most interesting thing to me was the emphasis on hybrid cloud as the marketing emphasis instead of just cloud. It has felt that for years, most of the big cloud vendors are pushing everyone to move into the cloud and buy services. However, I think many organizations don't want some of their data or applications in the cloud, but they're willing to consider other ones This view of hybrid, building systems that let us make a choice on how to deploy systems, is a fundamental change in focus, which I'm glad to see. Of course, the demo using HP Persistent Memory is pretty cool as well.

The second day looked at CosmosDB, with Dr. Rimma Nemhe. Dr. Nemhe has given PASS keynotes before and is an architect of the CosmosDB platform. This is a NoSQL system, but it's more extensive, flexible, and scalable than any others I've seen. I keep wanting to spend more time with the platform, but the keynote gives some in depth information about how the system is put together, the consistency models, APIs, etc. There was a lot to learn, lots of decisions to make, and lots of options. I'll watch this one again and make notes, and hopefully try to then build something.

The main conference had the usual mix of sessions and speakers that make for an incredibly informative and inspiring event. Lots of Microsoft session, including the new SQL Operations Studio, which is a VS Code based tool coming out soon. I've been running it for a few months, but it will be publicly released this month. Give it a try and pass along feedback. I'm interested to see how people view this tool. There were plenty of evening events, and I'm thrilled that Game Night went well again. Lots of people appreciated a quiet space to play games on Thursday night and I hope this gets expanded to Tuesday and Wednesday next year.

There are lots of SQL conferences to attend, and plenty of one day events like SQL Saturday, that can help you learn and grow your career. They're all worth going to at some point, and getting yourself recharged and inspired about working with SQL Server and data. If you get the chance, you should go one one, with an open mind, and consider the possibilities that might make your job more exciting.

The Pass Summit is the largest SQL event, and it's special since I've gone to most since 1999. I used to see lots of friends only during this event, and it was a priority. Now I see people many times during the year, but the Summit is still a special time when I meet lots of new data professionals, shake plenty of hands, talk data, and better understand the challenges many of you face. Hopefully I'll see you in Seattle, or elsewhere, next year.

Steve Jones from SQLServerCentral.com

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

SQL Clone

SQL Clone: Now supporting databases up to 64TB

Create copies of production databases and SQL backups in seconds and save up to 99% of disk space using SQL Clone. Redgate’s new tool removes much of the time and resource needed to create and manage database copies, allowing teams to work on local environments to develop, test and diagnose issues faster. Try it free

SQL Compare

The industry standard for comparing and deploying SQL Server database schemas

Trusted by 71% of Fortune 100 companies, SQL Compare is the fastest way to compare changes, and create and deploy error-free scripts in minutes. Plus you can easily find and fix errors caused by database differences. Download your free trial

Featured Contents


Name Value Pairs Table Handling

Jerome Boyer from SQLServerCentral.com

While Name Value Pairs Tables are anathema to Relational Database professionals, it is sometimes useful to consider such a structure in a production application. This article illustrates the use of User-defined Table Type to improve such handling. More »


SQL Code Smells

Additional Articles from SimpleTalk

Some time ago, Phil Factor wrote his booklet 'SQL Code Smells', collecting together a whole range of SQL Coding practices that could be considered to indicate the need for a review of the code. It was published as 119 code smells, even though there were 120 of them at the time. Phil Factor has continued to collect them and the current state of the art is reflected in this article. There are now around 150 of these smells and SQL Code Guard is committed to cover as many as possible of them. More »


From the SQLServerCentral Blogs - Implementing Temporal Tables Where You Have Existing Data

matthew.mcgiffen 73574 from SQLServerCentral Blogs

In my post about auditing tools in SQL Server I mentioned a few tools we have at our disposal for... More »


From the SQLServerCentral Blogs - Enabling the SQL Server Agent in Linux Containers

Andrew Pruski from SQLServerCentral Blogs

At SQL Saturday Holland a few weeks ago I was (surprise, surprise) chatting about containers and mentioned that I hadn’t... More »

Question of the Day

Today's Question (by Steve Jones):

What is the range of hours for the time zone offset in a datetimeoffset datatype?

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

We keep track of your score to give you bragging rights against your peers.
This question is worth 1 point in this category: Datetimeoffset.

We'd love to give you credit for your own question and answer.
To submit a QOTD, simply log in to the Contribution Center.


T-SQL Fundamentals

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2016. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

In working with a dictionary in Python, what syntax creates a dictionary, and what syntax accesses an index?

Answer: Curly braces define a dictionary and Brackets allow access through an index


In Python, curly braces are used to define a dictionary, such as this:

  disksizes = { "kb" : 2014, "mb" : 1048576, "gb" : 1073741824}

To access a value, brackets are used with an index, like this:


Try it in the REPL or a small program.

Ref: Python Dictionaries - click here

» 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 : SQL Server 2017 - Development

Delete syntax not working - hi, Here is the delete syntax but it is not working even though all the conditions satisfy. What is the issue? DELETE...

SQL Server 2016 : SQL Server 2016 - Administration

Queries are failing with below network error - We have recently upgraded ourdatabase server from Windows server 2012R2 to Windows Server 2016  and SQLserver 2014 to SQL Server...

SQL Server 2016 : SQL Server 2016 - Development and T-SQL

Correct sql for summing a group of records and giving proportion of each value across group - I have a set of records which is grouped by Regions . ie the following Africa Western Europe North America Middle East Now within each of...

Date Ranges - Simple, but seemingly impossible - Hi all, I've done a lot of research and tried so many things for around a week. I'm desperate at this...

Adding batch numbers based on row count and column values - Hi, I have to insert sales order data from a staging table to a base table where further processing is done...

SQL Server 2014 : Administration - SQL Server 2014

Encrypt a column in sql server? - Hi All, Need help in encrypting a column and share the encryption key with the person whom I want to...

SQL Server 2012 : SQL 2012 - General

SQL Puzzle challenge - Hi Experts, I am taking a puzzle challenge from a popular website. For the below scenarios,as mentioned in the website i...

SQL Server 2012 install and tuning checklist - Hello all, Would anyone have a checklist with some setting tuning and after an initial install for a clustered instance ? Thank...

Collect data en show it in a graph - Hi all, I'm not sure this is the right place for my question, but I'll give it a try: Ik looking for...

When a database last accessed (Insert/Update/Delete/Select) - Hi, I have a request to decommission one of our SQL 2012 server, it has 50 databases on the Instance, how do...

how to take backup databaseobjects(tables scripts,storeprocedure and functions etc) in sqlserver using sql scripts - Hi All,    I have one doubt in sql server . how to take Script database objects automaticaly using sql script and...

Import multiple excel files in one go - Hi all, i have around 50+ excel spreadsheets with 1 sheet in each, the same headings but varying amounts of data...

import .BCP files into sql server -

SQL Server 2012 : SQL Server 2012 - T-SQL

a sub query filter - is it possible to dynamically find the row containing the largest numeric value to return only one row from each...

CTE - Cursor - Try Catch - Hi, I am not able figure out how to catch the data conversion error in the select statement. can you please...

SQL Server 2008 : SQL Server 2008 - General

Question regarding query optimizer / query plan - Hi all, Got a bit of a theoretical question. Suppose I have a relatively complex query, involving many JOINs to other...

SQL Server 2008 : SQL Server Newbies

Initial size of data file - Good Morning Experts, If i set initial size of a data file as 700 MB, does SQL Server allocate 700 MB...

SQL Server 2008 : SQL Server 2008 Performance Tuning

CPU spike when executing a query in SQL - Hi, Our production environment recently have been witnessing spike in CPU utilization of more than 90% when executing some queries in...

This email has been sent to {user_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.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.
This transmission is ©2017 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com