Restarting SQL Server using a Batch Script

In a previous post, I showed you how one could Restart, Stop and Start the services for an instance of...

Restarting SQL Server using the GUI

Sometimes you may need to restart your instance of SQL Server. You should rarely do this on Production boxes, but...

Jax Code Camp - My Presentation and Projects

First and foremost, I want to thank everyone who attended my presentation today. It got off to a late start due...

How Many Columns In Table and Which Have Identity Columns

I recently had to find a way to look up how many columns were in a table and which of...

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...