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
299 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
413 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
530 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,245 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
592 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,363 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,434 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
321 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
373 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
458 reads
Blogs
Daily Coping 20 May 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 19 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Running dynamic SQL in a different database
This is one of those things that on hindsight was a stupid problem, but...
Forums
Recover SQL Server 2012 from file backups
In a ransomware disaster recovery situation, we have a physical server that we are...
Running Trace - Error: Login timeout expired
Hi All, We have Project server 2019 (Sharepoint). The database server (Only Database services...
query perf issue
Hi Everyone, Good morning. I am new to Sql administration.Have one question. We work...
Ask SSC