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 DBA’ 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 [...]
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 [...]
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 [...]
Download SQL Server Training Kit
Posted: 20th January 2011 by Hemantgiri S. Goswami in SQL DBATags: developer training kit, download training kit, Hemantgiri S. Goswami, learn sql server 2008 R2, sql server 2008 r2, sql server citation, sql server training
Couple of months back I have wrote a blog article about the availability of Microsoft SQL Server Developer Training Kit which is very helpful resource for the SQL Server Developers, trainers and professionals to understand the improvements comes with the release of SQL Server 2008. Recently, 18th January 2011 Microsoft has released the updated version [...]
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 [...]
What Lenovo IdeaPad Y560 Laptop Can’t do?
Posted: 3rd January 2011 by Deepak in SQL DBA, UncategorizedTags: cpu temperature, game, ideapad y560, laptop hot, lenovo, nfs, speedfan, sql
I rarely find time to play computer games, however when I do, I certainly go for Need for Speed racing game from EA. Considering high system requirements for now a days demanding games and with prime reason to run multiple virtual machines for SQL testing, I decided to go for Lenovo laptop for the second [...]
This Year, I will..
Posted: 2nd January 2011 by Deepak in SQL DBA, UncategorizedTags: learn, new year resolution, no gain, no pain, no reservation, quit, repeat mistakes, survival the fittest
As the new year begins.. What is your New Year resolution for fresh start? quit smoking or drinking? Or hit gym more often, lose weight and get back in shape? Find a new job? Save more money or get out of debt? In addition to these, If you have space left for something called “learn [...]
