Proof of Concepts: Making Hard Things Easy with Azure

PROOF OF CONCEPTS: MAKING HARD THINGS EASY WITH AZURE Back when I managed my employer's enterprise architecture, prior to the days of virtualization and cloud computing, one of my most difficult projects was to build out a sandbox environment for a major proof of concept (POC). Locally hosted servers and all of the required licenses were expensive and scarce. If you're still struggling with scarcity when conducting research and performing POCs, I've got to tell you you're doing it wrong. READ MORE... Posted November 02, 2016 … [Read more...]

Microsoft on the Ascent on Business Intelligence and Data Science

MICROSOFT ON THE ASCENT IN BUSINESS INTELLIGENCE AND DATA SCIENCE Microsoft has been on a tear for the past couple of years. It has been pushing forward with a very steady stream of powerful new features and capabilities, even entire product lines, within its Data Platform business. But while Microsoft has been hard at work on this deluge of new technologies, it would be completely forgivable if you haven't noticed. The reason it's OK is that Microsoft is advancing on multiple fronts, both in the on-premises product line and even more dramatically with the Azure cloud-based products. READ … [Read more...]

SQL Injection – Why the Heck Does this Keep Happening?!

  I'm decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I'll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them off to school. Next, I make a bowl of oatmeal (a great choice for diabetics like me), pour a second cup of coffee, and browse the local paper, The Tennessean, while I have breakfast. On the morning of August 5, I had the added pleasure of spewing said coffee and oatmeal all over my morning paper when I read the … [Read more...]

DBTA – Other News in SQL Server 2014 RTM

  A while back, I told you about some of the coolest new features in the recent RTM for SQL Server. The RTM was announced during the “Accelerate your insights” webcast by a boatload of Microsoft’s top executives, including CEO Satya Nadella, COO Kevin Turner, and CVP Quentin Clark. They had lots of useful information to share and demos to show, but a few other items of note about Azure SQL Databases may have dropped under your radar because they came to light a few days after the big dog-and-pony show/webcast. Read the rest of the article … [Read more...]

DBTA – Cloud Computing Enhancements in SQL Server 2014

  There’s no doubt that cloud computing is growing due to the strong cost benefits, simplified management, and reduced hosting complexities.  So it’s only fitting that we cap this series on the new features of Microsoft’s upcoming SQL Server 2014 (SQL2014) release of their flagship database by going over the highlights for SQL2014’s new cloud computing features. Here’s what SQL2014 will do for you with regards to business cloud computing: Read the rest of this article … [Read more...]

Now Playing on SSWUG TV!

Hi friends, I know a lot of you regularly read my blog either on my home page at KevinEKline.com, on SQLBlog.com, or one of the locations where it's syndicated. And you may also regularly take in my content on SQLSentry.TV or my monthly column on Database Trends & Applications magazine.   Click the image to see my new weekly video series on SSWUG.org! Now I'm adding a new video format to the mix, in partnership with my friend Steven Wynkoop and SSWUG.org.  I've been a frequent speaker in the SSWUG virtual conferences over the past several years and, we thought, why not … [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...]

Is Microsoft SQL Server Supported By …?

One of the types of question you get after speaking at a conference about virtualization, like I did at the 2012 PASS Summit with my buddy David Klee (Twitter | Blog), might go down like this: "Is SQL Server version X supported on hypervisor platform Q?" or something even more specific like "Is SQL Server 2012 supported on VMWare vSphere ESX 4.1 Update 2? Or do I have to upgrade to ESX 5.0?". Now, when I'm asked a question like this, I usually drool and act like an ape, hoping the the questioner will flee in terror.  If they insist on hanging around to hear a real answer, I now refer them to … [Read more...]