Great News! SSMS Tools Pack 1.9 is Coming Out!
Mladen Prajdic recently announced that the newest version of SSMS Tools Pack is coming out and I am excited.Continue reading ?
The post Great News! SSMS Tools Pack 1.9 is...
2010-08-20
How Can I Quickly Script Out Replication?
I recently finished taking down a bunch of servers that I was using to scale out my environment by forcing...
2010-07-16
511 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
4 reads
How Can I Quickly Script Out Replication?
This script takes a distribution server name and an output directory as parameters then works through all publications on each of the servers that connects to the distribution server,...
2010-07-16
2 reads
What is an Easy Way to Return Results from a CLR Stored Procedure?
Introduction
What is an Easy Way to Return Results from a CLR Stored Procedure? The question sounds simple enough but yet...
2010-07-07
993 reads
What is an Easy Way to Return Results from a CLR Stored Procedure?
This post describes a helper class that I came up with to handle returning values from a CLR stored procedure. Continue reading ?
2010-07-07
136 reads
What is an Easy Way to Return Results from a CLR Stored Procedure?
This post describes a helper class that I came up with to handle returning values from a CLR stored procedure. Continue reading ?
The post What is an Easy Way...
2010-07-07
2 reads
Why Would a Delete Make My Database Grow?
Introduction
A while back I had a developer come to me complaining that every time they ran a large delete statement...
2010-06-01
982 reads
Why Would a Delete Make My Database Grow?
A while back I had a developer come to me complaining that every time they ran a large delete statement on a certain database the delete would fail with...
2010-06-01
3 reads
Why Would a Delete Make My Database Grow?
A while back I had a developer come to me complaining that every time they ran a large delete statement on a certain database the delete would fail with...
2010-06-01
1 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)...