In today's cloud world vendor lock-in is an issue with most stored procedures being DB platform specific (MSSQL vs PLSQL vs MySQL).  Having to deploy an additional server just...

I've heard that argument before, that the database shouldn't have "business logic" in it, and I...

given that all you are storing in the @emailReportFlag variables is just the name of a database, those could just be defined as type SYSNAME or NVARCHAR(256).  I believe that...

• This reply was modified 5 years, 6 months ago by Chris Harshman.

Actually in the context of an SSIS "Execute SQL Task", the ? is valid syntax for parameter substitution.  Otherwise yes...

I'd certainly recommend against trying to restore "master" database to a different instance.  The easiest way to copy the logins is using the technique discussed in this article:

https://www.mssqltips.com/sqlservertip/3650/script-sql-server-logins-for-disaster-recovery/

There are...

Extended events will allow you to capture future file growths, but if you need to investigate file growths that have already happened, you can try to look at the default...

I think the format is case sensitive.  I tried a similar example to yours against my file server and found the format needs to be:

$FileDateCheck = Get-Date...

• This reply was modified 5 years, 6 months ago by Chris Harshman.

I don't think anyone was saying it would disappear completely, but more people over time came to realize...

I suppose one way to think about it, is to understand what types of things that SQL Server can determine it doesn't need to do.  For example, if you have...

the SQL Server engine will evaluate any condition you write in your query.  Adding extra conditions will force it to do more work.  I'm surprised to hear it causes an...

Table1 has columns col1, col2, col3, col4 (primary key is on col3 and col4)

Table2 has columns  col2, col3, col4, col5 (no primary key)

If I want to do an inner...

That's fine if that meets your needs.  With the database level information that I collect, I have a job that gathers it once an hour and stores it for analysis...

The only comment I have offhand is that I'm not sure if trying to summarize an entire day would be very useful.

For the kinds of OS level things you're trying...

I really don't understand the amount of people that haven't changed the the Catalog, nor the resistance people give. The actual migration isn't actually that hard, provided you have...

You can get SQL Server specific information from sys.dm_os_performance_counters, but that doesn't include general information like the CPU queue length.  I've found with some poking around you can get the...