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
1 reads
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
1 reads
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,158 reads
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
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
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
Normally when I write a blog, I start out will a Hello to my Dear Reader. Not today. This was...
2016-02-29
971 reads
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
Hello Dear Reader! Last week I posted the invitationto T-SQL Tuesday #73. The premise?
“As you work with SQL Server...
2015-12-08
639 reads
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
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
By Will Assaf
I recently reviewed, worked on, and added a similar example to the DATETIMEOFFSET Microsoft...
Database administrators (DBAs) are the backbone of data-driven organizations. If you're looking to break...
By Brian Kelley
Another security fundamentals topic is authentication versus authorization. For those who have a clear...
I have a SQL Server 2019 Enterprise Edition on CU 25. It has in-memory...
Experts, I am learning some skills so I can troubleshoot some performance-related issues. I...
What happens when I run this code:
SELECT p.ProductName , p.ProductCategory FROM dbo.Product AS p WITH (NOLOCK, TABLOCK);See possible answers