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

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

Two TechNet Radio Sessions You Don’t Want to Miss

I was recently honored to speak on TechNet Radio in two separate sessions about BigData & Hadoop and cloud databases (specifically SQL Azure).  The show debuted on the TechNet homepage under “Today’s News” and on the TechNet Edge homepage.  In each of these shows, I did what I like to do for all the parties I attend - bring a friend.  To make my life easier, I simply reposted the verbiage that TechNet used, rather that to write my own. About the BigData/Hadoop video: Microsoft SQL Server MVP Kevin Kline and Vice President of Database Development at Quest Software Guy Harrison (blog | … [Read more...]

New Toad for SQL Server Beta

A new beta build of Toad for SQL Server (v5.7.0.527) is available at: http://toadforsqlserver.com/beta.jspa It's free and, afaik, doesn't have a short expiration date.  It contains popular features such as compare & sync (for database schemas, servers, and data), a full transaction log reader and DML undo feature, debugger, intellisense, auto-complete, code formatter, and a lot more.  Check it out!  (There's also a version of Toad for Cloud Databases, which gives you SQL-like capabilities against a bunch of NoSQL databases). This drop contains a couple of fixes in the areas: Database … [Read more...]

Azure Trust Services

You might have noticed that Microsoft has recently launched a cool set of Trust Services for Azure.  This is an application-level encryption framework that can be used to protect sensitive data stored on the Windows Azure Platform. One of the hindrances to adoption of Azure that I keep hearing about is trust and security.  If you want to learn more about protecting your data in the cloud you can read up HERE.  I'm not pushing you to get into Azure (even though you should), nor am I subtly trying to make you feel guilty for ignoring the cloud in general nor Azure specifically (subtle, ain't … [Read more...]

How is Microsoft IT using the Cloud?

Steve Balmer very publicly pronounced that Microsoft was “all in” for cloud computing and Windows Azure.  So that means Microsoft is using cloud for its internal IT as well as building products to utilize the cloud.  If you want to learn how Microsoft IT is using Windows Azure to move existing applications to the cloud and creating new applications for the cloud, click here: IT Showcase on Windows Azure.   Let me know what you think.  Accurate and informative? Or marketing fluff? Thanks, -Kevin Follow me on Twitter! … [Read more...]

The Expert’s Conference (TEC) – For AD, SharePoint, Exchange, PowerShell and Other Admins

What is TEC? The Expert's Conference (TEC) is a multi-day event featuring five co-located Microsoft educational conferences at the San Diego Marriott Marquis & Marina April 29-May 2.  It's pretty - see! The event includes advanced 400-level training on Microsoft Directory & Identity (including Active Directory), Exchange Server, SharePoint, Virtualization (Microsoft Hyper-V) & Workspace Management, and PowerShell Deep Dives.  There are lots of great activities for Quest and Microsoft customers and partners.  In addition, there's a Quest Software Day, with User Groups … [Read more...]