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 [...]
Archive for January, 2011
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
2
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 [...]
