SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

My Favorites from 2018

Recently we had a webinar with Grant, Kathi, Kendra, and myself to discuss the year in review. We talked about our favorite things from the year and made a few predictions for 2019. I like to do this myself every year, usually in a general sense, looking over the entire data platform and technology world. In our webinar, Kendra asked us about some favorites, and I thought I'd look back at memorable items for me in 2018.

I was lucky to attend a number of events this year. My speaking schedule was 25 events and 37 talks, a few of them virtual events. Around this I managed to get to 4 other events where I didn't speak, 2 volleyball tournaments, and went on 5 family trips. A busy year, but with some exciting highlights. My two favorite talks were at security events in Cork and Washington DC. I had the chance to speak to a different audience about Database DevOps, and they were very interested and anxious to spread the word to their organizations.

My wardrobe didn't get quite the same upgrade as Grant's, but I did get one new shirt this year. Only one?? (perhaps more next year) Still, I had a great time at our SQL in the City Summits, which we're planning to repeat next year. Stay tuned for dates, but we'll likely run a number in the US, the UK, and one other country. Fingers are crossed as this will be a new country that I've never visited. I missed SQL Bits this year and will next year, but that's my recommendation if you get budget to attend an event. With lots of flight deals, you might even find it costs as much to go to the UK as attend one of the large conferences in the US.

I have a great job with Redgate, and I really enjoy talking about our products when I can. This past year, with the GDPR coming into enforcement, has had me focused on our Protect and Preserve area. While I enjoy talking about Database DevOps overall, I gave quite a few SQL Provision demos, which is one of those amazing products that really changes how you proceed with development. I'm hoping this is a continued area of growth, both because I like the topic and product, but also I do think we need better data handling practices as an industry. Next year I hope to do more work in this area, and add in some container talks as well. I'm also thrilled with making a difference with suggestions and lobbying for the product teams. Clone Resets and Installed Versions were two of the items I've heard from you and suggested myself that were implemented. Keep the feedback and votes coming.

My least favorite moments of the year were losses in the community. I took a moment to mention this in an editorial, at the PASS Summit, and in the webinar. I didn't know Stephen Hawking, but I do miss chatting with Tom Roush, Robert Davis, Aaron Lowe, and Naomi Williams. Unfortunately part of aging is losing friends and family. I added a section to Database Weekly for obituaries, and while I don't relish adding links, let me know if someone passes.

I'm also excited about the new version of SQL Server 2019 coming. There are some fundamental changes coming in how we might process and query lots of data. I don't know what I think of the Big Data Clusters and some other features as they'll be 1.0 releases next year, I do think that this is a shift in how we might think about SQL Server that will affect us in the next decade. I certainly am looking forward to a more robust Linux feature set as well as how containers will change the way we work. If you haven't looked at them, now might be the time to start.

Hopefully you've had a great 2018 and are looking forward to ringing in 2019 tonight. Stay safe and enjoy yourself.

Steve Jones from SQLServerCentral.com

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


The Voice of the DBA Podcast

Listen to the MP3 Audio ( 6.0MB) podcast or subscribe to the feed at iTunes and Libsyn. feed

The Voice of the DBA podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music.

ADVERTISEMENT
GDPR

How to make your SQL Server development GDPR ready

Redgate’s SQL Data Privacy Suite helps you to build a data catalog of your SQL Server estate, and put in processes to protect and monitor personal information. Find out more about how our tools help with GDPR compliance

SQL Change Automation

CI/CD  for your SQL Server database

Feeling the pain of managing and deploying database changes manually? Redgate SQL Change Automation completes your database delivery process by building, testing, and deploying the database changes you and your team check into version control.  
Try it free

Featured Contents

 

Cloning SQL Server Instances with Containers

Paul Stanton from SQLServerCentral.com

Learn how containers and WinDocks can be used to quickly provision copies of databases. More »


 

New Case Study: Ensuring HIPAA compliance with SQL Provision

New case study from Redgate. Since adopting SQL Provision, KEPRO, a leading US healthcare organization, have been able to achieve HIPAA compliance, save 15-20 hours a week in provisioning processes, and reclaim terabytes of disk space. More »


 

How to Linux for SQL Server DBAs — Part 3

Additional Articles from SimpleTalk

DBAs running SQL Server on Linux will not only need to understand SQL Server security well, they will also need to understand how security works on Linux. In this article, Kellyn Pot'Vin-Gorman walks you through several examples, explaining the permissions and ownership of files and directories in Linux. More »


 

From the SQLServerCentral Blogs - Visualizing Merge Join Internals And Understanding Their Implications

Bert Wagner from SQLServerCentral Blogs

This post is part 2 in a series about physical join operators (here’s part 1 on nested loops joins).  Merge... More »


 

From the SQLServerCentral Blogs - Quickly Compare Data in Two Tables Using CHECKSUM and CHECKSUM_AGG

david.fowler 42596 from SQLServerCentral Blogs

There are times when we need to compare two tables and figure out if the data matches. I often see... More »

Question of the Day

Today's Question (by Kendra.Little):

Which statistics may be automatically created as read and write queries run in SQL Server (assuming you have the "Auto Create Statistics" database property set to true on your database).

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: statistics.

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

ADVERTISEMENT

Microsoft SQL Server 2017 on Linux

This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Kendra.Little):

Can the CHECKDB command in SQL Server use parallelism?

Answer: Yes, if you are using Enterprise Edition

Explanation:

The CHECKDB command in SQL Server can use parallelism in Enterprise Edition. This is also true for Developer and Evaluation Edition, which have the same features as Enterprise Edition.

CHECKDB defaults to using the maxdop setting on the SQL Server instance for Enterprise Edition. Using parallelism generally makes CHECKDB faster, but it can consume more CPU when it runs.

If you want to minimize the number of cores that CHECKDB uses, you can set MAXDOP on the CHECKDB command itself in SQL Server 2014 SP2 and higher. For prior versions of SQL Server you can use Resource Governor to limit the number of cores used by CHECKDB. Trace flag 2528 disables parallel checking altogether.

Ref: DBCC CHECKDB - 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 - Administration

SQL AG Upgrade - Hi, I am looking for an advice.I am planning an AG upgrades to 2017.I read in many places that I should...


SQL Server 2017 : SQL Server 2017 - Development

Updating rows with same date and same id while loading next file(s) - could it be Merge statement? (i used it once in the past i think). - i have 2 FILES (.CSV). I am just dump loading the raw contents of each into  Table1 and Table2 staging table..  THen...

INSERT STATMENT Performance CONVERT_IMPLICT - In the following test query first INSERT statment execution plan shows implicit conversion for  values but the second one does...


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

trigger blues no primary key - I'm converting a database to sql server from sql anywhere.   The tables use a trigger to update a column that...


SQL Server 2012 : SQL 2012 - General

Total count in Paging Query taking more time - In My below paging query,taking 25 records from one lac records in just 2 seconds.But when i add TOTROWS column...


SQL Server 2012 : SQL Server 2012 - T-SQL

Recursive Parent Child Same Table - Is there a best practices way to join a table to itself for a parent child relationship? We have 2 tables...

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.
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 ©2018 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.
Contact: webmaster@sqlservercentral.com