SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: November 2010

Determining An Enterprise Execution Policy Setting

Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to run. The various execution policy settings are described in about_Execution_Policies. Run Get-Help about_execution_policies or see the online version for additional information.

The default setting for the execution policy is restricted… Read more

1 comments, 2,170 reads

Posted in Chad Miller on 28 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, 565 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, 909 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, 2,333 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, 618 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, 1,748 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, 894 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, 764 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, 582 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, 4,838 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, 538 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, 514 reads

Posted in SQL Awesomesauce on 24 November 2010


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, 1,446 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, 1,477 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, 492 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, 875 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, 762 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, 859 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, 2,035 reads

Posted in StrateSQL on 23 November 2010

Newer posts

Older posts