Actually the problem was that in my SSIS package I had the connection names as "server.domain.com". If the connection name contains dots and dashes, then the SQL Agent will fail...

Tony,

I am not completely sure, but my guess is that the lack of extended properties on Azure might have something to do with the very complex metadata model Microsoft has...

jay-h (1/8/2013)

---

There is a LOT to be said about this.

... This is positively creepy. We can be certain that the Republican party will not let themselves be caught unprepared again...

But we all give our consent when we give out our data, right? Whether I point out on Twitter that I like white chocolate or that I bought a pink...

YSLGuru (5/10/2011)

---

sibir1us (5/9/2011)

---

Here is a nice set of reports on the Default trace: http://sqlconcept.com/default-trace-audit-documentation-and-faq%5B/quote%5D

Too bad you have to sign up for yet one more site in order to...

Here is a nice set of reports on the Default trace: http://sqlconcept.com/default-trace-audit-documentation-and-faq

Here is a more detailed article about the Default trace: http://www.simple-talk.com/sql/performance/the-default-trace-in-sql-server---the-power-of-performance-and-security-auditing/[/url]

What I know from experience is, that the easiest way to motivate someone is to acknowledge that they are doing great work. Hence, for the same salary the DBA can...

Stockholm, Sweden. We don't ride elephants, either. :unsure:

My question was to get the aggregation for every 5 rows of data, no matter how many rows there are in the table. If I have 503 records in my...

Jerry! Yes you are right! A good mentor is the best thing for a beginner DBA. I remember my first days starting with SQL Server: afternoon beer with a good...

Nice job, Barry. The secret of becoming a good DBA is to never stop questioning. (The correctly asked question contains half of the answer!)

Best regards,

Feodor

Thank you for the great article. I am sure that many will find it helpful. Recently I had some problems with my BI studio myself: I had created a SSRS...

If you would like to use the Performance Dashboard 2005 on SQL Server 2008 you will have to make the following change in the usp_Main_GetSessionInfo stored procedure.

Change the line:

sum(convert(bigint,...

Hello,

I just want to say that there is a small error in the Database Status script.

It reads:

CONVERT(sysname,DATABASEPROPERTYEX(Name,'Updatability')) AS Updatability

and it should read:

CONVERT(sysname,DATABASEPROPERTYEX(Name,'Updateability')) AS Updateability

The problem is, that 'Updateability' is misspelled,...