Thoughts on Database Mail
I suspect few would argue that database mail in SQL 2005 is a huge improvement over the mail system in...
2008-04-07
305 reads
Blog Posts
A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
417 reads
Jacksonville SQLSaturday less than a month away!
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based...
2008-04-05
535 reads
SQL Server Forensics Book
I logged into Safari today to download some chapters I want to be able to review when I'm offline. I...
2008-04-05
1,268 reads
Changing Dynamics on a Project Team
MVP Andy Leonard has written a nice post about how the dynamics changed on a project team. Most of it...
2008-04-04
599 reads
Configuring SPN for SQL Server Browser service
Going through the Microsoft KnowledgeBase updates, I saw this one:
An SPN for the SQL Server Browser service is required when...
2008-04-04
2,496 reads
Installing 5.0.51a MySQL Community Edition on Windows Vista
I'm still working on getting all of my tools and apps onto my new laptop, which is running Vista Ultimate....
2008-04-04
2,529 reads
Cheap But Good KVM Switch
I needed a KVM (keyboard-video-mouse) switch for home to let me switch between two machines, found the Trendnet 2 Port...
2008-04-03
327 reads
MVP Award
Yesterday I found out that I am a new SQL Server MVP. I still have the feeling that I am...
2008-04-02
383 reads
Other Thoughts on Brand Building
Just a link today, but a good one on Building a Powerful Reputation that is a nice follow up to my...
2008-04-02
464 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
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
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