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

Archives: December 2010

Book Review: Bury My Heart at Conference Room B

Bury My Heart at Conference Room B: The Unbeatable Impact of Truly Committed Managers by Stan Slap ($15 @ Amazon) is about finding a way to mesh your personal values with the values of the business, and how showing your values to your team and encouraging them to live and…

Read more

0 comments, 264 reads

Posted in SQLAndy on 29 December 2010

Quick Thoughts on Learning

I’m looking for the attribution for a quote – it’s something I first heard from Sean, and we say it all the time: You never understand a thing until you teach it. 

Along the way, I found this:

We learn more by looking for the answer to a question and…

Read more

0 comments, 190 reads

Posted in SQL Awesomesauce on 29 December 2010

SELECT TOP 5 * FROM BLOGGERS

Hopefully my title gives away what this post is about. This my list of the top five people or more precisely their blogs that have made most use out in the year gone, I am not going to put them in any specific order they all add to my knowledge… Read more

1 comments, 187 reads

Posted in The SQL DBA in the UK on 29 December 2010

Digineer Is Hiring

If you are in Minnesota and are looking for a new job, Digineer is hiring.  Heck you can even be one of those that has been thinking – “I would love to move to Minnesota because I love the thought of their frigid winters” – and need that job to… Read more

0 comments, 214 reads

Posted in StrateSQL on 29 December 2010

How to tell if a property exists by name

I recently was working on a library to manage reports in an application (probably a good candidate for an open source project) and needed to be able to grab the value of a property on an object by name without knowing if that property existed or not.  Of course .NET reflection comes…

Read more

0 comments, 375 reads

Posted in New York City .NET on 29 December 2010

The Importance of Windows Power Plans for Server Performance

This is a subject I have written about a couple of times before, here and in much more depth here.  Much more recently, fellow SQL Server MVP Brent Ozar (blog| twitter) has also blogged about this subject.  I thought I would show you how to… Read more

1 comments, 484 reads

Posted in Glenn Berry's SQL Server Performance on 29 December 2010

SQL Server Storage Internals Part 6 – How to read Clustered and Non Clustered Index Pages

In this article we are going to see how index pages are organized with data pages and how to read different levels and types of indexes with simple example

To start with, let’s create a simple table in test database named LearningInternals.

CREATE TABLE tExample6(

intEmployeeId int IDENTITY(1001 Read more

7 comments, 3,280 reads

Posted in LivingForSqlServer on 29 December 2010

2010 Recap

As a part of a recap on the year that was 2010, I should start with a recap of my goals.  For that review I had to go back to my Q3 review.  As I looked it over, I found that there was nothing really different from that review… Read more

4 comments, 236 reads

Posted in SQL RNNR on 28 December 2010

T-SQL: CASE Statement

This is a companion piece to the MidnightDBA video T-SQL: CASE Statement.

In short, a CASE statement is a simplified set of IF statements. Instead of using several IF statements, you can have a single statement that evaluates several criteria against a piece of data. 

Simple CASE

Let’s take… Read more

4 comments, 1,175 reads

Posted in SQL Awesomesauce on 28 December 2010

SSIS Multiple File Export

Have you ever needed to export different data sets to different flat files?  Each of these data sets could be customer information for different clients – but they all require the same fields.  I have run into this requirement a few times and have found that it is not as… Read more

0 comments, 646 reads

Posted in SQL RNNR on 28 December 2010

Wrapping Up 2010

Goal Setting

It’s time to wrap up the year.  I don’t have a resolutions or goals post from last year to re-cap so that leaves this post fairly open ended.  At some point a couple years ago I read an article about not publicizing your resolutions to help keep you… Read more

2 comments, 333 reads

Posted in StrateSQL on 28 December 2010

RTFM365, Week 3

Well, my brain has increased by 12.4% in terms of SQL knowledge this week, as a direct result of my BOL readings, and according to numbers I’ve just made up. I’m sure it’s accurate.

The thing that has me preoccupied this week is how much I’m looking up and reading… Read more

2 comments, 359 reads

Posted in SQL Awesomesauce on 28 December 2010

Can You Dig It? – StmtCursor and StmtReceive Elements

She can dig it!
D Sharon Pruitt

A few posts ago in the plan cache series I discussed the children for the Statements element.  I’ve gotten through two of the elements and in this post we’ll be looking at the StmtCursor and StmtReceive elements.

The SHOWPLAN XML schema defines both… Read more

1 comments, 554 reads

Posted in StrateSQL on 28 December 2010

DBTA: What’s Your Data Management and Retention Policy?

If managing your corporate data for the long term isn’t currently on your mind, it should be, and in several different ways: cost, performance, business continuity, and compliance. [READ MORE]

Posted Jun 7, 2010

Read more

0 comments, 176 reads

Posted in Kevin E. Kline on 28 December 2010

What’s Your Data Management and Retention Policy? [DBTA]

If managing your corporate data for the long term isn’t currently on your mind, it should be, and in several different ways: cost, performance, business continuity, and compliance. [READ MORE]

Originally posted on Jun 7, 2010

Read more

0 comments, 163 reads

Posted in Kevin E. Kline on 28 December 2010

SSAS Understanding Multiple Security Roles

In a previous article I showed how you can create dynamic security in SSAS.  This is a great way to make all security table based using Active Directory accounts associated with the items that the user is allowed to see. 

If you decide that your security model is pretty basic… Read more

0 comments, 1,610 reads

Posted in Devin Knight on 28 December 2010

SSMS Tools Pack (free), supports SQL Sever Denali CTP1

Free tools are very welcome to the community, while some of the creators of these kind of the tools are open to the community as well! I discussed more early about free tools (here & here) , so today let me show you the great tool for SSMS… Read more

1 comments, 894 reads

Posted in Dukagjin Maloku - Dugi'DBA on 28 December 2010

Getting a Dedicated Admin Connection

Did you know you can easily get a Dedicated Admin Connection (DAC) in SSMS? I didn’t assuming that I’d need to use a command line and SQLCMD. However while studying for the MCM, I learned that there’s an easy way.

I tested this on a SQL Server 2008 instance, having… Read more

9 comments, 522 reads

Posted in The Voice of the DBA on 28 December 2010

SQL Server Workload Types and Hardware Selection

There are two primary relational workload types that SQL Server commonly has to deal with, the first being Online Transaction Processing (OLTP) and the second being Decision Support (DSS)/Data Warehouse (DW). OLTP workloads are characterized by numerous, short transactions, where the data is much more volatile than in a DSS/DW…

Read more

2 comments, 1,467 reads

Posted in Glenn Berry's SQL Server Performance on 28 December 2010

Happy Holidays

I hope everyone is enjoying the holidays.  To everyone in the SQL Server community, Merry Christmas and Happy New Year.  Spend time with your families and no working during the holidays!



Weblog by Paul Turley and SQL Server BI Blog.

Read more

0 comments, 387 reads

Posted in SQL Server BI Blog on 27 December 2010

Newer posts

Older posts