When your "drives" are sourced from a SAN, it doesn't really make sense to split out the drives to that extreme, because all of those little drives are likely carved...

The database diagrams feature of Management Studio may seem easy and convenient, but it does have its issues and drawbacks.

If you don't have a tool already that can "reverse engineer"...

What type of ODBC connection are you using, User DSN, System DSN, or File?  What are the ODBC errors?

Good point.  I don't know whether this would work, but you could try creating a stored procedure that calls sp_update_job with the @owner_login_name parameter, and give your login permission...

Can you try to verify the actual file type before you open it in Excel?  I've seen some people do silly things like name a plain text file with an...

I'm not sure I understand the question, did you mean you want to explicitly pass in the value for this column in the INSERT statement?

If this column is defined as...

If the disk filled up because of file autogrowths, you can see the recent history of these in the default trace.  Try this script:

DECLARE @path NVARCHAR(260);
SELECT @path...

There's nothing wrong with a ZIP file, and having the pesession file that's in it is much more valuable than any pictures can provide.  Here's some clues I see with...

Offhand I see two hurdles to using a temporal table as a slowly changing dimension.  First, the related records in the temporal table would all have the same primary key...

what happens if you run a query like this in msdb?

SELECT bs.backup_set_id, bs.database_name, CASE bs.type WHEN 'D' THEN 'Database' WHEN 'I' THEN 'Differential' WHEN 'L' THEN 'Log'...

Is there a reason to have your DW landing area on a different server than the DW itself?  Could it just be a different database on the same server?

That is a bit of a loaded question, as it can depend on what types of tables and indexes you have in this database.  At a very high level you...

Have you tried using lower case?

event_data.value ('(/event/action[@name=''session_nt_username'']/value)[1]', 'VARCHAR(128)') AS SessionName,
event_data.value ('(/event/action[@name=''nt_username'']/value)[1]', 'VARCHAR(128)') AS NTName,

the attribute names may be case sensitive.

SSIS steps in SQL Agent will run as the same user that the Windows service "SQL Server Agent" is setup to log on as.  If you want to control what...

Actually, that's not quite how Access works with linked tables, unless, of course, you don't know what you're doing.  This query, run against an ODBC linked SQL Server table...