THEY DID IT AGAIN – THE RELEASE OF SQL SERVER 2017 Not only has the Microsoft SQL Server engineering team added more and stronger leadership, outstanding individual engineers and staff members, but it is also radically moving its entire development process into a "cloud-first" ethos. Now, I'd like to show one of the most salient results of this new development process-accelerated product releases. It was only a few years ago (and is still the case for other data management platforms) that a major new release takes at least 2, but more likely 3 years. With the "production-ready" release of SQL … [Read more...]
Machine Learning and the Microsoft Data Platform
October 24, 2017 by Leave a Comment
MACHINE LEARNING AND THE MICROSOFT DATA PLATFORM If you're into data and databases and you have not heard the term "machine learning," may I suggest that you're not reading enough? This technology is hot and hyped, largely because it is the secret ingredient in many successful Big Data projects. Learn more. READ MORE... Originally Posted January 07, 2016 … [Read more...]
Surprising but True: the Basics are Still Difficult
October 20, 2017 by Leave a Comment
SURPRISING BUT TRUE: THE BASICS ARE STILL DIFFICULT I always look forward to new research from Unisphere Research, a division of Information Today, Inc., publishers of this magazine and other great products for data professionals. The latest report which you should read is "SQL Server Transformation: Toward Agility & Resiliency 2017; PASS Database Management Survey." READ MORE... Originally Posted April 07, 2017 … [Read more...]
Dynamic Data Masking and Row-Level Security Features on the Way in SQL Server 2016
October 17, 2017 by Leave a Comment
DYNAMIC DATA MASKING AND ROW-LEVEL SECURITY FEATURES ON THE WAY IN SQL SERVER 2016 In addition to StretchDB and AlwaysEncrypted, there are two more exciting features in the works for SQL Server 2016: dynamic data masking and row-level security. In the case of these two features, they'll be released first to the cloud platform (Azure SQL Database) and, later, to the on-premises version of SQL Server. READ MORE... Originally Posted December 02, 2015 … [Read more...]
Revisiting PASS Summit 2015
October 10, 2017 by Leave a Comment
PASS SUMMIT 2015: THE AGE OF THE DATA PROFESSIONAL IS NOW The PASS Summit 2015, the largest conference in the Microsoft SQL Server world, was held in October in Seattl, WA. The event provided a look at key initiatives that Microsoft's SQL Server group has been working on and a glimpse of what's ahead for the future. READ MORE... Originally Posted November 09, 2015 … [Read more...]
Introducing the SQL Server Database Experimentation Assistant
October 6, 2017 by Leave a Comment
INTRODUCING THE SQL SERVER DATABASE EXPERIMENTATION ASSISTANT There's a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative insight into the performance differences across two versions of a database workload on SQL Server. Learn more! READ MORE... Posted February 08, 2017 … [Read more...]
Stronger Security Via Always Encrypted in SQL Server 2016
October 3, 2017 by Leave a Comment
STRONGER SECURITY VIA ALWAYS ENCRYPTED IN SQL SERVER 2016 Prior to SQL Server 2016, currently in CTP, your main method for encrypting a SQL Server application was to use a feature called Transparent Data Encryption. TDE provides strong encryption, but with some shortcomings. First, you have to encrypt an entire database. No granularity is offered at a lower level, such as encrypting specific tables or certain data within a table. Second, TDE encrypts only data at rest, in files. Data in memory or in-flight between the application and server are unencrypted. Enter Always Encrypted. READ … [Read more...]
Major Feature Reconfiguration For SQL Server 2016 Service Pack 1
September 28, 2017 by Leave a Comment
MAJOR FEATURE RECONFIGURATION FOR SQL SERVER 2016 SERVICE PACK 1 One of the long-standing differentiators between SQL Server's Enterprise Edition (EE) and Standard Edition (SE), besides price, were the large number of features available only in EE. This is also true for other lower editions of SQL Server such as Web Edition and Express Edition. But there's big news in the air! READ MORE... Original Posted January 03, 2017 … [Read more...]
Buy Generic Cialis online
September 21, 2017 by Leave a Comment
Buy Cialis Online Tadalafil is indicated for the treatment of erectile dysfunction. Tadacip works by helping to increase blood flow into the penis during sexual stimulation. Generic Cialis helps you to achieve and maintain an erection. Tadacip from Cipla is used to treat erection problems in men. It is the only drug which works in 30 minutes, but is also know to be effective for as long as 24 hours. This enabling you to choose the moment that is just right for you as well as your partner. Thousands of men have benefited from Tadacip 20mg, moderate or severe Erectile Dysfunction. We sell … [Read more...]
New Releases for the Microsoft Data Platform
September 18, 2017 by Leave a Comment
NEW RELEASES FOR THE MICROSOFT DATA PLATFORM The Microsoft data platform team is on fire! It is delivering more updates and features faster and more thoroughly than ever before. If you're a data professional and you're using the Microsoft stack, this is a really exciting time to be involved. Here's a look at the top new capabilities in SQL Server 2016 Public Preview, SSIS Feature Packs For Azure, and Azure SQL Data Warehouse. READ MORE... Originally Posted July 08, 2015 … [Read more...]
