SQLMCM Training – Day 18
Today we covered the topics Full Text Search, Change Data Capture, Change Tracking,
and Service Broker. I have taken no notes...
2011-08-26
978 reads
SQL Server – CTP is now available for SQL Server 2008 Service Pack 3
CTP has been made available earlier this week for SQL Server 2008 SP3 on Download Center. Read this MSDN blog...
2011-08-25
743 reads
Create a Log Backup Schedule – #1 Skill You Need
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-25
1,014 reads
PASS Update #63 (How Do We Rate)
A short update today, following up on an email to the Board from incoming VP of Finance Douglas McDowell who...
2011-08-25
798 reads
Building A New Storage Test Server
We’re Gonna Need A Bigger Boat
Not to sound too obvious, I test IO systems. That means from time to time...
2011-08-25
2,186 reads
Index Disabled and Index Rebuild
I received the following message from a Developer. The message was on a Test SQL Server
“NC_myIndex " on table "VeryLargeTable" (specified...
2011-08-25
1,822 reads
Reading SQL Error log
SQL Error log can be read from SQL Server's management studio. However, Management studio is too slow and definitely not...
2011-08-25
429 reads
SQLMCM Training – Day 17
Today Bob spoke about Auditing, SQLCLR, XML, and Spatial Data. Because I already know
these concepts very well, my study notes...
2011-08-25
680 reads
Learning Transactional Replication
I have been working on a new skill this week and that is implementing transactional replication. I am of course...
2011-08-24
705 reads
SQL Server – sp_help without arguments.
sp_help returns information about database objects and types.
@object_name argument is optional for sp_help. When executed without any argument it returns...
2011-08-24
2,504 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers