Problems displaying this newsletter? View online.
SQL Server Central
Featured Contents
Question of the Day
Redgate Data Masker
The Voice of the DBA

Favorite Cars

Ars Technica recently wrote about their favorite cars of 2019, which is an interesting list. They get to test a lot and I read their reviews to see what they glean. I love cars, and enjoy driving different vehicles, and I've owned a lot in my life. I think I've probably owned and regularly driven 30 cars since I started driving at 16. There was even a period of a few years in my life where I traded in my car for another used one every 11 months.

I do get to drive or ride in a decent number of cars as I travel regularly and do rent cars at times. In the past year, I managed to rent eight or nine cars last year, all different, though not very exotic ones. Still, it's always interesting to see how manufacturers change their designs and add technology. I've been surprised how much I enjoyed driving around a few cars, such as the Kia Soul.

This week, I'm wondering what you fellow data professionals out there like to drive. Are there any cars or trucks that you have look forward to getting behind the wheel of and puttering around? I've got a long break coming up and perhaps I'll take a few hours and go drive something around. Give me some ideas of what you like, new or old.

In my car history, I've had quite a few cars I really enjoyed. I've had 3 Isuzu Troopers over the years, all of which I liked. The two Suburbans (1988, 2001) I owned were both some of the vehicles I liked taking on trips. An old VW Scirocco in college was a great beach vehicle for me. My 914 and 911s are two I slightly regret letting go, but it was a good decision at the time. I enjoyed our first Prius, mostly because of the MPG when gas was US$4/gal, but it's not a car I look forward to driving. I would like to get behind the wheel of hybrid Toyota CH-R and see what that's like. That's not in the US, but I could try the ICE version.

My wife likes the Tesla, and I've ridden in a few. Not sure it's the car I want, but it's very interesting to drive. The idea of electric vehicles makes sense to me, and I expect to see more and more over time. Not sure if we're ready for one, but we will likely look to get another vehicle in the next 2-3 years, so maybe that will be on the short list. Let me know if you think that's a good idea.

Steve Jones - SSC Editor

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

Redgate Database Devops
  Featured Contents

Obsoleting Unused SSRS Reports

amarreddy23 from

Learn about programmatically obsoleting unused SSRS reports from your Report Server.

Translating a SQL Server Schema into a Cassandra Table: Part I Problem Space and Cassandra Primary Key

Additional Articles from SimpleTalk

As many companies consider moving data to NoSQL, Cassandra may be the choice. In this series, Shel Burkow discusses design considerations for porting a SQL Server schema to Cassandra. The first article explains the Cassandra primary key.

From the SQL Server Central Blogs - Ending My Time as PASS President

Grant Fritchey from The Scary DBA

With the end of the year, other things are coming to an end as well. Tomorrow, December 31st, will mark my final day as President of the PASS organization....

From the SQL Server Central Blogs - What I’ve learned from Groundhog Day.

Kenneth.Fisher from SQLStudies

One of my all time favorite movies is Groundhog Day staring Bill Murray. In case you’ve never watched it (and ... Continue reading


  Question of the Day

Today's question (by Steve Jones - SSC Editor):



I am writing a SQLCMD script in SSMS with SQLCMD mode. How do I turn this on?

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



  Yesterday's Question of the Day (by Steve Jones - SSC Editor)

More Delays

What happens when I run this code?

WAITFOR TIME '2020-01-10 1:13p'

Answer: An error occurs because the date is included

Explanation: The WAITFOR TIME statement only takes a time string, not a datetime. Ref: WAITFOR -

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 - Administration
BCP - Hi, I have below requirement. Please advise how to achieve that with BCP or any other tool Have Table A with 5 million records Adding few columns to Table A and those are not null column So, can we simply add these columns or we need to export data from Table A and then drop […]
BCP export/Import >> More Columns in Table than in Data File - Hi, I'm using BCP to export and import. Steps followed: Took BCP export for Table A (Which has 14 columns ) 2. Dropped this Table A and created again with one extra column. Now this tables will have 15 columns. 3. Created formatted file for the recreated table. 4. Ran BCP import with export data […]
SQL Server 2017 - Development
difference between numeric and decimal - Hello, beginner in Tsql I need help: here in one of the tables that I use, one of the fields is declared in decimal (10.5). I understand that the field is therefore decimal but what are the 10 and 5 used for ?? Thanks for your help
SQL Server 2016 - Administration
Availability groups - Hi all   Our ETL process is quite slow and we are wanting to speed it up.  I've come to the conclusion it's slow as we have to use linked servers to get to the data.  This is the current set-up:- server 1 - feed from 3rd-party application (SQL 2012 Enterprise) server 2 - mirrored […]
SQL Server 2016 - Development and T-SQL
func_GetInvoiceNumberByDocumentNumber - I'd like to re-write SELECT below without using function. It returns 19544 records. SELECT dbo.Func_getinvoicenumberbydocumentnumber(a.documentnumber) AS creditinvoicenumber, dbo.Func_getinvoicenumberbydocumentnumber(a.originalinvoicenumber) AS originalinvoicenumber, a.originalinvoicenumber AS referencedocumentnumber FROM dwdb.dbo.pc_b_customerorder_header a(nolock) WHERE Year(a.entrydate) >= Year(Getdate()) - 3 AND Substring(a.documentnumber, 3, 1) = 'R' AND Len(a.originalinvoicenumber) > 9 AND EXISTS ( SELECT documentnumber FROM dwdb.dbo.pc_b_customerorder_header b(nolock) WHERE a.originalinvoicenumber = b.documentnumber ) […]
Development - SQL Server 2014
Fifi Calculation - Hi I have below Data and i want Balance Invoices on accoun of Fifo . In case of C00220 it should return 54575  entry In case of C00575 it should return 1593 & 401  entry In case of C00576 it should return 180304  entry Code debit Credit RefDate C00220 41477 0 06-05-2019 C00220 0 41477 […]
SQL Server 2012 - T-SQL
handling Nulls in case series - Why is the "is null" throwing a syntax error?: UPDATE [GCDF_DB].[dbo].[People] SET [educationtext] = CASE [education]when 1 then 'Post Graduate' when 2 then '4 Year Degree' when 3 then 'Associates Degree' when 4 then 'High School' when is null then 'Unknown'END
SQL Server 2019 - Administration
Columnstore index to be created in Oracle - Does Oracle allow creating a Columnstore index be created on a regular, non memory optimized table? Just like it is possible to do in SQL Server.
Not an 8 to 5 employee - How can I get re-started in the world of SQL Server.  Fifteen years ago I was as a SQL Server DBA but then shifted to a career as a Storage Area Network (SAN) engineer.  I will retire soon but would love to get  involved with Databases again. I enjoy creating/managing databases and analyzing data etc.  […]
SQL Server 2019 - Development
Theoretical Question regarding Orphaned data in a Parent-Child table Relation - I am providing DDL to re-create the parent and child tables involved and the DDL is a representation of the actual 2 tables involved because I'm not allowed to post the source DDL so I altered the table names and column names so I could.  That said, this is a general purpose question that is […]
SQL Azure - Development
Dmvs to show missing indexes - Any dmvs(sripts) to show missing indexes in azure sql db?
Integration Services
Validating meta data of xls file - Hi Team, We get xls file every day with so many sheets in it. I need to validate only the sheet named with current year. In this case, it is 2020. the main issue is that the user some times add new columns and due to that package is getting failed. So I want to […]
SSIS package don't running with bat file - Hello i was created simple dtsx package for copy directory files in visual studio this package running success and working but i want to create dynamically running with bat file bat file running but can't working succes please this is my bat file data "C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTExec.exe" /F "c:\users\zen\documents\visual studio 2012\projects\LoadData\LoadData\Package.dtsx"
Design Ideas and Questions
Star Schema draft - I'm trying to figure out if this star schema works for counting the quantity of products in the warehouse for each day.  This is my schema......Are the dimension and fact tables alright?    
Buy and store desing - Hi I need to design to register the purchase and enter the products into the warehouse, make transfers between warehouses At the moment I have this


RSS FeedTwitter

This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the This newsletter was sent to you because you signed up at
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -