Tag: Microsoft SQL Server

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 >

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

Every day is a new journey but the path remains the same. Bloggers are advancing on this path to reach new milestones. They sometimes pace high, sometime low, but whatever, they never miss to share what they learn along the…

Read More >

Magic Knobs in Replication Agents

Have you ever wondered about tuning your replication configuration to achieve better performance or you got into a situation of huge latency and were looking for an easier way to tune it. In this blog post, I will explain the…

Read More >

Column Store Indexes in SQL Server 2012

Introduction: We will discuss Column Store Index and will try to understand the performance improvements of the same query by multiple times using column store index. What is Column store Index: Column Store Index is a feature introduced in SQL Server 2012…

Read More >

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

One key success factor in a great leadership is to gather great people around you. Bloggers are people, and this Log Buffer Edition enables you to gather them around you through their blog posts.

Read More >

MSDB – Cleanup is necessary

Recently I have been asked to work on the task which is to reduce the size of a MSDB database. The MSDB has grown to 20 Gigs. Well, you would say, what is the big deal with that? 20 Gigs…

Read More >