Thanks  for your comment Paul.

Hi there,

In your opinion what would be the advantage of this R approach compared to, say, direct graph visualization with GraphViz dot command, example:
digraph STG
{
   "Kirk" -> "Scotty"
   "Scotty"...

Many successful developers and DBAs have been practicing for many years (even decades) what the media and high profile companies have been calling DevOps for mere months.
Nice.

Hi David,

Do you think it's really a good idea to have both data (primary and secondary data files) and transaction logs of tempdb in the same disk/drive letter/volume ?

Cheers,

Of course not... people are dangerous not computers or commands.

Yesterday I felt inclined, in general, to agree with you but in the particular that cannot happen because you have no idea of the context and therefore you cannot generate...

Eric's code seems cool, got to try!

1. Performance counters (OS & MSSQL in combination)

2. Red Gate's SQL Response, later, Monitor

3. SQL Server alerts, notifications, jobs, checks inspired in Brent Ozar stuff (I know, it's a wild...

Hi

Maybe I'm loosing something here, but what is the real advantage of this code against 'sp_linkedservers' ?

Cheers,

--

Paulo

Allright, I'm not the only one to think 99% of the meetings in IT World are pure waste of time and resources.

By the way, never ending meetings and Project Management...

That explains why last statement below won't work:

declare @dsql nvarchar(512) = ( SELECT TOP 1 'DELETE FROM [AdventureWorks2012].[Person].[BusinessEntityAddress] ' + CHAR(13) + 'WHERE [BusinessEntityID]='+CAST([BusinessEntityID] AS VARCHAR(50))+ CHAR(13) +...

And just for the record, it also works in SQL Server 2012 (why shouldn't it...). Had to get rid of some funky chars (most probably due to some enconding issue),...

Perry Whittle (1/15/2014)

---

Paulo A. Nascimento (1/15/2014)

---

Well if tempdb database was, say, 640 MB in size, then that would not seem strange to me :-). 64 MB is exactly exactly 10%...

Well if tempdb database was,...