SQL Server 2014 News

Apologies for lack of truly original content lately, moving house + work + family are taking up all my spare time. Here’s some updates from around the web.

Nasty Bug in SQL Server 2012 SP1

Ok, this is SQL Server 2012 SP1, not 2014, but it’s worth drawing attention to. There is a bug in SLQ Server 2012 SP1 that can lead to data loss when running an online index rebuild whilst concurrent data modifications are happening.

Columnstore Articles

Joe Chang talks us through the latest TPC-H Benchmarks with Columnstore. Interesting to note that it is implied that partitioning is recommended when using Clustered Columnstore Indexes.

2 part Case Study on Clustered Columnstore Indexes with Jimmy May

Part One

Part Two

24 Hours of PASS

24 Hours of PASS is back, and there’s plenty of talks on Clustered Columnstore Indexes to view. Sign up now. (Note signing up now does not give you a place. The number of attendees is capped at 1,000 per session).

24 Hours of PASS

Of course if that is too long to wait then there is some training taking place tonight at 8PM, courtesy of Dell entitled A Comedy of Errors.

Managing SQL with SCOM

Those of you in London might be interested to attend this event at Greater London House (the ASOS offices), a very imposing art-deco building in Mornington Crescent, on June 26, 2014 (12:00 GMT). If the architecture does not pique your interest then perhaps the talk on SCOM and SQL Server might do.

The following is directly taken from the event page:

Have DBA’s ever heard of System Center Operations Manager, did you consider the power of System Center Operations Manager to manage your SQL estates?

Let’s start the first step into Monitoring of SQL Server with SCOM (System Center Operations Manager), in this session you will learn the potential behind SCOM to give you a single glass monitoring solution.

Key subject learned from this session;

  • Supported versions of Operations Manager
  • Supported versions of SQL Server
  • SCOM Security for access to your SQL estates
  • What we can monitor within SQL
  • Advisor (Microsoft Cloud advisory solution)
  • Reporting and dashboards

I’ve spoken of SCOM packs for SSAS in the past, and if you have a large production environment and are bought into Microsoft products, then it’s wise to turn up and see how you can use SCOM to manage SQL Server environment.

Author: Richie Lee

Full time computer guy, part time runner. Full time Dad, part time blogger. Knows a thing or two about Pokémon. Knows too much about SQL Agent. Writer of fractured sentences. Maker of the best damn macaroni cheese you've ever tasted.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s