JSSUG Tomorrow Night - 8/18/2010

I heard a little birdy cherping and it looks like there is going to be a great give away tomorrow...

When Did I Install SQL Server?

While getting prepared for an upcoming presentation, I remembered that I installed the November CTP trial on the machine that...

Forgetful Fred and SQL Server Management Studio

Scott Gleason just posted a blog yesterday that showed an awesome new tool that people can create little animated videos....

Checking Users AD Groups Using Windows CMD

Blog Title: Checking Users AD Groups Using Windows CMD

Depending on your role in the organization, there may be a time...

Commenting TSQL Scripts

If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...

Indexes and their Effect on Query Performance

Indexes play a huge role in the performance of a query. Without indexes, you very simple query to get the...

Limiting Table Access for Reporting Part 1

End users may have a need to do some form of reporting of data from source systems. Opening up the...

Limiting Table Access for Reporting Part 2

Blog Title: Limiting Table Access for Reporting Part 2

In the first blog post of this series, I showed you how...

Pesky Protected Mode

How many of you keep falling for this one…You open up Report Manager for a user that you know you...

What Indexes are on My Table!

In this quick blog, I want to show you one way of how to find out what indexes you have on a table...