SQLKnowledge.com

Day by day Experience of a Microsoft SQL Server production DBA & Consultant..

Audit databases – using ddl triggers

 
As a DBA, do you ever wonder what is going inside your production database? Who is changing database schema during production time without informing you. Now, you need not to worry, you can setup DDL triggers to easily records all changes in table; like what was changed, when and by whom etc. Given is two [...]

Hot topics to work on in SQL 2008

I am working on some of following topics that are considerably new in SQL 2008. Leave a comment, if you have more topics like these or experience to share with us?
- Prepare a Audit script using SQL 2008 feature for High/Moderate/Low category servers.
- Setup a Central Management Servers
- Standardize & implement Data Collector and [...]

Common logshipping issues!

While working on SQL Server logshipping a DBA must consider following points to have log shipping setup running smoothly over a long period of time.
1. Transaction log Backup and restoration jobs should work constantly (in parallel) and if backup/restoration jobs are not in sync due to network/server or any other issue it will crash logshipping [...]

Join us on LinkedIn

It gives me immense pleasure to write that our SQLDBA group on linkedin has crossed 8000 members mark. This is a milestone as its the largest group on linkedin for Microsoft SQL server DBA’s.
Feel free to join in at : http://www.linkedin.com/groups?gid=66097
SQLDBA
Created: March 06, 2008 | Professional Organization | Members: 8,001
is a common & shared community [...]

List of Undocumented DBCC command..

List of Undocumented DBCC command..
DBCC activecursors [(spid)]
DBCC addextendedproc (function_name, dll_name)
DBCC addinstance (objectname, instancename)
DBCC adduserobject (name)
DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid)
DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag])
DBCC balancefactor (variance_percent)
DBCC bufcount [(number_of_buffers)]
DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][, dirty | io | kept | rlock | ioerr [...]

How long does a SP stay in the cache?

 As a SQL Database Developer or Administrator you must be eager to know how long does a stored procedure execution plan stay in the cache? On what basis and parameters MS SQL Server decide age of an execution plan to reside in cache?
Well the answer is, it is based on the cost factor and number [...]

Get Notification as soon as SQL Services are restarted

Being production DBA and responsible for a dozen to 100+ SQL Servers running in your organization or datacenter, Sometimes, you must be wondering that how you can make sure you are fully aware what is going when you are not at work. There is an easy way to stay in touch with your SQL Server(s), [...]

Script to find used and free space in Database files

Just imagine, you have over 100+ databases available on the server and suddenly disk space alarm hit your inbox. What will you do, storage can not be added or expended on the fly. Here is he tested script to find used and free space from SQL Server database’s data files that you can shrink to [...]