SQL Azure, Hekaton, and Bob Dorr is Awesome
Hello Dear Reader! I had recently written a blog for the PFE blog, "How Many Tables Can I Have In SQL Azure DB & SQL Server". It was...
2016-08-29
2 reads
SQLBalls
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an...
2016-06-01 (first published: 2016-05-20)
2,167 reads
SQL Server Random Workload Generator
Hello Dear Reader! Before I start this blog I want to give credit to Jonathan Kehayias (@SQLPoolBoy | Blog). He’s an Microsoft Data Platform MVP, MCM, part of the...
2016-05-20
2 reads
SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security
Hello Dear Reader! I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events! Today my friend Dan Taylor...
2016-05-06
613 reads
SQL Saturday Jacksonville #552 Pre-Con: A Day of DBA Fundamentals- Install- Maintenance plans-and Security
Hello Dear Reader! I'm here in beautiful Jacksonville FL for the SQL Saturday 552 events! Today my friend Dan Taylor (@DbaBulldog | Blog) and I are presenting our Pre-con...
2016-05-06
Goodbye Pragmatic Works
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was...
2016-02-29
972 reads
Goodbye Pragmatic Works
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was almost a blog I didn't write because I...
2016-02-29
T-SQL Tuesday #73: IOPS on Azure VM's Naughty to Nicer
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise?
“As you work with SQL Server...
2015-12-08
640 reads
T-SQL Tuesday #73: IOPS on Azure VM's Naughty to Nicer
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise? “As you work with SQL Server look around you. Is your environment Naughty or Nice? ...
2015-12-08
T-SQL Tuesday #73 Invitation – Naughty or Nice?
Hello Dear Reader! This is the first Tuesday of the month and you know what that means. It’s time to...
2015-12-07 (first published: 2015-12-01)
1,722 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