And this thread just keeps on keeping on... This is a pure rant, so read at your own risk. I have been involved in the interview process for a...

One of my experiences, though, is it does seem the SQL Server community is much friendlier than the Oracle community.  Not to say there aren't helpful people out there,...

It's been a while, but I'm pretty sure that NOLOCK was only a table hint in 2005, not a query hint. That means you can't use it in plan guide...

It is "safe". However, sometimes, I have had issues uninstalling older versions. 99% of the time, it'll just uninstall and you'll be good. Go for it. Just... if you hit...

I am not an RDS expert. However, according to their documentation and a web search, you can. Use this command and change the database name:

exec msdb.dbo.rds_restore_database...

I just installed the SQL Server 2019 Developer Edition on my personal laptop. It shows that ssdt version 16 is present within the visual studio Suite but I cannot...

A view is just a query, not a table (except in the case of indexed views, but you can't add data to them directly). No data is stored in...

First page that comes up in a search for "sql server backup" is this one. It includes this quote:

If you restore an older version database to SQL Server 2017,...

I'd rephrase that question, "Is SQL Server the best RDBMS for the job at hand?"

The fact is, SQL Server is faster than Oracle and supports larger databases... depending on how...

Please don't post the same question in multiple forums. It leads to all sorts of confusion. I've answered your question over here. I'd suggest we focus all the conversation...

No, don't change the storage to have multiple values. That will cause a million and one problems. You're talking about just a display issue in the results. That is best...

Everlasting Glory!

Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors of...

For containers, I feel it is more a developer thing, that makes their development platform easier ,quicker, portable. For production environment, for DBA to maintain, are we going to...

I forgot all about Linux (as I sit here working with Linux containers). Yeah, that's another thing, if you need it, that could certainly lead to 2017 over 2016.