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

What’s the Data Modeling Standard for Business Intelligence Systems?

I had the good fortune to overhear some of my good friends and fellow MVPs discussing the process of data modeling for business intelligence systems.  So what are the industry standard approaches for modeling dimensional data modelling? The short answer is that Kimball's dimensional modeling is the most widely adopted standard for any sort of data warehouse. Inmon is also well respected. But the consensus is to stick with Kimball, especially if you're looking for something an enterprise standards team is going to recognize as "standard". The book on my shelf and which I most … [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...]

PASS Business Analytics Conference (BAC) Recap

The PASS Business Analytics Conference (PASS BAC) is PASS' first foray into an event that is dedicated to business intelligence, big data, data visualization, and business analytics.  And it totally makes sense for PASS to move in this direction, over and above the flagship community work centered on database management and application development.  Why?  Because business analytics is all about how to apply the data being collected and managed by all of those developers and DBAs.  And, at the end of the day, how we use and apply our data is really the nexus of its value.  That's what matters … [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...]

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

The Year That Was – 2012

2012 was, simply stated, a year that kicked my butt.  When I wasn't struggling professionally, I was struggling personally.  Health issues, culminating in a diagnosis of Type II diabetes, and the passing of my father soon after Thanksgiving marked my biggest struggles.  I apologize to those of you who are normally on my Christmas card list for not sending any this year. The wind was not in my sails.  On the positive side of the ledger, I made a scary but exciting leap to SQL Sentry midyear. This was a huge shake-up after 10 years with my previous employer, but one which has been met with … [Read more...]

Let’s Talk Licensing and Virtualization for SQL Server

I have two new articles up on Database Trends & Applications magazine.  I'd love to get your thoughts and feedback! Welcome to the Weird, Wild World of SQL Server Licensing Not long in the past, SQL Server licensing was an easy and straightforward process. You used to take one of a few paths to get your SQL Server licenses. The first and easiest path was to buy your SQL Server license with your hardware. Want to buy a HP Proliant DL380 for a SQL Server application? Why not get your SQL Server Enterprise Edition license with it at the same time? Just pay the hardware vendor for the … [Read more...]

How To Download Free Sessions From PASS

For all members of the Professional Association for Server (PASS), are you downloading slides and videos from all sorts of great PASS events?  If not, what are you waiting for ... an invitation? Ok, here it is.  I invite you to download like a madman!  (How a madman downloads, an almost entirely virtual activity, is not the question here, ok?). For starters, there's the recent 24 Hours of PASS event.  I hope you were able to attend all of the sessions you wanted. But even if you didn't get to see any, you can see them now as long as you're a (free) member of PASS.  The session recordings … [Read more...]