By my understanding in this case most of the post migration tasks does not need to be performed. Because the versions stay the same all indexes, statistics and usage stats...

Btw: if you need to fill non-matching rows using information from other (previous) rows, take a look at the LEAD and LAG functions. This article on DatabaseJournal.com has a...

I've completed your query sample to include the filling of the tally table.
From your sample I notice a few mistakes. First you need a RIGHT outer join instead of...

Like Thom said already, it is quite possible to create such a view.
To select such a result I suggest to use a tally date table. Such a table...

I have modified my previous query a bit. The query below displays ALL deny permissions in the database and shows to which account or role it is granted. The last...

Being an invisible DBA is the goal for everyone who want's to be pro-active instead of re-active. A pro-active approach also saves time which can be used for the more...

removed this post
it was a remark that was already clearly mentioned in the original post :Whistling:

I suggest to build a new SQL instance in a VM. Next set the instance specific settings (like sys.configurations kind of stuff, but also LOGINs and server-level permissions) to the...

It has been a while when I created the script below together with my co-worker. We used it to forecast growth of disk usage of which the measured values were...

Lynn Petttis has an article about common date routines:
http://www.sqlservercentral.com/blogs/lynnpettis/2009/03/25/some-common-date-routines/

The query below shows some (date/)time manipulations. Each column in the query is part of...

If you manually run a package from within Visual Studio (or SQL Server Data Tools) the execution is done in debug mode. Even after all tasks are finished the execution...

N.B. (12/16/2016)

---

First I want to apologize - this entire situation is the vendor's fault, and not something we can change.

I have a table where, depending on the value in one...

I'm not able to test because I don't have a computer at hand.

But is the 'testuser' account added as a user account to the test database?

Second I suggest...