The Wickedness of the mass 'REPLACE()'
I have been admonished in the past for the use of this code which makes as many
substitutions as you like...
2009-01-23
1,158 reads
Blog Posts
Influence
I saw Paul Kenny of Ocean Learningspeak about sales least year at the Business of Software Conference. I thought he...
2009-01-22
903 reads
Read-Only Access to SQL Server Jobs
This question comes up a lot: how do I give read-only access to job status to a group of people?...
2009-01-22
4,052 reads
The Story of Pumpkin Man
Another story from a previous job. I joined the company in August, in October they started prepping for Halloween - it...
2009-01-22
932 reads
What Do You Want Auditors to Know About Auditing SQL Server?
Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...
2009-01-22
1,100 reads
Mastering SQL Server Profiler E-Book Available for Free
After a lot of delays, my book on how to use SQL Server Profiler has been published by Simple-Talk Publishing,...
2009-01-21
4,396 reads
Notes from the January 2009 oPASS Meeting
We had our first oPASS meeting of the year last week with about 18 attending. Jonathan Kehayias was our featured...
2009-01-21
683 reads
Play the T-SQL Alphabet Game
I recently had the opportunity to play the T-SQL Alphabet Game, which was introduced to me by SQL Server MVP,...
2009-01-21
1,253 reads
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
686 reads
Conficker / Downadup Worm One More Time
Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...
2009-01-20
909 reads
Blogs
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
Forums
Jabatan Imigresen Certified Translators: Trusted Support for Official Documents
When preparing documents for immigration in Malaysia, accuracy and compliance are essential. Working with...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers