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...
2010-08-29
12,724 reads
BrianKMcDonald
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...
2010-08-29
481 reads
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...
2010-08-28
415 reads
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...
2010-08-20
418 reads
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...
2010-08-18
539 reads
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...
2010-08-18
446 reads
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....
2010-08-15
367 reads
Pesky Protected Mode
How many of you keep falling for this one…You open up Report Manager for a user that you know you...
2010-07-29
1,468 reads
Commenting TSQL Scripts
If you have ever searched for “commenting in TSQL” scripts, I am sure that you’ve found hundreds or maybe even...
2010-07-29
1,747 reads
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...
2010-07-29
479 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Timeout Error while executing a TSQL statement in Sql server Express Edition
I am getting the below error when I execute a SQL command in SQL...
Sql script replace and rearrange numbers
Hi everyone. I have this table and this information. (left side of the image)...