Replication Snapshot Errors Caused By Compatibility Level Setting
I ran across an interesting replication error recently that's worth sharing. It happened while using a distributor running SQL 2008,...
2009-07-22
440 reads
Kendal Van Dyke
SQL Quiz #4 - Leadership
Chris Shaw posts SQL quiz #4, I make an observation on Twitter about who gets tagged, Brent Ozar tags me...
2009-07-14
706 reads
The Best Thing I Learned At PASS
Note: I'm writing this as part of the "Best Thing I Learned At PASS" contest. Why? Because if I win...
2009-07-01
750 reads
See You In Seattle For PASS 2009!
Last Friday I got the official notice that I've been selected to present a community session at the 2009 PASS...
2009-06-15
458 reads
Speaking At Space Coast SQL Users Group On June 11
Just a quick note to mention that I'm speaking at the next Space Coast SQL Users Group on Thursday, June...
2009-06-09
412 reads
Inside A Datacenter
I spent the last 4 days in Denver helping my company move in a new datacenter and while I was...
2009-05-20
572 reads
SQL Saturday Jacksonville Recap
Note: I intended to post this last week but life\work\burnout and installing Windows 7 RC got in the way.
Another weekend,...
2009-05-12
427 reads
SQL Saturday Atlanta Recap
I had a great time at SQL Saturday Atlanta last weekend. I drove from Orlando to Atlanta on Friday with...
2009-04-29
1,526 reads
PASS Summit Sessions Submitted
It's official – I've submitted my abstracts for the 2009 PASS Summit and received my confirmation. Now I wait to see...
2009-04-24
654 reads
Register A Server More Than Once In SSMS
In yesterday's post about using SQL 2008 Express as a Central Management Server I mentioned that you can't register a...
2009-04-21
540 reads
Blogs
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
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...
normal role member to be able to view list of other role members in his DB
Is this even possible ? Tried with grant but to no avail. [sys].[database_role_members] and...
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