|
|
-
|
|
I plan to write a series of posts while learning more on SQL Server 2012. The changes to set up as I observed while installing SQL Server 2012 RC0 are : 1 Pre requisites include Powershell 2.0 and .NET Framework 3.5 2 If you have Windows 7/Windows Server 8/Office 2010 it expects Service P......
|
|
-
|
|
I found an issue recently with a trigger a developer had written on a table that
captured columns updated on that table and inserted the results into another table.
We were required to do this for auditing and the table had sensitive/critical data.
When the aud......
|
|
-
|
|
Savepoints are a better mechanism than 'nested transactions' for partial rollbacks. While attempting to study this rather uncommon feature - I found 3 key definitions from Books Online.
1 “Savepoints offer a mechanism to roll back portions of transactions. You create a savepoint using the S......
|
|
-
|
|
Nested Transactions means putting one transaction inside of another – According to BOL if you have one transaction statement ‘nested’ inside another,
“ Committing inner transactions is ignored by the SQL Server Database Engine. The transaction is either committed or rolled b......
|
|
-
|
|
Problem Description
One of the biggest challenges any production DBA has is ongoing monitoring of existing processes and ensuring pro active action/minimal downtime. Monitoring replication has gotten easier with new versions of SQL Server – and the Replication Monitor put in with 2005 makes it ve......
|
|
-
|
|
Malathi Mahadevan works as
a Senior DBA with Kindred Healthcare – a healthcare services company based
out of Louisville, KY and ranked first in Fortune magazine's Most Admired Companies
"Health Care: Medical Facilities" category. She is the founder-lead of the
loc......
|
|
-
|
|
Malathi Mahadevan works as a Senior DBA with Kindred Healthcare – a healthcare services company based out of Louisville, KY and ranked first in Fortune magazine's Most Admired Companies "Health Care: Medical Facilities" category. She is the founder-lead of the local chapter of Professional A......
|
|
-
|
|
Malathi Mahadevan works as a Senior DBA with Kindred Healthcare – a healthcare services company based out of Louisville, KY and ranked first in Fortune magazine's Most Admired Companies "Health Care: Medical Facilities" category. She is the founder-lead of the local chapter of Professional A......
|
|
-
|
|
Malathi Mahadevan works as a Senior DBA with Kindred Healthcare – a healthcare services company based out of Louisville, KY and ranked first in Fortune magazine's Most Admired Companies "Health Care: Medical Facilities" category. She is the founder-lead of the local chapter of Professional A......
|
|