| A community of more than 1,600,000 database professionals and growing |
| | The SQL Twilight Zone Imagine you've just returned from holiday and your data professional world is turned upside down. There's not a single SQL Server left at work, or maybe there's no job to work with SQL Server. Now, what do you do? I'm hoping that's not the case for me, as I'm actually writing this a couple weeks ahead of time. When this publishes, I'll have just returned from a holiday in Hong Kong, which I'm guessing is a completely different reality than the one I normally live and work in. I'm very excited as I've ever been, so I likely won't be refreshed and recharged after a quick, 6 day trip to the other side of the world. Hopefully I slept very little and saw quite a bit. In any case, I thought about this recently as I chatted with a few fellow data professionals that had left the SQL Server world behind. They had moved on, some with regrets, some happy, but for all of these individuals, there was no more SQL Server. In today's SQL twilight zone, imagine that you can't work with SQL Server any longer, but you do need to keep working. On which platform would you want to work? Perhaps there's another platform you work on now, or would like to work on. Maybe you'd want to move away from data and do something else? I'm also curious if some of you would be disappointed or just take a move in stride. For me, I am a little torn and I've have to think a bit more about what to do. I've worked on other platforms in the past, and would be comfortable changing if I had to. My first inclination is to say PostgreSQL, which I've always admired a bit. It felt immature back when we started SQLServerCentral, but I liked it better than MySQL. And much better than Oracle or DB/2, especially with the tooling. My other choice would be CosmosDB. I think what Microsoft is doing here is fantastic, and while there is work to be done, this is a great way to store some new data. The only concern I would have is are there enough jobs for people that work with CosmosDB? Adoption is growing, but is it enough to build a career on? I'm not sure. Perhaps, but I'd have to make that decision after more research. Let us know today. What platform would you move to, or would you leave databases? 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 ( 3.3MB) 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 | | Write, format, analyze, and refactor SQL fast with SQL Prompt Writing SQL is 50% faster with SQL Prompt. Your SQL code can be formatted just the way you like it, you can create and share snippets with your team, and with code analysis you get suggestions to improve your SQL as you type. Download your free trial |
| | 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 |
|
|
|
| | | Steve Jones from SQLServerCentral.com Continuing with his look at Dynamic Data Masking, Steve Jones looks at the masking patterns available besides the default mask. More » |
| Additional Articles from Brent Ozar Unlimited Blog When you're not sure, start by aiming for 5 or less indexes per table, with 5 or less fields each. More » |
| You need to make sure that nobody makes unauthorized changes to the metadata of your production databases. Any drift in the state of the database, from the one that was deployed, is a security issue and must be investigated. How do you make sure that the schema of the database, in the sense of the metadata, hasn’t been changed surreptitiously? More » |
| Additional Articles from SQLServerCentral.com On Monday, November 5th, 2018, the 5th annual “Seattle Freecon” (a FreeCon in Seattle for those that might not be attending a pre-con before the PASS Summit) will be held. Put on by Jason Brimhall and Wayne Sheffield, there’s a set of 6 sessions you can attend for free that day. That’s right, absolutely FREE. More » |
| Andy Warren from SQLServerCentral Blogs It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post... More » |
| Roland Alexander STL from SQLServerCentral Blogs I ran into this error recently while trying to clone a production database: Msg 2601, Level 14, State 1, LineNumber Cannot insert duplicate... More » |
|
|
| | Today's Question (by Steve Jones): Which of these are valid values for the second parameter of QUOTENAME() |
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: QUOTENAME(). 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 | Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2 Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services. Pick up your copy of this great book today at Amazon today. |
|
|
|
|
|
| Yesterday's Question of the Day |
| Yesterday's Question (by Steve Jones): I want to use NEWSEQUENTIALID() to get incremental GUIDs for my application, but I am concerned about them getting out of sequence. If my user runs the application and gets a GUID, and then runs the same application again to get another GUID, when can they not be sequential? Answer: If the Windows host restarts Explanation: The NEWSEQUENTIALID() function could return a lower value if the Windows host restarts. Ref: NEWSEQUENTIALID() - 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 2017 upgrade from 2014 with sequential numbers - Hi One of my users ran the following code set nocount on ;with R0 as(select 1 as f1 union all select 1... Finding the MIN or a group of values not used in a previous group - I have been having trouble finding anything on google because I'm not sure how to phrase the search. What I... Executing a query with highest possible priority - Is it possible to execute a particular query with high priority (meaning let it take all resources available and let... T SQL Question sd.name ? - The purpose of the code is to; Model an additional script to setthe Database Recovery Mode to ‘FULL’. Your script shall... Update and Calculate FIFO - Hi , I have a table that I want to calculate FIFO and update each price of items in table. in table... Changing 1 or + in a telephone number to the correct format - Hi everyone I have various records in a database that contain US telephone numbers in different formats. Some are correctly formatted... Memory Optimized Tables - Cross DB access - Hello, Is there a workaround to accessing a memory optimized table from another db? For a select only? DB1 -> The location... seperate data in 1 row - Hello HOw can I separate this data I have buch of emails in a row, I need to keep just one and... Importing from XML to SQL 2014 - This is my 4th day on SQL so I am a newbie. I created a query to import from an... huge free spaces in data file can make query slower? - Dear All, I need some info for the following 2 questions. Any idea please? 1. Keeping huge free spaces in the data file... Function Information - I wrote this for a user on another forum. I figured I'd drop it here too in case anyone might... Create a scalar function (or not) - I always assumed that there would not be much difference of performance between selecting a complex expression and selecting a... Error converting data type DBTYPE_DBDATE to date - Every night we run an import from an IBM Informix DB to our server via a Linked Server. A few... Re-granting Permissions - I've got a group of developers who insist of dropping a view or sp when deploying changes. For some reason... Column data type - Msg 207 Invalid column name - Hello , Can someone point me in the right direction here. I'm having a hard time figuring this out. I have a... Validate multiple fields and return string with erroronous fields - hello, I want to validate multiple fields and create a string listing the fields that are null or blank. can... Orphaned tables in sys.tables? - Why would there be some orphaned table entries in sys.tables, when those tables don't exist in the main database? How can... Best practices for avoiding "An INSERT EXEC statement cannot be nested" error? - Hello, I have a rather complex stored procedure that is used for one of our reports. We'll call it "First Sproc". Eventually,... How to get patient information, page header, to appear on second page of report - I have a report that works great except when it runs to a second page. I need to get the... The OLE DB provider "SQLNCLI" for linked server "X" reported a change in schema version between compile time - Hi , I encountered the following error mssg The OLE DB provider "SQLNCLI" for linked server "X" reported a change in schema... |
|
| 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 |
|
|