No, as far as I know, you can have one installation of SSRS and produce reports for all instances of SQL Server in your environment. The "price tag" of that...

As many answers are in the SQL Server realm...it depends. While the article you reference is a good example of how you can deploy SSRS in an existing clustered environment,...

Here's a good explanation of scan vs seek:
https://blog.sqlauthority.com/2009/08/24/sql-server-index-seek-vs-index-scan-diffefence-and-usage-a-simple-note/

Okay, I don't know why I didn't see this last week, but there are a number of problems with the statement you posted.
First, you have to pick which "FROM"...

Good catch Sue!!
Another thing I didn't notice before is it appears that you're trying to restore a backup for one database (DMPROD) and a log from another database (CORDDB).

What does
SELECT * FROM sys.backup_devices
return?

How much RAM is on the server? Is Max memory set on SQL Server, or is it left at the default of 2TB?
What are the IOPS of the...

Make sure there are no other connections to instance...like applications or SQL Agent (shouldn't be on, but make sure). Something else is grabbing the single connection, which is blocking your...

What do you mean by "base date"? Also, I'm a bit confused by the your question and the defined: DATEDIFF(MINUTE, 0, @t), which does get the minutes from 0 (meaning midnight) to the...

I'm pretty sure the backward compatibility is for TSQL features, not SSIS. Like jasona.work said, SSMS has never been able to connect to a previous version of SSIS, and it's...

You may have already looked into this, but I found this summary of HIPPA guidelines provided by the agency that enforces compliance: https://www.hhs.gov/hipaa/for-professionals/security/laws-regulations/index.html
I worked in a large healthcare...

Duplicate on MSDN forums: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1e5f20af-b69e-4c72-bdeb-de99d67ec949/any-simple-tool-or-query-to-find-out-all-the-tables-in-a-query-?forum=sqldatabaseengine
It doesn't appear that the OP is actually interested in an answer...

If AlwaysOn AGs are not an option, then Mirroring would be the next best thing. You can implement automatic failover with a witness server (can be a SQL Express instance)...

Here's one place to start: http://www.colinsalmcorner.com/post/install-and-configure-sql-server-using-powershell-dsc