Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift, Azure SQL...

Guys, you're getting this one all wrong. The...

I'd strongly recommend getting the execution plan and understanding how SQL Server is interpreting your T-SQL. That will drive you towards making positive choices in optimizing the code.

It's legal. I've seen this before. List all the tables and then all the ON clauses...

If you're using the syntax BACKUP DATABASES, unless you specify a list of databases to include or exclude (and you have to use the EXCLUDE key word), then it's backing...

Build a database that categorizes your books, movie collection, My Little Pony collection, whatever. Take the time to normalize, think about the possible reports you could run 'All science fiction...

If you connect to the server using SQL Server Management Studio, you'll see which database is offline or in suspect mode. Otherwise, you can query sys.databases to see the current...

There are a couple of small ways you can manipulate plan cache though. You can drop an individual plan from cache by passing the plan handle. You can also avoid...

I would probably look to Extended Events to track this. You'd probably need to capture individual statements. If you use Causality Tracking, you should be able to see the chain...

It is possible for the backup itself to become corrupted. I'm with Eirikur, test it on the client side first to see if they get the same issue.

GilaMonster (5/14/2015)

---

Question for the people here...

Over the years I've been very careful to keep my blog completely non-commercial, no adverts, no plugs for my company, nothing. Partially because when I...

Vyper426 (5/14/2015)

---

I Really appreciate everyone who contributed information. I must also apologize for neglecting to let everyone know the other issue that brings me such joy in this new position:...

jasona.work (5/13/2015)

---

Looks like Grant hadn't had his daily mandatory caffiene intake when he posted here:

:hehe:

On an unrelated note, does anyone here have any experience with Barracudda Networks backup appliance, both...

Paul Randal (5/13/2015)

---

It's not possible for there to be corruption in a database that doesn't get included in a backup - so I wouldn't have said that.

If you're offloading DBCC...

Jeff Moden (5/13/2015)

---

Careful now... I wouldn't ignore the elapsed time. Frequently, it's a strong indication of disk activity even if stats I/O isn't turned on to see. You...