Sunday, May 29, 2016

SQL Server 2016 coming on 1st June

This new version will be released on June 1st 2016.
SQL Server 2016 is the foundation of Microsoft’s data strategy, encompassing innovations that transform data into intelligent action. With this new release, Microsoft is delivering an end-to-end data management and business analytics solution with mission critical intelligence for your most demanding applications as well as insights on your data on any device.

Saturday, April 02, 2016

Microsoft SQL Server Developer Edition is now free

Microsoft SQL Server Developer Edition is now free
Starting today, SQL Server 2014 Developer Edition is now a free download for Visual Studio Dev Essentials members.


https://blogs.technet.microsoft.com/dataplatforminsider/2016/03/31/microsoft-sql-server-developer-edition-is-now-free/

Thursday, February 04, 2016

Free eBooks from Microsoft Press

Free eBooks are available in PDF, EPUB and Mobi for Kindle formats.
Find more books & eBooks at The Microsoft Press Store.

https://mva.microsoft.com/ebooks

Thursday, September 17, 2015

Linked Server Transaction error Msg 7395, Level 16, State 2, Line 273

If you are using nested transaction in your stored procedure you will get the same error. Solution to this error is to SET XACT_ABORT  TO ON;  in your stored procedure.

Tuesday, May 05, 2015

SQL Server 2016 public preview

SQL Server 2016 public preview coming this summer and most important feature Real-time Operational Analytics & In-Memory OLTP

http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx
 

Thursday, July 03, 2014

Error: 17053, Severity: 16, State: 1. Restore failed

When you RESTORE database if you see the below SQL error Operation System 112
Then you must look at the first point to have a enough disk free space on specified drive where database is going to restore.

Message
Error: 17053, Severity: 16, State: 1.

E:\MSSQL \DATA\Adventrueres.mdf: Operating system error 112(error not found) encountered.

Tuesday, February 04, 2014

Cannot open user default database. Login failed. Login failed for user 'xx'

I have been very busy for last couple of months so i could not get chance to post earlier. I hope and continue to post more technical stuff on this blog this year 2014.

If you are sysadmin, Your default database set to one of the user database. If you decide to take offline for your default database before you set default to another database.

You will get the following error.
Cannot open user default database. Login failed. Login failed for user 'xx'

There are the steps below login to server to access master database and then you can set your default database.

Issue:
1. Connected as a sysadmin (windows authentication domain\username)
2. Connect to database server
3. Take offline  your database DB_WH_Report
-- I connected
4. Disconnect to Server
When you try to connect back
Error :
Cannot open user default database. Login failed. Login failed for user 'xx'

Solution:
1. Connect to Server
2. Click Option to expand  Connection Propertise
3. Connect to Database Type master
4. Click Connect button