Category Archives: SQL Server

SQL Server 2008 R2 Airlift Event

Dear Readers,

During my Seattle visit I got a chance to attend the Microsoft SQL Server 2008 R2 Airlift event and it has covers the below topic.

The event was fantastic and very knowledgeable. I would like to thank all the Microsoft Program Managers who has given their best to us.

Event has captured the below topics and I will do my best to share the SQL Server 2008 R2 and New feataures.

1. SQL Server 2008 R2 Application and Multi Server Management
2. Managed Self Service Business Intelligence (Reporting Services)
3. Managed Self Service Business Intelligence (Analysis and PowerPivot)
4. Managed Self Service Business Intelligence (Microsoft Office and SharePoint)
5. SQL Server 2008 R2 Master Data Management

Script to Unlock SQL User account

Leave a reply

Easy way without passing Password to unlock SQL user account is just check/unchecked Password policy check box.
USE [master] GO ALTER LOGIN [Jugal] WITH CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO ALTER LOGIN [Jugal] WITH CHECK_EXPIRATION=OFF, CHECK_POLICY=ON GO

Insert Extended Characters into a SQL Server Table Using OSQL and T-SQL

Leave a reply

Dear Readers,

You can read my artilce on MSQLTips.com. Please follow below link.

http://www.mssqltips.com/tip.asp?tip=1953

Thank You,
Jugal Shah

Database Migration Checklist

Leave a reply

Dear Readers,

You can read my artilce on MSQLTips.com. Please follow below link.

http://www.mssqltips.com/tip.asp?tip=1936

Thank You,
Jugal Shah

From Author’s desk

Leave a reply

Dear Readers,

First of thank you very much for reading this blog

I hope this blog will help you in clearing your interviews, daily database issues and will enhance your knowledge.

As you aware WORDPRESS is not supporting Google Ads until you purchase its domain rights due to security reasons.

To earn some money by using Google Ads I have started blogging on BLOGSPOT.COM and the URL of my new blog is as below. I believe I will get the same kind of support and traffic on this blog as well.

http://dbsconsultant.blogspot.com/

Thank You,
Jugal Shah