Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: October 2012

Monitor Blocking with Extented Events in SQL 2012

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

0 comments, 714 reads

Posted in James' SQL Footprint on 29 October 2012

Last Weeks Top 10 “Reading” Links #4

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

0 comments, 313 reads

Posted in StrateSQL on 29 October 2012

Geographic Failover/Redundancy (and DR)

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

0 comments, 500 reads

Posted in @chuckboycejr on 29 October 2012

Amazon Kindle Fire Released

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

0 comments, 235 reads

Posted in The SQL DBA in the UK on 29 October 2012

Countdown to PASS Summit 2012 – 9 to Go – My First Summit

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

0 comments, 267 reads

Posted in DataOnWheels on 28 October 2012

Is PowerPivot the Next Access?

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

2 comments, 2,947 reads

Posted in SQL Server BI Blog on 28 October 2012

Advanced TSQL training

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

0 comments, 577 reads

Posted in Dave Ballantynes blog on 28 October 2012

Microsoft Surface

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

5 comments, 2,463 reads

Posted in The Scary DBA on 28 October 2012

Question what you think

0 comments, 518 reads

Posted in The Voice of the DBA on 26 October 2012

How do I find all stored procedures or views that use a specific table?

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

0 comments, 1,356 reads

Posted in SQLStudies on 26 October 2012

Reblog: October 19 to October 25

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

0 comments, 275 reads

Posted in StrateSQL on 26 October 2012

The Fundamentals of Storage Systems – Shared Consolidated Storage Systems

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

0 comments, 1,272 reads

Posted in SQL Man of Mystery on 26 October 2012

DBA Question of the Day: Statistic




http://www.flickr.com/photos/_barney/5177975707/
Hello Dear Reader, yesterday I posed the question to you what are Statistics?  We could get down and dirty of how the internals of SQL Server use Statistics (and we will), but first let’s talk about the concept because it is at heart a very simple one.

In America…

Read more

0 comments, 370 reads

Posted in SQLBalls on 26 October 2012

Using Word 2013 to Create Blog Entries

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

2 comments, 361 reads

Posted in DataOnWheels on 26 October 2012

Database Mirroring Error


I have been setting up multi instance database mirroring for the last couple of days along with some other DR related processes.  I will do a detailed post about these at a later date.  I came across this particular error again (for about the sixth or seventh time) Error Message…

Read more

2 comments, 290 reads

Posted in SQL Server 365 on 26 October 2012

Scary Reading List for Halloween

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

6 comments, 349 reads

Posted in The Scary DBA on 26 October 2012

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

1 comments, 921 reads

Posted in Simon Says on 26 October 2012

[off topic] I crossed a milestone today

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

6 comments, 401 reads

Posted in @chuckboycejr on 26 October 2012

Understanding Server Hardware Course from Pluralsight

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

0 comments, 579 reads

Posted in Glenn Berry's SQL Server Performance on 26 October 2012

Newer posts

Older posts