Important Soft Skills for the Entry-Level Data Professional

Nice article about soft skills. Read more at http://sqlmag.com/database-administration/important-soft-skills-entry-level-data-professional

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.

Read more at http://www.itworld.com/article/2925117/enterprise-software/mssql-server-2016-coming-with-json-support-not-really.html

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 https://virtualizationreview.com/articles/2015/05/18/microsoft-releases-new-version-of-sp1-for-sql-server-2014.aspx

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.

Read http://www.sql-server-performance.com/2015/remove-identity-column-sql-server/

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 http://www.computerworld.com/article/2923214/big-data/sql-server-2016-to-include-r.html

SQL Server Internals: In-Memory OLTP

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

http://www.red-gate.com/products/sql-development/sql-compare/entrypage/sql-server-internals?utm_source=ssc&utm_medium=publink&utm_campaign=books&utm_content=hekaton_ebook&utm_term=freeebook

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

GO

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 http://searchvmware.techtarget.com/feature/Is-your-organization-ready-to-virtualize-SQL-Server

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.

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

 

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.

Read more at http://searchdatamanagement.techtarget.com/feature/Which-relational-DBMS-is-best-for-your-company