Revisiting PASS Summit 2015

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 Seattle, 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

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...]

New Releases for the Microsoft Data Platform

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...]

DBTA – PowerBI: The Self-Service BI App That Can Change Your Life

Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and packaged application reporting systems for CRM, licensing, and user information. If you’ve ever worked with a packaged product, such as a CRM system, that includes reporting and querying features, then you know how inflexible they are. It can be infuriatingly difficult to get data out of these systems, systems for which you paid big money, without losing sleep, hair, and peace of mind. Working with … [Read more...]

Windows Azure and SQL Database News

This morning Microsoft released some great updates to Windows Azure.  These new capabilities include: SQL Server AlwaysOn Support: General Availability support with Windows Azure Virtual Machines for High Availability and Disaster Recovery Notification Hubs: General Availability Release of Windows Azure Notification Hubs (broadcast push notifications for Windows 8, Windows Phone, iOS and Android) AutoScale: Schedule-based AutoScale rules and richer logging support Virtual Machines: Load Balancer Configuration and Management Management Services: New Portal Extension for Operation … [Read more...]

MySQL, NoSQL, and NuoDB

I've been keen on MySQL ever since I first started using it heavily more than a decade ago.  In fact, I liked it well enough to include it as one of the four main database platforms, over and above the ANSI-ISO SQL standard, in my popular book SQL in a Nutshell. However, with the advent of NoSQL data platforms in the last few years, the waters have been muddied.  It's no longer a quick easy decision as to which database platform you should use, both because there are many new platforms to choose from and because the old, easy choices aren't as cut and dried as they used to be.  MySQL, for … [Read more...]

Hear the SQL Server 2012 story on DotNetRocks

I was privileged to have a chat with my buddies over at www.dotnetrocks.com, Carl Franklin and Richard Campbell, episode number 876 (876!). Listen to the most popular internet audio talk show for .NET developers!  Here's the abstract: Carl and Richard talk to Kevin Kline about the latest features in SQL Server 2012. The conversation starts out talking about the new features that developers will love, like windowing - no need for cursors anymore, you can request a window of records from a set and move easily window-to-window. Kevin also talks about the new column store index that is especially … [Read more...]

New On-Line Resources for Windows, Virtualization, and Cloud!

Ever since returning from the UK for the SQLBits conference, I've been snowed under a mountain of action items.  I've got such a backlog of things to get done, emails to answer, and family to not ignore that I'm starting to feel really guilty. So with that in mind, I wanted to whip out a quick blog post to let you know I'm still alive and thinking of y'all.  What could be quicker and easier than some cool new resources you might not have seen?  For your perusal: Whitepaper: Managing Windows 7 and Windows 8 … [Read more...]

The All-New ‘Database Lifecycle Management” is available on MSDN

The initial release of Database Lifecycle Management is now available on MSDN. The site is something called "curated content". This means it's a single consolidated location to look up lots of disparate articles and content, all in one easy to search location. This “curated content view” contains the best content, video, and community-centric information from Microsoft, including topics like: SQL Server Data Tools · Get started with sample projects, code samples · Video demos by Gert Drapers (blog) · Script common data portability tasks using Sqlpackage.exe · Link to the SSDT … [Read more...]

Timewarp: What Is a Relational Database?

Relational?!? Move On, Geezer! Maybe you're thinking that relational databases management systems (RDBMSs), like Microsoft SQL Server and Oracle, are going the way of punched cards and rotary phones.  After all, there's been a lot of hype these days in the IT media about the rise of so-called NoSQL (Not Only SQL) databases.  Many new and upcoming CS and MIS graduates who like working with data might think that relational databases are, at best, soon-to-be legacy systems and, at worst, are a career dead-end. Wrong!!! It's true that all the cool-cat computing services (Amazon, Facebook, … [Read more...]