Re-blog – August 19-August 25
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-08-26
581 reads
Side by Side installation of SQL Server 2008 and SQL Server 2008 R2
Recently I had to install SQL SERVER 2008 R2 BIDS on top of a machine which already had SQL SERVER...
2011-08-26
2,025 reads
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
742 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
797 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,821 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
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers