SQL 2012 MCSA

70-461,70-462,70-463

SQL MCSE Data Platform

MCSA + 70-465,70-466

SQL MCSE Business Intelligence

MCSA + 70-466,70-467

MCSE is stated to be version independent (according to video in link below from boB Taylor, but it...

Some ideas off the top of my head :-

Track I/O using perfmon.

Track wait stats from SQL perspective.

Run SQLIO to get indications of baseline I/O SQLIO Tutorial here[/url]

From the lack of...

Have you thought about putting an SSH server onto your SQL Server and call it from the UNIX box.

You can then initiate SQL exports / BCP / whatever you're...

In the absence of any additional information on your requirement, there are plenty of options for you.

For example PERL has the DBI connectivity libraries which work just fine for connecting...

SQL to check all DBs for the file. Replace the appropriate segment below with your full file path

sp_msforeachdb '

--if (''[?]'' not in (''[master]'',''[model]'',''[tempdb]'',''[msdb]'',''[reportserver]'',''[ReportServerTempDB]''))

BEGIN

use [?] ;

--print ''Working on [?]''

select

convert(varchar(15),@@Servername) as...

Take a look at [dbcc loginfo] to see where your t-log is getting caught up in terms of reuse of VLFs.

There is a really good video intro to transaction log...

I wonder are the SQL Services on the different servers running under accounts with different privileges?

If the [SQL Server] Service account has the privilege "Perform Volume Maintenance Tasks" it...

If the data (tables) were moved from living on the MDF file there is additional information stored in this file such as various metadata relating to the database as a...

I remember trying to capture this using DDL triggers but never found a way of tracking role changes, yes you can catch new login/users but roles seemed more problematic