On any given production environment a SQL DBA must follow set of best practices to ensure smooth and highly optimized databases availability. Here are few common mistakes that I have identified and would recommend to fix if you have encountered or seeing anything similar. 1. Not preparing and validating a reliable backup and recovery policy [...]
Archive for the ‘SQL BI/DW/SSRS’ Category
What are the common SQL DBA mistakes?
Posted: 21st March 2011 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL DevTags: backup and recovery, common dba mistakes, deepak kumar sql dba, sql dba mistakes, SQL DR Solution, sql proactive monitoring, SQL profiler, sql service pack
3
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
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 [...]
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 [...]
Opportunity to write about Microsoft SQL Server
Posted: 21st January 2011 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: deepak kumar, sql knowledge, sql server, write about sql
Do you have something to write about SQL Server that can help SQL community by your learning, innovation. R&d, research etc. This is an unique opportunity to reach a large group of SQL Server users, gain experience as SQL writer, publicity and much more. Drop an email with your content/summary to dk@sqlknowledge.com I will review [...]
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
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 [...]
