SQL Server 2008 MCM Results
SQL Server 2008 MCM Results
3 weeks of intense training, intense studying, 3 written tests, and one 6 hour lab exam....
2010-04-04
1,434 reads
SQL Server Soldier :: News from the frontlines of the database wars
Making Sense of Replication Errors in Replication Monitor
Making Sense of Replication Errors in Replication Monitor If you've ever had to deal with errors in Replication Monitor, your first...
2010-03-27
11,998 reads
Measuring Transactional Replication Latency Without Tracer Tokens
Measuring Transactional Replication Latency Without Tracer Tokens SQL Server 2005 introduced Tracer Tokens (SQL 2005 | SQL 2008), a new methodology for...
2010-03-25
7,022 reads
Twas the Night Before the MCM ...
T'was the Night Before the MCM ...
SQL Server MCM starts tomorrow. My wife thinks it's cute that I'm excited. The...
2010-03-14
965 reads
Finding Date Ranges for Calculating Statistics
Finding Date Ranges for Calculating StatisticsI received the following question from a fellow DBA:
I need your input to derive the...
2010-03-14
1,692 reads
Top 6 Myths of Transaction Logs
Top 6 Myths of Transaction Logs I think there is a lot of misunderstanding concerning database transaction logs in SQL Server. I...
2010-03-10
4,502 reads
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
T-SQL Tuesday #004: IO -- Where Are My TempDB Objects?
This blog entry is participating in T-SQL Tuesday #004, hosted this month...
2010-03-09
1,442 reads
SQL LiteSpeed Error: XML returned from Engine was invalid
SQL LiteSpeed Error: XML returned from Engine was invalid
This is a very common error returned from SQL LiteSpeed. So what...
2010-03-06
2,866 reads
Breaking Down TempDB Contention
Breaking Down TempDB Contention
What is tempDB contention? From the outside looking in, tempDB contention may look like any other blocking. There...
2010-03-05
81,148 reads
Do I have to snatch the pebble?
Attending the Microsoft Certified Master (MCM) program in March
This is the most excited I've been since I heard that Alice...
2010-02-17
807 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
Compare rows within the same table
I have a table. Structure in script below. I have to compare and see...
Microsoft Recommendations for Update Stats?
I have an application team that is insisting on daily (and for some, weekly)...
how can i tell if our db2 driver is ms or ibm or other?
i see this in the definition of a linked server on our wh sql...
Question of the Day
A Strange Result
What does this code return in SSMS 20 from SQL Server 2019?
select '|' + CHAR(0)+'abc' + '|';See possible answers