Archives: October 2012
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.
sp_configure 'show advanced options', 1 ;
sp_configure 'blocked process threshold', 10 ;
here we set the threshold to 10 seconds, which generating a blocked process report for each task that is blocked.
2. Create Extented…
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
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.
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
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
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.
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
SQL Server 2012 SSAS .. 'Yes we can' use one instance for both the tabular and multi dimensional models
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
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