Got bored reading Books, PDF files, Articles, Web pages, RSS? Need a change in learning resources? Get more learning from SQL Videos & Demos! 100s of High tech videos explaining how to do, deep dives and internals. Must to watch, download for your free time! SQL Server 2008 Videos and Demos LinkSQL Server 2005 Videos [...]
Archive for the ‘Scripts’ Category
SQL Server Videos
Posted: 19th February 2011 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: SQL dba video, SQL Demo, sql server video learning, SQL Video, SQL Video tutorial
3
Tips for Backing up User Databases
Posted: 31st January 2011 by Hemantgiri S. Goswami in Scripts, SQL DBA, UncategorizedTags: backup tip, backup user database, hemantgiri, sql backup, sql server citation, sql server script
We all take a database backup as a first resort to recover from a damage may occur during the disaster, server crash, or for any other reason. To do so, we usually schedule a job or make use of database maintenance plan that perform database backup, be it Full / Differential or Log, and we [...]
SQL Server 2008 High Availability – A Book by Hemantgiri S. Goswami
Posted: 25th January 2011 by Hemantgiri S. Goswami in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: Book on SQL Server 2008, clustering, database mirroring, Hemantgiri S. Goswami, log shipping, replication, SQL Server 2008, sql server citation, SQL Server High Availability
I have no words to explain my excitement and happiness to share news with you all – my book on SQL Server 2008 High Availability is published!! I have started authoring this book in May 2010 and as the time passes and gradually I move to the final chapter of the book, I was feeling [...]
Automate SQL Server Profiler Trace Execution
Posted: 12th January 2011 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: performance tuning, proactive dba, profiler trace, query, sp_trace_setevent, sp_trace_setstatus, SQL profiler, sql trace, T-SQL
SQL profiler is an excellent tool for T-SQL query performance optimization. SQL Server Production DBA’s use Profiler to scan what T-SQL queries are getting executed inside SQL Server and what are the queries that can be filtered for further fine-tuning. SQL profiler has inbuilt scheduler for stopping a trace, but Trace Properties does not provide [...]
How to Monitor SQL Server CPU Usage and get auto alerts
Posted: 28th December 2010 by Deepak in Scripts, SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: CPU 100%, cpu usage, CPU utilization, high cpu, monitor sql cpu, server utilization, SQL CPU, SQL CPU Utilization
There are some condition & times when SQL Server CPU utilization exceeds threshold value (ex 80% or more) and stay constant even till 100% for a undefined duration. A DBA do not get notified automatically about performance degrade until its reported by application team or service desk . This usually happens when all in sudden [...]
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
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 [...]
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
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 [...]
