Speaking at SQL Saturday 89
With a late cancellation with one of our speakers a hole was opened on our speaker lineup. I reached out...
2011-09-14
422 reads
Tim Radney
SQL Saturday #97 – Austin TX
The schedule for SQL Saturday 97 has been posted and I was selected to give my “It’s TempDB, Why Should...
2011-09-08
461 reads
SQL Saturday #89 is 10 days away
I just 10 short days Atlanta GA will be hosting the most stellar lineup of speakers SQL Saturday has ever...
2011-09-07
445 reads
When technology works.
Living in the South East has it perks with the abundant rivers, lakes, streams, mountains, and friendly people. It also...
2011-09-05
405 reads
It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to...
2011-09-01
434 reads
Shrinking Transaction Logs
I see questions on forums all the time about DBA’s or System Admins finding they are out of drive space...
2011-08-31
2,183 reads
PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for...
2011-08-30
1,394 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
685 reads
Adding an Index to Save Space
Sounds weird right, but that is exactly what has happened with a VLDB I inherited. A third party database that...
2011-08-17
1,024 reads
Steel City SQL User Group
Tonight I will be doing a presentation on TEMPDB to the Steel City SQL Users Group in Birmingham AL. I...
2011-08-16
542 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