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 ‘Uncategorized’ 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 [...]
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 [...]
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 [...]
Welcome 2011
Posted: 31st December 2010 by Hemantgiri S. Goswami in UncategorizedTags: Hemantgiri S. Goswami, join, Knowledge, sql, SQL Server MVP, Welcome 2011
Greetings!!! Myself Hemantgiri S. Goswami, SQL Server MVP, I am extremely happy to join SQL Knowledge as an author again. In coming days I will be actively sharing an articles, scripts and tips here. I would like to thank Deepak for inviting me to be a part of SQL Knowledge once again.
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 [...]
