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

Archives: November 2010

New Domain - My blog has a new domain name gethynellis.com

About a year ago I started to write a blog, previously to that, for about three years I had been writing a SQL Server themed tips and articles on my website. When I started writing the blog I decided to build it into my existing domain name, that I think… Read more

2 comments, 177 reads

Posted in The SQL DBA in the UK on 28 November 2010

Plays Well With Others – Eight Behaviors of Excellent Leaders

Last week,  I talked about one of the worst type of management scenarios to work under – the micromanager.  Now, let’s take that conversation from the “Dark Side” into the light to talk about great leaders.

To say that Dr. William Cohen knows a few things about leadership is approximately… Read more

13 comments, 274 reads

Posted in Kevin E. Kline on 27 November 2010

SQL Server 2008 R2 Best Practices Analyzer

A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are literally hundreds of different best practices, and as you might expect, not every best practice applies to every SQL Server environment. That means, that as a DBA, you must evaluate… Read more

2 comments, 1,243 reads

Posted in SQL Aloha on 27 November 2010

Do You Protect Your Passwords?

Protect Your Password!

As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password practices of others.  One of the most shocking things I’ve come to discover is how loose people are with their passwords.  At times, I am even included in this group. Read more

3 comments, 267 reads

Posted in StrateSQL on 26 November 2010

Book Review - The Checklist Manifesto

Andy Warren recommended The Checklist Manifesto to me and after seeing his review, I decided to grab it. It’s written by a surgeon, and starts with a few stories of how people were saved in the ER by some amazing teamwork.

The book then goes into a discussion on… Read more

1 comments, 929 reads

Posted in The Voice of the DBA on 26 November 2010

What Am I Thankful For

Earlier this week, I suggested that we share a message of thanks on our blogs.  Since I suggested we put these posts together, I should throw my post in the ring.  Especially since today is Thanksgiving and my food coma is starting to dissipate.  It only took the second… Read more

1 comments, 299 reads

Posted in StrateSQL on 26 November 2010

Leading the Albanian PASS Chapter

Yesterday, I have received the official email from the PASS HQ, and the confirmation that now I'm the leader of the Albanian SQL Server Users Group or Albanian PASS Chapter!

The Albania PASS Chapter will be available and open for all SQL Server users including the Albania and Kosova, where… Read more

4 comments, 306 reads

Posted in Dukagjin Maloku - Dugi'DBA on 25 November 2010

SSIS Denali Annotations

I have written a couple quick blogs recently sharing some of the new usability changes for SSIS in Denali.  In previous posts I wrote about Resolve References and Data Flow Grouping. 

Today I am writing about another quick tidbit.  Annotations are a feature that has been available in previous… Read more

1 comments, 226 reads

Posted in Devin Knight on 24 November 2010

How Do I Change SSRS Report Credentials with Powershell?

Today’s script took a long time to write. The concepts are fairly simple and the resulting script is quite trivial but the lack of easy to find documentation on Reporting Services administration via scripts meant I got to spend a lot of time with my good friend intellisense. In fact,… Read more

0 comments, 1,151 reads

Posted in Adventures in SQL on 24 November 2010

What I’m Thankful For

Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what they are thankful for, along the lines of Adam Machanic’s (@AdamMachanic) T-SQL Tuesday and now Jen McCown’s (@midnightDBA) UnSQL Friday. So this is my entry.

I have many… Read more

3 comments, 133 reads

Posted in Wise Man or Wise Guy on 24 November 2010

Holiday Review: Stuff I

For the last two years, I’ve participated in Sean’s InfoWorld Xmas Wish List, where we review a bunch of cool products and it’s all spiffy.  Sean has moved on from IW, and I’m not entirely sure we’re going to knock out a full review list this year.  So,… Read more

2 comments, 226 reads

Posted in SQL Awesomesauce on 24 November 2010

FreeCon

I got my FreeCon. What’s more, I did it in public and didn’t get in trouble.

FreeCon is the brain child of Brent Ozar (blog|twitter). Basically Brent gathered together a few bloggers & writers from the SQL Server community, some extremely well known, like Tom LaRock… Read more

5 comments, 416 reads

Posted in The Scary DBA on 24 November 2010

XQuery for the Non-Expert – Resources

Talk to the Experts

Learning XQuery can be a pain.  There are a lot of different uses for XML and different languages implement it in many different fashions.  To help clear the… Read more

6 comments, 560 reads

Posted in StrateSQL on 24 November 2010

Do the Packet Trace - Especially When Things Are Good

Last night we were troubleshooting really poor performance on a core system. One of the things being investigated was a network switch. On every interface of the network switch we were seeing flow control pause counters continually incrementing. This is usually an indication that the systems hooked to those interfaces… Read more

Are You Ready to Move to SharePoint for Microsoft BI?

I’m interested in hearing your response to this question.  Microsoft is investing aggressively in delivering Business Intelligence as a holistic platform for reporting, collaborating & sharing information.  The next generation of Microsoft self-service reporting tools will require SharePoint 2010 Enterprise Edition.  Some of the other enterprise BI vendors require heavier… Read more

0 comments, 185 reads

Posted in SQL Server BI Blog on 24 November 2010

Notes from SQLSaturday#59 - Waits & Queues Presentation

SQLSaturday#59 – Waits & Queues Presentation

At SQLSaturday#59 in NYC, my session was about Waits & Queues. I presented a topic I thought was sure to be known by the audience, and that the material would just be an introduction and reinforcement of some of the concepts of this performance… Read more

0 comments, 451 reads

Posted in Pearl Knows on 24 November 2010

I'm a Midnight DBA

Well, not really. However when I was recently up in Seattle, Jen and Sean McCown contacted me about being on their show and doing an interview. I agreed, and we met late, as in starting around 9:30pm one night, to do a sit down and interview.

It was totally off…

Read more

2 comments, 322 reads

Posted in The Voice of the DBA on 24 November 2010

Column Based Indexing in Denali

Recently, I was asked to install Denali for a client because one of the employees attended PASS 2010 and had seen a session about column based indexing. The client was really eager to begin testing in their environment to see what kind of performance boosts they would gain. As an… Read more

3 comments, 476 reads

Posted in BrianKMcDonald on 24 November 2010

XQuery for the Non-Expert – Exist

Talk to the Experts

In the previous post, I discussed the value() method as part of my XQuery for the Non-Expert series.  This next post will deal with a topic similar to…

Read more

3 comments, 938 reads

Posted in StrateSQL on 23 November 2010

What’s New In Denali for SSRS

I was so excited when I found out that Denali was released last week. Like it was Christmas time, I almost immediately went to download it and then I looked for what was new. J Unfortunately though, in the CTP that was released, there are no changes to Reporting Services.… Read more

3 comments, 218 reads

Posted in BrianKMcDonald on 23 November 2010

Newer posts

Older posts