| A community of more than 1,600,000 database professionals and growing |
| | | 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.comJoin 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. 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 | | | | 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 |
| | | | 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 |
|
|
|
| | | | | Tomaž Kaštrun from SQLServerCentral.com This article shows four ways you can use when installing missing R packages for Microsoft R Services. More » |
| | 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 » |
| | 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 » |
| | 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 » |
| | 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 » |
|
|
| | | 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. |
|
|
| |
| ADVERTISEMENT | | 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) ) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Andy') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Brian') INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Steve') GO Things look good, so I now run this: TRUNCATE TABLE dbo.SalesOrderHeader GO DBCC CHECKIDENT('dbo.SalesOrderHeader', RESEED, 0) GO INSERT dbo.SalesOrderHeader (CustomerName) VALUES ('Alice') GO What is the value for OrderKey for the row with "Alice"?
Answer: 0 Explanation: 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. 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... 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... 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... 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... 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. 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... 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... 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... Trying out a trick. - 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... 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... 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 [email protected]. To be removed from this list, please click here.
If you have any problems leaving the list, please contact the [email protected]. | 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: [email protected] |
|
|
