Tag: Microsoft SQL Server

SQL Server 2014 CTP 1 – Installation failure

Recently I was trying to install SQL Server 2014 CTP 1 on my Windows Server 2008 R2 Virtual Machine to explore SQL Server 2014. What I encountered was a failure of a rule “Previous SQL Product installation” ———————————— Rule Check…

Read More >

SMB File Share and SQL Server: An option to consider

Introduction When we relate file share and databases, many people will turn up their noses – but today this is a reality that we can use even in production. Microsoft spent the last years working on improvements to the Server…

Read More >

Log Buffer #348, A Carnival of the Vanities for DBAs

With the holiday season fast approaching (or is it slow?), data bloggers have already adopted a festive mood, and this Log Buffer edition jubilantly captures and reflects that, and much more.

Read More >

Log Buffer #347, A Carnival of the Vanities for DBAs

What do swaying palms, turquoise water, white sandy beaches and absolutely pristine fauna remind you of? Correct! It’s Log Buffer. This Log Buffer brings you beads of blog posts related to data dexterity crafted by leading bloggers across the planet.

Read More >

Preventing runaway queries using Resource Governor

Section A (Theory) One of the typical reasons for performance issues is runaway queries executed by end users on a busy production database. This problem is fairly common in OLAP or shared systems (OLTP/OLAP) where business users begin executing complex…

Read More >

Log Buffer #346, A Carnival of the Vanities for DBAs

Economist says that Physics suggest that storms will get worse as the planet warms. Typhoon Haiyan in Philippines, bush-fires in Australia, floods in China, and extreme unpredictable weather across the planet is a sober reminder. Good news is that technology…

Read More >

SSAS– Resolving Target Machine Actively Refused

I’ve always wanted to get my hands on SSAS, SSIS and SSRS as I’ve often felt shorthanded in these areas. Yesterday I decided to play around with one of these and get my hands dirty – SSAS. A few months…

Read More >

Log Buffer #345, A Carnival of the Vanities for DBAs

There are a number of technologies, apps, and social media creations out there seeking to displace blogs as the mode of sharing between surfers, but blogging has proved hardy. It has proven its mettle and it’s here to stay. This…

Read More >

SQL Server Risk Assessment – The PMP Way

Recently I had a chance to speak with my friend and colleague, Ashish Sharma. We were discussing Project Management topics (he recently passed PMP and ACP). Our discussion ended on a very interesting topic – RISK Assessment. Definition: According to…

Read More >

SQL Server Instance in Script Upgrade mode

Introduction: Almost all of us in our DBA life would have patch/upgrades SQL Server instance and would have faced many issues while upgrading the SQL Server build. Today I will discuss in little detail about the background of the Script…

Read More >