Saturday, May 30, 2015

SQL Server 2016 : Getting tempdb a Little More Right

 has written a nice blog post about tempdb improvements in SQL Server 2016. You can read more from

The most important feature for me is ability to configure multiple files to tempdb during the installation. Currently, you need to do this manually and restart the server which will not be required with SQL Server 2016. In the configuration it also check the number of cores and provide the guide line as well.

What is the SQL Server 2016 Query Data Store?

Query Data Store in SQL Server 2016 is intended as a service that monitors and optimizes query plans with full history of query execution. Query Data Store can help diagnose performance problems that are related to plan changes.
What it does:
  1. Stores the history of query plans
  2. Captures performance data for each query plan
  3. Identifies the most expensive queries and earmarks those queries that have degraded or gotten slower over time
  4. Gives you the ability to force old plans, should a new plan cause performance issues (almost like a system restore for Windows computers)
  5. Easily fixes plan regressions
  6. Analyzes workload patterns
  7. De-risks SQL Server upgrades with restart and failover

Read more

Thursday, May 28, 2015

Microsoft Virtual Labs for SQL Server 2016

If you want have experience about SQL Server 2016, Microsoft Virtual Labs provides it for you. There are seven labs up to now.

Microsoft Releases First Public Preview of SQL Server 2016

The first public preview of Microsoft's SQL Server 2016 database is available, and testers can opt for faster, more frequent updates to it.
Microsoft is making available to anyone who wants to kick the tires a first public preview release of its coming SQL Server 2016 on-premises database.

Read more

Wednesday, May 27, 2015

Shopping Basket Analysis in SQL Server

A famous super market chain in USA once observed that men who are buying beer for weekend tend to buy nappies for their kids. This revelation enabled the chain in increase sales volume and revenue by placing the items in close proximity to each other. An alternative approach would have been to move the items apart to encourage store exploration.
Read how to improve your sales using shopping basket analysis.

Tuesday, May 26, 2015

Support for SQL Server 2005 Ends April 12, 2016

oduct expiration is a fact of life. And, no matter how much we love a product or no matter how long we cling to its familiar interface, we eventually have to give up on it.

Such is the case with SQL Server 2005. SQL Server 2005 is the next in a running lot of product expirations, with the end of support date being April 12, 2016.  Released 10 years ago, this version of Microsoft's database product is still in use in a huge number of implementations. So, it goes without saying that, just like we've seen with Windows XP and Windows Server 2003, some organizations will have a tough time letting go.


Friday, May 22, 2015

MSSQL Server 2016 coming with JSON Support

With over a thousand votes on the Microsoft Connect site, JSON support is the most requested feature for SQL Server 2016. This month, Microsoft announced that the upcoming release of SQL Server 2016 will fulfill that request. Sort of.

Microsoft will certainly be touting this feature as an additional reason to upgrade when the time comes. Natively supporting JSON helps bridge the gap between the desirable aspects of a NoSQL database and a relational database like SQL Server. The trouble is that with this current implementation, you're not really gaining anything over what's currently available. It's nothing like the native XML data type that became available starting with SQL Server 2005.


Monday, May 18, 2015

Microsoft Releases New Version of SP1 for SQL Server 2014

The much-troubled Service Pack 1 for SQL Server 2014 has its latest revision, and allegedly resolves significant problems that made SQL stop working for numerous customers.

The service pack originally was originally released last month, but Microsoft pulled it on that same month because of an installation problem. The updated SP1 (build 12.0.4100.1) is now available at this download page, dated 5/14/2015.

More at

Sunday, May 17, 2015

How To Remove the Identity Column in SQL Server

Setting the identity property on a table when it is created is a simple task. The below snippet will create table called SampleTable with ID column which has an identity property.


SQL Server 2016 to include R

In one of the first concrete results of Microsoft's purchase of R vendor Revolution Analytics, R will be incorporated into SQL Server 2016, according to David Smith at Revolution Analytics.

Read from

Wednesday, May 13, 2015

SQL Server Internals: In-Memory OLTP

Free eBook: SQL Server Internals: In-Memory OLTP

SQL Server Backup and Restore cover
  • See how the new In-memory OLTP engine works
  • Learn how to use lock- and latch-free data structures to allow non-blocking data processing
  • Find out how to migrate existing tables to Hekaton

Wednesday, May 6, 2015

Changing the SSRS Subscription Owner

When subscriptions are created, owner of that subscription will be the user who creates it. However, when that user account is disabled, subscriptions will be failed and there is no way from the user interface to change it. However these subscriptions are stored in subscriptions table of ReportServer database (default database of the SSRS. This may be different if you have changed it from the SSRS configuration manager). In the subscription table, user id is stored as a unique identifier which you should get from the users table. Update query is shown below.

USE ReportServer


DECLARE @OldUserID uniqueidentifier

DECLARE @NewUserID uniqueidentifier

SELECT @OldUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAIN\previous_user'

SELECT @NewUserID = UserID FROM dbo.Users WHERE UserName = 'DOMAIN \ new_user’

UPDATE dbo.Subscriptions SET OwnerID = @NewUserID WHERE OwnerID = @OldUserID

No restart is of SSRS or SQL Server services are required. Soon after you update the userids subscriptions will start to work.

Is your organization ready to virtualize SQL Server?

virtualization has become a hot topic. Michael Webster is one of the authors of Virtualizing SQL Server With VMware, which guides administrators in the steps required to virtualize the popular database application. One section of the book centers on how performance of these virtualized programs hinges on proper storage architecture.Read more at

Tuesday, May 5, 2015

SQL Server 2016 public preview coming this summer

Satya Nadella, CEO of Microsoft, announced SQL Server 2016, an intelligent platform for a mobile first, cloud first world.  The next major release of Microsoft’s flagship database and analytics platform provides breakthrough performance for mission critical applications and deeper insights on your data across on-premises and cloud. Top capabilities for the release include: Always Encrypted - a new capability that protects data at rest and in motion, Stretch Database - new technology that lets you dynamically stretch your warm and cold transactional data to Microsoft Azure, enhancements to our industry-leading in-memory technologies for real-time analytics on top of breakthrough transactional performance and new in-database analytics with R integration.





Saturday, May 2, 2015

Which relational DBMS is best for your company?

There are lot of databases around you. What should I select from them. Lot of parameters you need to think. Database expert Craig S. Mullins examines the top relational database management system software to determine which best fits your organization.