SQL Server 2014 and the DBA: Building Bridges

by Guest Post on April 24, 2014

in SQL Server

 Guest blog post by: SQL Server MVP Denise McInerney – Vice President of Marketing for PASS and a Data Engineer at Intuit – began her career as a SQL Server DBA in 1998 and now applies her deep understanding of data to enable analytic solutions to business problems. She is founder of the PASS Women in Technology virtual chapter, a speaker at user group meetings and conferences, and blogs at select*from denisemc.views. You can follow her on Twitter at @denisemc06.

*     *     *     *     *

The iconic Golden Gate Bridge was a great image for promoting last week’s live webcast celebrating the launch of SQL Server 2014. Of course, it represents San Francisco, where Microsoft CEO Satya Nadella, COO Kevin Turner, and Data Platform Group CVP Quentin Clark took the stage to highlight the new release’s features. But I think it’s also a metaphor for what the new capabilities foretell for SQL Server DBAs.

From the much-anticipated In-Memory OLTP engine (formerly code-named Hekaton) – with its promise of dramatically reducing I/O traffic jams and speeding application performance – to the new high-performance updateable columnstore index and enhanced scalability through improved Windows Server 2012 integration, much of the SQL Server 2014 message is about helping us build better, stronger, faster data-processing bridges.

But with the release’s integration of AlwaysOn Availability Groups with Windows Azure, smart SQL Server backup to a Windows Azure URL, and integration with the new Power BI for Office 365 cloud solution, we’re also talking about bridging our database capabilities – and technical skills – to the cloud and further into the data analytics world.

What does all this mean for us as SQL Server professionals? More than ever, our organizations need us to be an essential part of the team: bridging IT and business, better connecting data and the people who use it to make decisions, and adding value by building strong and flexible solutions custom-fit for our company’s needs.

As we prepare for this changing world of data, here are three areas to focus on:

  • Cloud and hybrid environments: On-premises SQL Server vs. the cloud isn’t the question anymore.  More and more, we’ll have data residing in both worlds. In Hybrid IT environments, we’ll play an important role in application architecture and design. We’ll also need to support on-premises and cloud-based performance tuning and monitoring, implement high availability and disaster recovery solutions, and more. The mission is still effective data management – wherever the data lives.
  • Relational and big data:As we gather and store increasingly more data and different types of data – including structured, unstructured, and streaming – we’ll be looking at another hybrid environment. This one will include SQL Server relational stores integrated with big data solutions such as Hadoop for storing and processing large data sets.
  • Data and business value: The purpose of collecting all this data is to use it to improve our products and services and better understand and serve customers. As data professionals, we need to be the champions of thinking end-to-end about how data can transform business – what Satya Nadella calls creating “a data culture.” It involves bringing business intelligence and analytics to everyone in our organizations, helping them understand the data they have, ask questions of it, and gain insights.

Change brings challenges but also the opportunity to learn and grow our careers. I encourage you to take advantage of the free resources available through PASS Virtual Chapters, your local user group, and PASS SQLSaturday events to learn how SQL Server 2014 and Microsoft’s data platform can help us get the most from our organizations’ data.

As SQL Server professionals, harnessing the power of data to solve business problems is really the heart of our job. We’re still guardians of data – but now we also need to be advocates for what data can do in our businesses.

Let’s go build some bridges.
– Denise


SQL Server Team Blog

{ Comments on this entry are closed }

Update Rollup 6 for System Center 2012 Data Protection Manager Service Pack 1 is now available

April 24, 2014

System Center 2012 SP1 Data Protection Manager (DPM 2012 SP1) Update Rollup 6 is now available. For all the details regarding the issues that are fixed as well as download and installation instructions, please see the following: KB2958098 – System Center 2012 SP1 Data Protection Manager Update Rollup 6 (http://support.microsoft.com/kb/2958098) J.C. Hornbeck | Solution Asset […]

Read the full article →

Microsoft Remote Desktop Preview app for Windows Phone 8.1 available for download

April 24, 2014

My name is David Bélanger, and I’m a program manager on the Remote Desktop team working on Remote Desktop apps for the different Windows platforms. Today, I’m happy to announce that a preview of the Remote Desktop app for Windows Phone 8.1 is now available for download from the Windows Phone Store. We are excited […]

Read the full article →

OnePlus One revealed

April 23, 2014

The folks at OnePlus have been building up hype around their first smartphone launch, and today the OnePlus One finally became official. Announced at an event in China, the Magnesium constructed One weighs just 162g, has a recessed bezel round the edges, what it says are “beautiful contours” and a ton of beefy hardware inside. […]

Read the full article →

Lifeline, The Early-Stage Finnish VC Firm That Backed Supercell, Closes Another Fund

April 23, 2014

 Lifeline Ventures has never ceased to surprise me. There’s their annual benchpress and dead-lifting contest every November to find the world’s strongest investor and founder. Or, I mean, just look at their portfolio: Trash-sorting robotic systems. Ear-plugs that shine light on the surface of your brain to treat seasonal affective disorder. They even backed the Finnish rock […]

Read the full article →

Chrome Remote Desktop goes mobile

April 22, 2014

Have you ever been out and about, and urgently needed to access a file that’s sitting on your home computer? Since 2011, Chrome Remote Desktop has let you remotely access your machine from another laptop or computer in a free, easy and secure way. And now, with the release of the Chrome Remote Desktop app […]

Read the full article →

The Preferred Architecture

April 22, 2014

During my session at the recent Microsoft Exchange Conference (MEC), I revealed Microsoft’s preferred architecture (PA) for Exchange Server 2013. The PA is the Exchange Engineering Team’s prescriptive approach to what we believe is the optimum deployment architecture for Exchange 2013, and one that is very similar to what we deploy in Office 365. While […]

Read the full article →

Customers using Microsoft technologies to accelerate their insights

April 20, 2014

At yesterday’s Accelerate your insights event in San Francisco, we heard from CEO Satya Nadella, COO Kevin Turner and CVP Quentin Clark about how building a data culture in your company is critical to success. By combining data-driven DNA with the right analytics tools, anyone can transform data into action. Many companies, and many of our customers, are already […]

Read the full article →

Greed and the Wright Brothers

April 20, 2014

The Wright brothers’ critical insight was the importance of “lateral stability” – that is, wingtip-to-wingtip stability – to flight. And their great innovation was something they called “wing warping,” in which they used a series of pulleys that caused the wingtips on one side of the airplane to go up when the wingtips on the […]

Read the full article →

Clean up temp files remotely – Version 2

April 20, 2014

A few months ago we released a new version of Network Administrator that had the ability to clean temp files out of user profiles, and the system temp folder: A good friend named Rob emailed me about an issue he was having – it seems that the plugin did not always clean out all of […]

Read the full article →