|
|
-
|
|
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......
|
|
-
|
|
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......
|
|
-
|
|
Introduction This is a review of a tool we evaluated as a possible solution for auditing our environment. The Environment Most companies that have regulations such as HIPAA/Sarbanes Oxley compliance need some kind of audit tool that monitors activity on critical production servers. The environm......
|
|
-
|
|
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......
|
|
-
|
|
There are lot of scenarios we encounter where we need to know the value of something that was just updated – a row id, a field…the easiest and most common way to do this is to run a select statement soon after the update to get the value, but there is a simpler alternative.
Consider......
|
|
-
|
|
In the last post we looked into the needs for having a database server documented and the various components of database documentation. In this post i will explain each component and also attach some templates for your reference.The main document is as below.
· Overview
The purpose of the ......
|
|
-
|
|
One of the most tedious and necessary tasks I have been entrusted with is documenting and maintaining database server configuration. The question that came to my mind when I was assigned this task was the same as you would imagine – we have working backups, why is this necessary? There are man......
|
|
-
|
|
INTRODUCTION
One of the tips I learnt during the week long training with sqlskills.com was the possibility that updating statistics BEFORE reindexing can help cut down time taken by reindexing job. Apparently updated statistics help with performance by enabling better usage of parellelism.
SCENAR......
|
|