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 [...]
Posts Tagged ‘sql’
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
2
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.
SQL Server Consolidation & Virtualization Practice..
Posted: 22nd December 2010 by Deepak in SQL BI/DW/SSRS, SQL DBA, SQL Dev, UncategorizedTags: DBA, hyper-v, license, sql, sql consolidation, sql cost cutting, sql p2v, upgrade, virtual server, virtualization, vmware
Consolidation by definition is the process of combining multiple SQL Server Databases & Servers running on different machines (could be geographically separated) onto a smaller number of more powerful machines in a central location. However in my opinion regarding SQL, its a process of getting organized, spending for what you need or use, and [...]
Microsoft SQL Server 2005 Service Pack 4 RTM
Posted: 20th December 2010 by Deepak in SQL DBA, UncategorizedTags: DBA, download, service pack, SP4, sql, SQL Server 2005
Service Pack 4 (SP4) for Microsoft SQL Server 2005 is now available for download. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP4 . You can use these packages to upgrade any of the following SQL Server 2005 editions: Enterprise Enterprise Evaluation Developer [...]
Get Notification as soon as SQL Services are restarted
Posted: 17th September 2010 by Deepak in Scripts, SQL DBA, SQL DevTags: alarm, DBA, email, notification, restart, sql, sql notification, sql restarted, sql service restart, sqldba
Being production DBA and responsible for a dozen to 100+ SQL Servers running in your organization or datacenter, Sometimes, you must be wondering that how you can make sure you are fully aware what is going when you are not at work. There is an easy way to stay in touch with your SQL Server(s), [...]
List of Undocumented DBCC command..
Posted: 10th March 2010 by Deepak in Scripts, SQL DBA, SQL Dev, UncategorizedTags: buffer, cachestats, checkalloc, checkdb, DBA, dbcc, dbcc page, shrinkfile, sql, sqldba, sqlperf, update, useplan
List of Undocumented DBCC command.. DBCC activecursors [(spid)] DBCC addextendedproc (function_name, dll_name) DBCC addinstance (objectname, instancename) DBCC adduserobject (name) DBCC auditevent (eventclass, eventsubclass, success, loginname, rolename, dbusername, loginid) DBCC autopilot (typeid, dbid, tabid, indid, pages [,flag]) DBCC balancefactor (variance_percent) DBCC bufcount [(number_of_buffers)] DBCC buffer ( {‘dbname’ | dbid} [, objid [, number [, printopt={0|1|2} ][, [...]
