SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

The Start of 2019

Happy New Year!

Today begins 2019, though it's a holiday for the majority of us. I'm certainly taking a well deserved break, as it was a busy 2018 and 2019 is likely to continue the trend. 

This year we'll get a new version of SQL Server, with quite a few enhancements that may make a difference to your organization. We've seen early versions of SQL Server 2019 out, and if you haven't had the chance to play with it, perhaps that's an item on your New Year Resolution list. If you worry about installing beta software, this is the year to certainly install Docker and get familiar with containers. 

In fact, this is the start of my 2019 learning plan. Last year I didn't do as well as I would have liked, but I did manage to learn more about Extended Events and a bit of Python, though the latter became quite rusty as my year got busy. In any case, I did spend a little time at the end of the year doing some of the Advent of Code in Python.

Containers are going to matter in the future, and certainly the developers you work with will be interested in working with them, so I'd make this a priority for most people. They take some getting used to, but it's a technology that will start to become as uqibuitous as virtualization, so spend time here.

As a side note, I'll also say that I run Docker on Windows, but I use Linux containers. I'll write about that a bit, but you should start to do the same. My plan is to rebuild an older laptop with Windows 10 and start from scratch, and I hope to document the process.

I want to have other learning goals, not the least of which is to read more technical books. I invested in a few during the Apress Cyber Monday sale, loading up on 8-10 books at a reduced price, and I want to get through them, even if it's just for fun projects. My recommendation is that you sit down and think about your career this week and make a plan. You can always change it, but start the year with the goal of learning one or two things well, set aside some time each week, and hold yourself to the plan.

I'm hoping everyone had a great and safe New Year, and I look forward to seeing some of you this year at a few events. I'm looking for a lighter schedule, but I still want to get out and speak at a few new places, so let me know if you'd like me to come to your event.

Steve Jones from SQLServerCentral.com

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

ADVERTISEMENT
RGUni

Redgate University

Self-paced online training courses with easy to follow classes on getting started, exploring advanced features, and making the most of Redgate products. Learn the fundamentals, best practices, and top tips from the experts - Redgate’s Microsoft Data Platform MVPs and engineers.
Start Learning

SQL Provision

NEW SQL Provision: Create, protect, & manage SQL Server database copies for compliant DevOps

With SQL Provisions virtual cloning technology, databases can be created in seconds using just 1MB of storage, and sensitive data can be anonymized or replaced with realistic data to ensure it is protected as it moves between environments. Download your free trial

Featured Contents

 

Generate a SSIS-package that reads from Twitter using Biml

Johan Åhlén from SQLServerCentral.com

Learn how to use Biml to create a SSIS-package with a Script component that can read from Twitter. More »


 

Real-time performance monitoring for Azure SQL Database Managed Instance

Additional Articles from SQLCAT

This article was co-authored by Dimitri Furman and Denzil Ribeiro Reviewed by: Danimir Ljepava, Borko Novakovic, Jovan Popovic, Rajesh Setlem, Mike Weiner Introduction In our ongoing engagements with the SQL DB Managed Instance preview customers a common requirement has been to monitor database workload performance in real time. More »


 

Update an Azure SQL Data Mart with ADLS files

Additional Articles from MSSQLTips.com

In this tip we learn how to update the Azure SQL Data Mart in an automated way. More »


 

From the SQLServerCentral Blogs - SSIS Catalog Automatic Log Cleanup

Tim Mitchell from SQLServerCentral Blogs

Built into the SSIS catalog is a mechanism that can automatically purge log data after a set period of time.... More »


 

From the SQLServerCentral Blogs - SQL Server Backup To Azure Storage

Arun Sirpal from SQLServerCentral Blogs

Once again I would like to share with you an article I wrote about backing up (and restoring) a SQL... More »

Question of the Day

Today's Question (by Steve Jones):

What's the database compatability version for the upcoming SQL Server 2019 Release?

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 7 points in this category: humor.

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

Design and configure SQL Server instances and databases in support of high-throughput applications that are mission-critical and provide consistent response times in the face of variations in user numbers and query volumes. Learn to configure SQL Server and design your databases to support a given instance and workload.

Pick up your copy of this great book today at Amazon today.

Yesterday's Question of the Day

Yesterday'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).

Answer: Single column statistics

Explanation:

"Auto create statistics" allows SQL Server to automatically create single-column statistics as queries run in SQL Server.

When you create an index, statistics related to the index are created at the same time (as part of the creation). That's different, it isn't triggered based on read and write queries using the table.

If you want multi-column statistics that are not related to an index, you’ve got to create those manually.


» 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 2016 : SQL Server 2016 - Administration

configuration listener alwayson in named instance - Hello everyone i have two server sql named instance I must configure alwayson between these two instances I'm blocking in the listener...

Shrink database only x gig a week. - I just added the new columnstore indexes on to the database. This saved 2 TB of space on the indexes. I like to...


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

Sample TSQL , SSIS , SSRS projects - Hi Guys, Where can I get sample projects TSQL , SSIS , SSRS projects. that I can provide for students? Thanks


SQL Server 2014 : Administration - SQL Server 2014

Permission are Getting revoked for Object - I have granted the permission to store proc to role and the user. However, after the store proc is executed...


SQL Server 2014 : Development - SQL Server 2014

SQL Grouping Output - Creating Ageing Data - Greeting! Input SQL Table Sample Output Expected.


SQL Server 2012 : SQL 2012 - General

How to change CDC Function fn_cdc_map_lsn_to_time(__$start_lsn) to return UTC Datetime - Is there any possibilities on change the Return Datetime of sys

steps for performance tuning of a sql server - Hi I just wanted steps /how to troubleshoot sql server from perfmonace point of view or which is particualr query...

Availability Groups Removed & Readded Database Problem :exclamation: - I had a bit of a server meltdown this morning that necessitated me removing one database from my availability group...


Programming : Powershell

WMI connection error using Invoke-Sqlcmd - Hi all, I'm brand new to powershell and am trying to convert an old batch script that run some sql files...


Data Warehousing : Integration Services

SSIS step to call sp proc - I have a table which has the details of all sp spoc names and executables, so I will have a...

Unable to create SSISDB -  I would like to create SSISDB but even with sa password I see the below error. I am not sure...


Data Warehousing : Analysis Services

security ? for SSAS tabular - have a ssas 2014 security ? vendor wanted connections to one of our sql servers and SSAS tabular instance. They say...


SQL Server 2005 : T-SQL (SS2K5)

Set a Variable Inside a Case Statement - I need to set a variable inside a Case that is inside a Select. I am using this is for...

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