This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective dynamic management objects.  You can find a list of all of the deprecated views in the introduction post.

The compatibility view sysindexes returns one row for every index… Read more

1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO

here we set the threshold to 10 seconds, which generating a blocked process report for each task that is blocked.

2. Create Extented…

Read more

Throughout the week, I like to tweet links to the things that I’ve been reading.  Since they all come out through out the day, I figured that I’d share a list of those that were most popular last week.

Last week’s top 10 “Reading” Links

1. What Did You Do? is…

Read more

Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long Island Sound by 6-11 feet!

In light of Hurricane Sandy barreling through the East Coast, I thought I'd review some of the very basics of DR.

read more Read more

Amazon has released the latest version of it Kindle – the Kindle Fire HD.

It seems amazon are moving away from a dedicated reading device and trying to compete with the tablet market – I’m thinking iPads etc.

With support for Gmail Twitter Facebook and other social networking and a… Read more

We are less than ten days to the start of PASS Summit 2012. I thought it would be fun to put together a countdown blog series so here goes. My first blog is about my first PASS Summit. I attended my first PASS Summit in 2007 in Denver, Colorado. At…

Read more

I’m impressed with the current generation of semantic modeling technology from Microsoft.  I’ve had the opportunity to use both PowerPivot and SSAS Tabular Models on a handful of client projects and have had very good results so far.  The xVelocity in-memory aggregation and data compression engine seems to be everything…

Read more

Over the past few years, Ive had it on my to do list to write and deliver and full-scale SQLServer training course and not just an hour long bite size session at user groups and conferences.  To me, SQLServer development is not just knowing and remembering the syntax of commands. … Read more

I’m going to do with this what I should have done with the Piece Of Fruit (POF), blog about the experience.

Getting the silly thing required several phone calls and a car trip, but I wanted it.

Out of the box.

It turned on. Yay!

The first thing it wants… Read more

Good advice from Jeff Bezos.

Filed under: Blog Tagged: misc, syndicated

Read more

Many years ago when I was still working on SQL 2000 I occasionally needed to find all stored procedures and views that referenced a certain table.  After some research I found the system table syscomments.  This table has a column “text” that contains the “Actual text of the SQL definition… Read more

Welcome to this Friday’s reblog summary post.  The aim of these posts is to bring some old posts that newer readers may not have seen back to the forefront.  As with many technology blogs, just because a post is old, doesn’t mean it doesn’t still have value.

Some posts from… Read more

Shared Consolidated Storage Systems – A Brief History

Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes I did.

For as long as we have had computers there has been a need to store and retrieve data. We have covered the basics of hard disks Read more

http://www.flickr.com/photos/_barney/5177975707/

Read more

Over the past few years, I have used Windows Live Writer to create my blog entries on WordPress. Given the nature of Microsoft’s push to use Office for more including social and other online presence, I thought I would see if Word 2013 would actually work to create and edit…

Read more

Read more

I know I focus on community, SQL Server, professional development and process. But you need to do other stuff occasionally too. For example, I’ve long been a fan of horror stories (and science fiction/speculative fiction and some historical novels and history books and… I like to read, OK?). I received… Read more

As most of us are aware, each instance of SSAS 2012 may be run in either tabular or multidimensional mode (and not both). This necessitates having 2 instances should you wish to do both.

HOWEVER, I picked up something interesting at the PASS Nordic Rally. There is an UNSUPPORTED 'toggle' that… Read more

Hey everyone,

I have been nearing this goal for some time (a few times coming within fractions) so this is somewhat anti-climactic, but it's always nice when we cross the finish line of a goal we have placed for ourselves.

On July 24, 2011 - I stepped on a scale… Read more

My first training course from Pluralsight, Understanding Server Hardware has just gone live. It is listed in the SQL Server section of the course catalog, even though it is not really SQL Server specific. It is meant as a foundational course to give you the basic concepts that are… Read more