Learn SQL Server 2008 from Microsoft

Since some times their is a discussion on what's new in SQL Server 2008, when the reference material will be available!! Here is an answer to this, Microsoft has introduce a course at its E-Learning, the course aims to educate IT Professional who has prior experience working with SQL Server. Microsoft has made learning SQL Server 2008 easy by offering e-learning course, the course is devided into three category: Enterprise Data PlateformBusiness IntellegenceDatabase Developementmore details on this course is available here, all you need...

Read More

Some Tips for Merge Replication

* SQLAgent service should run under same domain account, which has local admin privilege and “Log in as a service” permission. This requires on both the server. In case, if SQL Server is not part of any Domain. We can use the user account which has identical name and password at servers i.e. ReplUser on SRVA with password ReplUser! and identically ReplUser on SRVB with password ReplUser! * User account that is used to run the SQLAgent services have to have sysadmin privilege on both server, and it should be added in to db_owner fixed...

Read More

Estimating the size of Table

Many time it happens we were wrong with the Estimation of Table Size, wrong estimation of Row Size can trouble us with the growth of the database and ultimately we are ending up with the space crunch, and all this because of wrong Estimation of Table Size. So what we should consider the most with Estimating Table Sizing!!! Nullbitmap is the most important criteria here to take into consideration whenever you do a Estimation of Row Size, here is an excellent article on Row Size Estimation http://msdn2.microsoft.com/en-us/library/aa933068(SQL.80).aspx...

Read More

Tuning Stored Procedure

Most of the time I come accross the thread wherein user has requested to get started with stored procedure performance tuning , so here are some good reference material for tuning stored procedure and optimize stored procedure for performancehttp://www.sql-server-performance.com/tips/stored_procedures_p1.aspx, http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/performancetuningstoredprocedures/2505/ and http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1247499,00.ht...

Read More

Automate Profiler Trace

The question I recently come accorss on SQL Server Performance, the OP was asking on "How to automate profiler trace" , their are system stroed procedure that can be used to automate profiler trace. The system stored procedure you can use are sp_trace_create,sp_trace_generateevent,sp_trace_setevent,sp_trace_setfilter and sp_trace_setstatus. Here is complete procedure described on "How to automate profiler trace" , refer http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htmHere is a link on "How to monitor trace on SQL Server...

Read More

New KB articles are added for SQL Server 2005

New Knowledge Base articles are added for SQL Server 2005, Here are the linksFIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005FIX: You receive an incorrect result when you use a SQL Native Client provider to read the data on the client computer in SQL Server 2005How to enable the SQL Server 2005 Integration Services process to generate a dump file when the process experiences exceptionsFIX: Error message when you run...

Read More

Renaming SQL Server that hosts Reporting Server

Sometimes business demands or change in naming convention for servers lead to situation where one should change / rename the Server running MS SQL Server, it would not that panic renaming SQL Server as you have sp_dropserver and sp_addserver to help you, but what if this SQL Server box have reporting server too; well microsoft has workaround for it refer - http://technet.microsoft.com/en-us/library/ms345235.as...

Read More

Devcon2007 - A great Success

Hi All,I am too glad... DevCon 2007 organized pune has great success, over 1100 attendes was recorded for this event. I thought this would the highest number of audiance till date , it includs IT professionals and students.Special thanks to all energetic members and volunteers of Pune User Group members and MSP(s) who has played key role in this succes...

Read More

Resource for new SQL Server DBA and beginners in SQL Server

"Give me some good resource that I can refer as new dba or beginner or new learner " this is the question asked by beginners and new learners in various forums I participate, thus I decide to post a blog referring the same, they are:Here are some good resources for SQL Server beginners and new DBA(s) http://www.sql-tutorial.net/http://www.firstsql.com/tutor.htmhttp://www.w3schools.com/sql/default.asphttp://www.academictutorials.com/sql/http://www.developer.com/db/article.php/718491SQL Server Administration and best practicehttp://vyaskn.tripod.com/sql_server_administration_best_practices.htmhttp://vyaskn.tripod.com/sql_server_2000_fast_answers.htmhttp://vyaskn.tripod.com/sql_enterprise_manager_or_t-sql.htmhttp://www.sql-server-performance.com/self_taught_dba.aspAlso...

Read More

DevCon - 2007 Organized by Pune User Group

Pune User Group has organized an event “DevCon “ in the month of August, the details and for Entry passes check your nearest location on websitehttp://devcon.puneusergroup.or...

Read More

Download System View Map for MS SQL Server 2005

Download the System View map for SQL Server 2005, this would definately helpfull to DBA(s).http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4480-8a8a-b405e32f4368/SQL2005_Sys_Views.p...

Read More

Webcast on Reading Execution Plan and Query Tuning

http://www.microsoft.com/india/webcasts/default.aspxAug - 28th ; 14:00 - 15:30 ISTSQL Server 2005: Reading Execution Plans The toughest part of analysis of any query is reading the execution plans. Many see this as the most difficult part, but this webcast removes this myth. We will walk you through the various operators and what they mean in the actual reading of the execution plan. There are some small changes made between SQL Server 2000 to SQL Server 2005 and we will take a quick at the same too.Speaker: Vinod KumarAug - 28th ; 14:00...

Read More

hotfix or SP stops unexpectedly on SQL Server 2005

SQL Server 2005 Cluster which has many instances or contain many nodes may gives you error while upgrading it with hotfix or service pack; the simple procedure to update hotfix and sp has been given by Microsoft, read more on KB 9364...

Read More

Failed to connecto to SSIS

Sometimes we receive "SSMS failed to connect to SSIS on client machine", Microsoft has released KB 940232 for the workarou...

Read More

Timeout occured while running dbcc freeproccache/alter database/sp_configure/sp_detace_db

Some of us might have face timeout when we run DBCC FREEPROCCACHE, Alter Database, Restore Database, SP_configure or sp_detach_db ; Microsoft has released KB 925419 which has workaround for the proble...

Read More

Disaster Recovery Articles on MS SQL Server

Here are some good Disaster Recovery articles on MS SQL Serverhttp://support.microsoft.com/kb/3077...

Read More

TechMela 2007 is here!

TechMela 2007 is a first of its kind technology Mela in India. Erstwhile we had TechEd for developers, ITPC for IT Pros, IndiMix for designers and MEDC for Mobile and Embedded Professionals. Each of these events used to happen at few chosen cities. Now with this new event, it will be one place for 4 days! details at www.techmela.comread more | digg sto...

Read More

Feature Pack for SQL Server 2005

Have you downloaded stand alone value addition packages for SQL Server 2005 like Best Practice Analyzer,Performance Dashboard etc. ? Here is a link where you can find this all http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=...

Read More

ELSASOFT giving out SQLSPEC for FREE to MVP

Dear All MVP(s),SQLSPEC is a software that helps DBA(s) to document Database Objects, It is a tool from Elsasoft LLC; they are giving out SQLSPEC for free to MVP(s) and significant contributors to SQL Server Community, drop a mail to sqlspec@elsasoft.org, with below information Your full name Proof of your contribution to the database community Proof of your Microsoft MVP, Microsoft MCT, or Oracle ACE status if applicableThere's more detail here: http://www.elsasoft.org/mvp.htmYou may also have a look at Software Spotlight at...

Read More

What is a Log Shipping?

High Availability is a hot topic today and need for a business critical applications, as a DBA we always try to cope up with such situation where High Availability and Continuity comes into picture their are technologies that you can use for; Log Shipping is one of them.Have you ever had a chance to set up Log Shipping? What are the benefits of using Log Shipping over Clustering or Replication? How ever it *depends* upon your environment and requirement at given time. Refer below link for Log Shipping...Log Shipping Artic...

Read More

What is Log Shipping?

What is Log Shipping? Log Shipping is one of the solutions for High Availability for business critical application. Log Shipping is first introduced in SQL Server 7.0. Log Shipping; as name defines does the shipping of Transaction Log to another server; it does exact replica of the database; it does backup of Transaction Log and restores it on a Secondary /Stand by Server which keeps database on secondary server in sync with the database on Primary Server. In case of failure work loss happens only for the time being copy of T-Log backup...

Read More

Logging and Data Storage Algorithms in MS SQL Server

Ever wonder how SQL Server Logs data in T-Log and Data Files? What algorithm it uses!!! What is ARIES (Algorithm for Recovery and Isolation Exploiting Semantics), refer Microsoft Knowledge Base Article http://support.microsoft.com/kb/230785 which gives the complete details how it works!! With the detail explanation on each steps and term...

Read More

Do Win a Lottery - Money from Microsoft

Hi,Now a days I have seen too many emails in my inbox fwd by friends and unknown persons claiming that THEY WON $$$$$ BECAUSE THEY FWD THIS TO THIS MANY PEOPLE, SOME ARE ASKING FOR ADVANCE MONEY TO GET YOU MORE MONEY and this type of emails are fake / fraud emails don't ever forward them and do not believe in this kind of emails. This is now confirmed by Microsoft Officials so ignore this type of emails and don't ever believe on it. Refer below link for morehttp://blogs.msdn.com/securitytipstalk/archive/2007/03/09/did-you-win-the-microsoft-lottery.aspx...

Read More

Download free Database Tools

At times we need to analyze the Size of the Database, or have to search the Object or Content in the Database, we always query system tables or create a script for self and some times we uses sp_depends,Query Analyzer and EM or SSMS but it has some limitations. To reduce this effort we often try some third party softwares and we know that they comes at cost. Mohamed Bouarroudj of  SQLDBTOOL has 3 software to help us out and yes they are FREE!!! There are 3 tools he has developed SQLDBDiff, SQLDBSearch and SQLDBSize. 1....

Read More

Index Defregment Best Practice

Here is the best article on Index Defregment Best Practice published on Microsoft Web Site http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspxHemantgiri S. GoswamiMicrosoft SQL Server MVPTechnorati Tags: Microsoft, SQL Server, Index Defregment, Best Practicepowered by performancing firef...

Read More

Place where I Live

...

Read More

Difference between Stored Procedure and Function (UDF)

Functions can be used with Select statementNot returning output parameter but returns Table variablesYou can join UDFCan not be used to change server configurationCan not be used with XML FOR clauseCan not have transaction within functionStored Procedurehave to use EXEC or EXECUTEreturn output parametercan create table but won’t return Table Variablesyou can not join SPcan be used to change server configurationcan be used with XML FOR Clausecan have transaction within ...

Read More

New Version Microsoft SQL Server 2005 SP2 and Books On Line release

New version of SQL Server 2005 SP2 & SQL Server 2005 Books Online (BOL) released and now available at http://www.microsoft.com/sql/sp2.ms...

Read More

Disappearance of Jim Gray

Hi,If you are participating in community activity regularly you must aware of Jim Gray a great guy, he is disappear near Farallon Islands: Help searching Jim Gray, a known Database Guruhttp://blogs.msdn.com/dtjones/archive/2007/02/03/how-you-can-help-in-the-search-for-jim-gray.as...

Read More

Remote Deployement of SQL Server

Hi All,When it comes to deploying a SQL Server Remotely with Sharepoint service, we just think and search around to get the answer how do i?!!!Here is a very good article on the Remote Deployment of SQL Server with Sharepoint Services, Refer http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsc02.mspx?mfr=true for more.RegardsHemantgiri S. GoswamiMicrosoft SQL Server MVP"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"Disclaimer: This postings is provided "AS I...

Read More

SQL Server : TO Blob or Not

Hi All,In many community forums i participated i found many users ask a querstion on BLOB datatype. That is "Is it okay if i do store binary files / images / documents store in SQL Server Database?" . The answer is no.....it is always good to store the location of the Binary Files or Documents Or Images and let it handled by Front End application. Here is a wonderfull research paper published on Microsoft Site http://research.microsoft.com/research/pubs/view.aspx?msr_tr_id=MSR-TR-2006-45RegardsHemantgiri S. GoswamiMicrosoft SQL Server...

Read More

New Year Gift from Microsoft

Hi All,I am honored Microsoft Most Valuable Professional in Windows Server System - SQL Server Competency for year 2007. A wonderfull gift from Microsoft.Hemantgiri S. Goswa...

Read More

"Katmai" - Next Version of SQL Server

Hi All,Microsoft officials has announced in their blog at ZDNET website, They code name it "Katmai" that would be next version of Microsoft SQL Server and that's not just a SQL Server but more then that. Read more on it http://blogs.zdnet.com/microsoft/?p=217RegardsHemantgiri S. GoswamiMicrosoft SQL Server MVP"Humans don't have Caliber to PASS TIME , Time it self Pass or Fail Humans"Disclaimer: This postings is provided "AS I...

Read More

Disclaimer

This post confirms my ownership of the site and that this site adheres to Google AdSense program policies and Terms and Conditions -- Hemantgiri S. Goswami...

Read More