As a proactive DBA its one of responsibility to keep an eye on database’s growth and other file system changes for the databases hosted on SQL instance. However being busy on daily DBA tasks, its not always possible to prepare scripts or manually extract data from system for documentations & trend reporting purposes. I faced [...]
Archive for the ‘Uncategorized’ Category
SQL Server Query for Capacity Planning – SQL 2005 & 2008
Posted: 26th December 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: capacity planning, database, database details, database information, database planning, database size, db structure, growth, space, sql build, trend
8
Happy to join SQLKnowledge
Posted: 25th December 2010 by Shashikant in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: Happy to join SQLKnowledge
I have joined sqlknowledge and in addition to Deepak and other members, I will be writing about SQL troubleshooting, tips and tricks keep checking for more.. Merry Christmas
SQL 2011 Denali Basic Setup and Configurations
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: denali, installation, setup, sp_configure, sql 2011, sql dba, sql download
In continuation of my earlier post for Denali CTP1 launch, here are SQL Server 2011 setup screen prints. To begin with you can download installation media from Microsoft Link. Before you start installation, you must check system requirement and are as follows: System Requirements: Details Supported Operating Systems:Windows 7;Windows Server 2008 R2;Windows Server 2008 Service [...]
SQL Server Consolidation & Virtualization Practice..
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: DBA, hyper-v, license, sql, sql consolidation, sql cost cutting, sql p2v, upgrade, virtual server, virtualization, vmware
Consolidation by definition is the process of combining multiple SQL Server Databases & Servers running on different machines (could be geographically separated) onto a smaller number of more powerful machines in a central location. However in my opinion regarding SQL, its a process of getting organized, spending for what you need or use, and [...]
Scripts to prepare SQL Server Inventory
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: audit, authentication, collation, configuration, installation, license, MAP, page file, properties, service account, sql inventory
You never know, when you may need to rebuild a SQL sever with exact properties and configurations. Although there are dozen of 3rd party tools and software available in market to prepare enterprise level SQL Server inventory hosted in your environment like Microsoft Assessment and Planning (MAP), but keeping your own DBA script handy is [...]
Setup a low disk space alert for SQL Server drives
Posted: 21st December 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: disk alert, disk space, low disk space, space, sp_OACreate, sp_OADestroy, sql drives
This is the pretty easy and clean script that you may use to check periodically your database server drive space. You can create a job to run on hourly basis to execute this code, along with a database mail code to send you alert if any of drive has less than 15% or 20% threshold [...]
What you ‘Currently’ don’t get with SQL Azure?
Posted: 21st December 2010 by Deepak in SQL DBA, UncategorizedTags: cloud, database, sql azure, sql business, sql cloud, sql dba, sql server, sql web
SQL Azure is cloud based relational database platform built on SQL Server technology; it allows storing structured, semi-structured and unstructured data over the cloud. Behind the scene databases are hosted on cluster SQL servers, and are load balanced plus replicated for scalability & high availability purposes. Each logical Server consists of one master and N [...]
Microsoft SQL Server 2005 Service Pack 4 RTM
Posted: 20th December 2010 by Deepak in SQL DBA, UncategorizedTags: DBA, download, service pack, SP4, sql, SQL Server 2005
Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 . You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer [...]
Script to find used and free space in Database files
Posted: 2nd August 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: database, db size, dbcc, dbcc showfilestats, dbcc sqlperf, disk, logspace, shrink, shrinkfile, space, sql server
In an Enterprise world, you may be responsible to monitor 1000+ databases hosted on hundreds of SQL Server instances. On a lazy afternoon, suddenly low disk space alarm hit your inbox. What will you do, storage can not be added or expended on the fly. Here is the tested script to find used and free [...]
Audit databases – Using DDL triggers
Posted: 5th June 2010 by Deepak in Scripts, SQL DBA, UncategorizedTags: change log, DDL Triggers, DDL_DATABASE_LEVEL_EVENTS, event, event_instance, msdb, sql audit
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 [...]
