SQLServerCentral - www.sqlservercentral.com

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

Featured Contents

The Voice of the DBA

Enjoying a Down Weekend

The Oscar nominations were released recently, with quite a few nods to The Black Panther. I did see that one on a plane, and despite the small screen, I enjoyed the story and the visual action. It's one that I may try to watch again on a larger screen at some point, likely with kids. The family is a group of Marvel fans, and while I've mostly stuck to the mainstream movies, the kids have enjoyed some of the series that complete the Marvel Universe. We've gone as a group to most of the theatrical movies, and I expect we'll see the next Avengers when it releases.

I also saw the best geek movies of 2018, most of which I had not seen. I'm more of an episodic, TV show fan, but I get to a few movies with my wife, who loves them. A good movie is sometimes a great break on the weekend from life, and I wanted to get some recommendations from others. Winter time in Colorado keeps me busy, and I love reading books, but sometimes curling up to watch a movie with the family is something I look forward to enjoying.

There are more and more movies being released all the time, of all sorts, but it seems the geek, fantasy, science fiction genre has grown quite a bit. As a kid it felt like we had few of these style movies, and settled for the comic book genre to explore amazing imaginary ideas. Now it seems between Amazon, Netflix and other major studios, there are more new sci-fi or tech films than I have time to watch.

Are there films you enjoyed in 2018? Perhaps there are a few you're looking forward to in 2019 that you await. Take a minute today and give a quick review of what you've enjoyed and what films with technology, fantasy, or just thrilling sections that you think others might enjoy on a night away from work.

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 ( 2.6MB) 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.

SQL Source Control

How to track every change to your SQL Server database

See who’s changing your database, alongside affected objects, date, time, and reason for the change with SQL Source Control. Get a full change history in your source control system. Learn more

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


Installing R packages in SQL Server R Services

Tomaž Kaštrun from SQLServerCentral.com

This article shows four ways you can use when installing missing R packages for Microsoft R Services. More »


The 2019 Data Professional Salary Survey Results

Additional Articles from Brent Ozar Unlimited Blog

How much do database administrators, analysts, architects, developers, and data scientists make? We asked, and 882 of you from 46 countries answered this year. Y’all make a total of $84,114,940 USD per year! Hot diggety. (And at first glance, it looks like on average, y’all got raises this year.) More »


Database Continuous Integration with SQL Clone and SQL Change Automation

Uses SCA to build the database and SQL Clone to distribute the finished database to the various team-based servers who require the latest build. More »


From the SQLServerCentral Blogs - Miscellaneous Notes On System Architecture and Design

MarlonRibunal from SQLServerCentral Blogs

When I first joined the programming team at my previous job in an aerospace company, the first observation I made... More »


From the SQLServerCentral Blogs - Starting a Proof of Concept with SQL Change Automation

Steve Jones from SQLServerCentral Blogs

One of the ways that you can more easily perform database development tasks is with SQL Change Automation (SCA). This... More »

Question of the Day

Today's Question (by Steve Jones):

I want to change the collation of my SQL Server on Linux. What should I do?

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: SQL Server on Linux.

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


Expert T-SQL Window Functions in SQL Server

Expert T-SQL Window Functions in SQL Server takes you from any level of knowledge of windowing functions and turns you into an expert who can use these powerful functions to solve many T-SQL queries. Replace slow cursors and self-joins with queries that are easy to write and fantastically better performing, all through the magic of window functions. Get your copy from Amazon today.

Yesterday's Question of the Day

Yesterday's Question (by Steve Jones):

I have this table in SQL Server 2017, which I create and add a few rows for testing.

CREATE TABLE dbo.SalesOrderHeader
( OrderKey TINYINT IDENTITY(1, 1) 
, CustomerName VARCHAR(30)
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy')
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian')
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve')

Things look good, so I now run this:

TRUNCATE TABLE dbo.SalesOrderHeader
DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0)
INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Alice')

What is the value for OrderKey for the row with "Alice"?

Answer: 0


If there are no rows in the table, the DBCC CHECKIDENT will reseed the identity value to 0 and this is the value used for the next insert.

Ref: DBCC CHECKIDENT - 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

I have a database whose name is Backup. - I have a database whose name is Backup. When I am running backup maintenance plan first time its failing and I...

ssrs report subscription - We have created some subscription for some ssrs reports. But recently we found the subscription has disappeared when checking in...

SQL Server 2017 : SQL Server 2017 - Development

How do I convert a uk date in string format to date? - Hi A user enters a date in uk format (i.e '24/01/2019') into a web form (.net).  I then call my stored...

Cause of arithmetic overflow error? - What is causing this error in the following code: Msg 8115, Level 16, State 8, Procedure sp_calcArea, Line 10 [Batch Start...

Purpose of SELECT before a calcuating the value of a function's return variable - In the code below what is the purpose of the SELECT statement before @SalesTaxDue = (@TaxRate * .01) * @Total?  I would think...

Can stored procedures return/output a value like a function can? - Sample code: CREATE

Unable to read the XML files using SSIS XML Source - Hi Can someone help me with why I am not able to load the attached XML file using SSIS? When I tried...

SQL Server 2016 : SQL Server 2016 - Administration

Database has no owner - I have gone into the properties of a couple of databases and noticed that under the database name the owner...

Login failed for user 'XXX\AUser'. Reason: Failed to open the explicitly specified database 'MODEL'. - I have a baffling issue that is not a problem, but creates a lot of noise from our servers.  I...

SQL Server 2008 cluster migration to SQL Server 2016 - Minimal downtime - Hi, We have an old SQL Server 2008 cluster that still runs on Windows Server 2008 R2. We want to move...

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

Pass date input parameter as float data type - Hello, I have a stored procedure that takes date as input parameter but it converts that date parameter to a float...

SQL Server 2014 : Development - SQL Server 2014

Merge Multiple Rows into a logic - Good Day, Please find below my requirement : --SOURCE TABLE CREATE TABLE .(      (20) NULL,      (20) NULL,      (40) NULL,    &nb

very slow select - Team, I have this query that runs quite a long time, actually the result is not been displayed at all.

SQL Server 2012 : SQL Server 2012 - T-SQL

Question on Grouping -Working number of days - Hi All, I am trying to work out the number of days for each (CODE) from the Code (REQUEST DATE) till...

SQL Server 2008 : T-SQL (SS2K8)

How to insert multiple records from fields in select record - I am trying to take results from multiple fields from single rows that are not null and put them in...

Programming : General

Output of stored procedure to a txt file?? - Hello, I am trying to write the output of a stored procedure to a txt file. I am unable to...

SQLServerCentral.com : SQLServerCentral.com Test Forum

Trying out a trick. -

SQL Server 2005 : Backups

RECOVERY Mode to NORECOVERY Mode - Dear all, I have one doubt/ problem.. Actually I have recovered my database without complete restoration. I have to apply another backups to...

SQL Server 2005 : SQL Server 2005 General Discussion

Excel import truncates at 255 characters - Hi Everyone, I am trying to import some product data from a xls spreadsheet (provided by an external supplier) into SQL...

Older Versions of SQL (v6.5, v6.0, v4.2) : Older Versions of SQL (v6.5, v6.0, v4.2)

SQL Server 6.5 available for download with manuals - Hi, I've eventually managed to get a copy of SQL Server 6.5 and I've made it available for download for...

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