SQL Server DBA Quiz on BeyondRelational

Friend of my mine and fellow MVP Jecob Sebastian is running SQL Server DBA Quiz 2011 on his community web site – BeyondRelational.  He asked me to submit question as a Quiz Master, so, here is my question for you all :

You have an SQL Server Integration Service (SSIS)  installed on some machine and you have client tool installed on your local desktop, when you tried to connect to the machine you have SSIS service running on from your local desktop you will get an error “RPC server is unavailable”

You will have to let us know what the root cause of this issue and how to resolved it.

Know the answer already?

Click Here to Submit an Answer

-- Hemantgiri S. Goswami (http://www.sql-server –citation.com )

Read More

MVP Again year 2011

Hi,
 

I have a good news to share with you all - my MVP award is renewed one more time, this is the 4th year of receiving this prestigious award (2nd time in the row) . As you all aware MVP award requires renewal every year. On the 1st of April I received from Microsoft which reads: 

Read More

Download SQL Server Training Kit

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 of Microsoft SQL Server Developer Training Kit which has

• # 31 Presentations (includes Slide decks, videos and transcripts)
• # 27 Demos (includes installer scripts, videos and transcripts)
• # 12 hands on labs (includes installer scripts)

The main highlight of the updated version is – BI Solution, yes you read it right. The version of developer training kit has the units for BI Solutions like:

• Build your first Microsoft BI Solution with SQL Server 2008 R2
• Introduction to BI Modelling Techniques

And all of this are free!!
Download the updated version of SQL Server Developer Training kit from here –> http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d
You may want to check the complete list of what is included in SQL Server Developer Training Kit and System Requirements before you begin download. 
Regards
Hemantgiri S. Goswami

Read More

Download Section for Script and free ebook

Dear Readers,


Good News!!


I have created a new section on this site from where you can download various scripts I have created and uploaded on my community website. Currently you can download scripts for:

• To Find Missing Index
• To get various SQL Server Property details
• To search a given word from a string
• Script which will take backup and verifies the backup set as well
• Script which will give you an idea on how to perform transaction in smaller chunks

You may find them all at http://www.sql-server-citation.com/p/downloads.html, and I promise that I will surely upload some more scripts in coming future.

Regards
Hemantgiri S. Goswami | http://www.sql-server-citation.com/

Read More

welcome 2011

Dear Readers,

Wishing you all very happy and prosperous new year, may the new day bring you joy and happiness

Read More

Community Techday | Surat | 28th November 2010

We are very pleased to announce Community Techday at Surat on 28th November 2010. We try to bring you the new products 

SQL Server is very popular and widely used RDBMS system in the SME and large Enterprises segment around the world for storing and managing their business critical data. Numerous applications are developed today with n-tier technologies, but they can be never be without database behind it. Recently Microsoft has announced the new version of SQL Server - SQL Server 2008 R2.

SharePoint 2010 is the business collaboration platform for enterprise and the web, Sharepoint makes it easier for people to work together. One can setup websites and manage their documents with few mouse clicks!!!

Windows 7 is a cool new version of Microsoft Windows for personal computers, including home and business desktops and laptops.

During this event we will learn the new features that are introduced with the new version of SQL Server 2008 R2, Sharepoint 2010 and Windows 7.  I would request you to kindly mark your calendar for Community Techday, 28^th November 2010 in Surat.

You will have to visit the home page or the event page of the Surat User Group and get yourself register for free!!

Note: Feel free to share this detail to your friends and colleagues, Community Techday is the free event you don’t have to pay any fees to attend this event.

Read More

What is new in SQL Server - Denali

Dear Readers, I have a great news to share with you all!! 


A much awaited future version of SQL Server is announced - "Denali". This version has some new salient features like:

• SQL Server AlwaysOn -  A new feature that will provide maximum uptime with simplify HA deployment, this feature will also supports new availability group option to improve availability of mission critical databases by supporting multiple secondary servers.
• Column-Based Query Accelerator -  Increase query performance by ~10x 
• IT Administration - Enhancements in server roles to manage separation of duties, and auditing will be available for all the editions.
• Beyond Relational - FileTable, 2D Spatial support 
• Juneau - A tool for Developers : Developers can easily work using new tool "Juneau", this will help developers to developing databases, BI and web solutions. It also provides environment for Declarative Database Definition, Dynamically Editing Existing Database
• BI Enhancement: Drag and Drop interface
• Analytic Enhancement: Analytics performance can be enhanced from the desktop to data center through in-memory column store technology
• Data Integration Management: Denali introduces two component - Data Quality Services for knowledge driven data cleansing and Impact Analysis and lineage which will ensure that the right data is delivered to the right users and the right time.

You may find more information at http://www.microsoft.com/sqlserver/en/us/product-info/future-editions.aspx and if you like to review the new version of SQL Server you may, download Denali at - http://go.microsoft.com/fwlink/?LinkID=205500&clcid=0x409

Read More

How to Upgrade SQL Server

Couple of days back I have wrote an article on common issues we face while upgrading, and two methods to follow while upgrading SQL Server, this article also gives you some basic steps we need to follow post upgrades.  Here is an excerpts of the article:

Upgrading the SQL Server version can have a major impact the applications using the databses. For example, from SQL Server 2005 onwards you are required to use  col IS NULL instead of Col = NULL and so any applications using the later will break. Using  Upgrade Advisor for SQL Server is a good start for any SQL Server however we still need to address the entire  process of upgrading SQL Server to a new version. So What is the process  we should follow while upgrading SQL Server? Read full story....

-- Hemantgiri S. Goswami | www.sql-server-citation.com

Read More

Download free eBook on SQL Server 2008 R2

In this quarter Microsoft Press has gift a free eBook on "Introduction to SQL Server 2008 R2", a book written by Microsoft SQL Server MVP Ross Mistry and Stacia Misner.

This book has 10 Chapters and 216 pages which covers

• Enhancements in SQL Server 2008 R2
• Multi Server Administration
• Data Tier Application
• HA and Virtualization Enhancements
• Server Consolidation and Monitoring 
• Data Warehousing
• Master Data Services
• Event Processing with StreamInsigh
• SSRS Enhancements
• Self-Service Analysis using PowerPivot

Isn't this list looking great? I just have downloaded this book in PDF format, alternatively you can download this book in XPS format as well.

Read More

TechEd on the road, Surat - Great show

Microsoft has organized TechED India 2009 at Hyderabad in the month of May during 13th to 15th. This was a biggest community event for IT professionals and Developers from all over country, and was big success and User Group leads of various cities have been asked to organized similar events in their cities, Surat was among those 10 cities.

Surat had its first TechEd event on 28th June 2009, and was organized by Surat User Group (IT Pro community) in association with DotNetChaps (Developer community). The event was organized at Umra Police Station auditorium and 150+ participants were registered for the event. You can see the event photographs

We had 80+ attendees inspite of heavy rain in the morning, we've got a mix of students, developers, IT Pro and lecturers from various institutes. We had 5 speakers who delivered power packed sessions on new technlogies, I spoke on ROW/Page compression in SQL Server 2008 and Virtualization 360 , Mrityunjaya Kumar spoke on Silverlight 3.0 and Windows 7 for Developers, Dhaval Faria spoke on What's new in .Net framework 4.0: VS 2010 and Aviraj Ajgekar spoke on Windows Server 2009 RC2.

It was really nice experience for me, all the technical sessions has got 4 out 5 rating and participants suggested to have more events in the future.

Let me say my thanks to our sponsors Microsoft, SQLPASS, UG Support Services, SolidQ Mentors, Sharma Infoway and XCellence-IT for their support, I would also like to thank Bhavin Gajjar | DotNetChaps lead for his support in organizing this event.

Read More

TechEd - TechEd on the Road, Surat - 28th June 2009

Microsoft has organized Tech-ED India 2009 at Hyderabad in the month of May during 13th to 15th. This was a biggest community event for IT professionals and Developers from all over country, this event was big success.
To continue spreading knowledge and educate IT community, Microsoft in association with SQLPASS, Culminis and Ineta has asked User Group Leaders of various cities to organize mini version of Tech-ED “Tech.Ed on the Road” . TechEd on the Road will be held in 9 cities of India during the Month of June and Surat is one of those cities where TechEd on the Road to be organized on 28th June by Surat SQL Server User Group and DotNetChap. It is a great opportunity for Developers, IT professionals, Students to know about trend of IT and upcoming technologies from Microsoft.

We SQL Server User Group and DotNetChap feel immense pleasure to bring you the Mini TechEd - TechEd on the Raod, Surat event for IT Professionals, students and End User has lots to get back from this event in terms of Technical know how! There are mainly two tracks for this event Developer and IT Pro track.

This event is open to all and is free; the only thing required is to get your self registered for the Mini TechEd - TechEd on the Road as we have limited seats available.

To know about the Agenda and Speakers, click here

--- Hemantgiri S. Goswami | Surat SQL Server User Group Lead

Read More