Time Off, Down Time, Round Up
I have taken some time off this week, I have been to the beach with my two golden retriever puppies....
2010-03-04
679 reads
Gethyn Ellis
SQL Server - MVP Deep Dives
I got my copy of MVP deep dives earlier this month and have been making good progress in reading some...
2010-03-02
853 reads
SQL Agent – Giving non-SA users permissions on jobs
There are some new database roles in the MSDB database in SQL Server 2005 that allow you to grant more...
2010-02-28
15,103 reads
Renaming a Standalone Instance of SQL Server
I needed to upgrade the underlying IO subsystem of one of my IO intensive SQL Servers. After some discussion with...
2010-02-25
2,064 reads
Setup a Database Snapshot
I have been tinkering lately with database snapshots and I thought the subject warranted a short post on the subject....
2010-02-23
739 reads
SQL Server 2005 CLR execution error after restore
I recently restored a SQL Server 2005 database to a testing environment. The database contained several CLR assemblies, when the...
2010-02-21
1,124 reads
sys.dm_os_wait_stats
This is a short note explaining he sys.dm_os_wait_stats DMV.
This DMV returns the following columns/values regarding waits encountered by executed...
2010-02-18
1,303 reads
SQL Server - Checkpoint
What is a SQL Server checkpoint?
A SQL Server checkpoint is the process of writing all dirty datafile pages out to...
2010-02-16
6,826 reads
SQL Server 2005 SP4!
Microsoft has recently announced the planned release dates for the next round of SQL Server service packs. SQL Server 2008...
2010-02-14
689 reads
Useful reading this week
This is a short post for a Sunday afternoon, I thought I’d share some useful reading from the week gone...
2010-02-14
859 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)...