Saturday, May 30, 2015
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.
- Stores the history of query plans
- Captures performance data for each query plan
- Identifies the most expensive queries and earmarks those queries that have degraded or gotten slower over time
- Gives you the ability to force old plans, should a new plan cause performance issues (almost like a system restore for Windows computers)
- Easily fixes plan regressions
- Analyzes workload patterns
- De-risks SQL Server upgrades with restart and failover
Thursday, May 28, 2015
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 http://www.zdnet.com/article/microsoft-releases-first-public-preview-of-sql-server-2016/
Wednesday, May 27, 2015
Read how to improve your sales using shopping basket analysis.
Tuesday, May 26, 2015
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.
Monday, May 25, 2015
Nice article about soft skills. Read more at http://sqlmag.com/database-administration/important-soft-skills-entry-level-data-professional
Friday, May 22, 2015
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
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.
Sunday, May 17, 2015
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.
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.
Wednesday, May 13, 2015
Free eBook: SQL Server Internals: In-Memory OLTP
- 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
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.
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.
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 http://searchvmware.techtarget.com/feature/Is-your-organization-ready-to-virtualize-SQL-Server
Tuesday, May 5, 2015
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
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.