SQLServerDBA News - 2011 Review for SQLServerDBA
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
2) Blogged...
2011-12-31
1,558 reads
2011 was a great year on a personal and professional level
1) Completed the Brighton Marathon in 4hrs 36 secs
2) Blogged...
2011-12-31
1,558 reads
2011 is nearly over. It’s time to list the Top 10 viewed SQLServer-DBA.com posts for the year , based on Views.
System...
2011-12-24
818 reads
After a server move to the failover Data Centre – a file copy between the two sites slowed down by 6x. ...
2011-12-21
653 reads
Network card teaming or NIC teaming are networking terms describing methods of combining multiple parallel network connections . The main purposes...
2011-12-14
1,733 reads
I document the CPU Count for SQL Server inventory management.
Using a powershell script , iterate through all the SQL Servers and...
2011-12-13
959 reads
Sometimes end users interchange the terms : C2 auditing and Traces.
They server different purposes.
c2 auditing records all attempts (successfull and...
2011-12-12
824 reads
I was creating a Powershell script for a SQL Server checkout procedure after a reboot , and used the state_desc column...
2011-12-09
838 reads
Latency is the time delay measure in the system. SQL Server can only be as fast as the slowest component...
2011-12-07
1,807 reads
To make the T-SQL function DATEADD more dynamic use variables. The example below , accepts an input parameter , in this case...
2011-12-06
2,312 reads
An XA transaction is a global transaction usually covering multiple resources.
Use the Microsoft SQL Server JDBC Driver to support the ...
2011-12-05
208,920 reads
By Steve Jones
vicarous – adj. curious to know what someone else would do if they were...
Say we have a database that we want to migrate a copy of into...
We are trying to get apps and users off of using SQL accounts to...
Hi I have this view to check if a job is running: SELECT...
All, if you are like me and do not care for the built-in color...
Certain internal SQL Server actions cause internal checkpoints. Which of these actions does not cause an internal checkpoint?
See possible answers