Webcast – Small Changes Can Make a World of Difference
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my...
2014-03-18
438 reads
Matan Yungman
A Community Challenge
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
Among other...
2014-03-05
607 reads
The Strange Story About the MERGE that Killed the Cluster
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a...
2014-02-20
4,387 reads
Know When it’s Good Enough
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love...
2014-01-28
703 reads
Things I Learned in 2013
It’s 2014 now. I hope you had fun in new year’s eve.
2013 was an amazing and intense year. To recap...
2014-01-02
782 reads
T-SQL Tuesday #49: Using CXPacket Waits to Detect Query Bottlenecks
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
This tradition was started by Adam...
2013-12-10
1,411 reads
Interviews with Brent Ozar, Adam Machanic and Denny Cherry for SQL Server Radio
While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter)...
2013-12-09
542 reads
My SQLRally Experience
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got...
2013-11-11
766 reads
How to Limit IO Requests with SQL Server 2014 Resource Governor
Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource...
2013-10-09
2,236 reads
How to Become a Better DBA
Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become...
2013-08-30 (first published: 2013-08-26)
3,828 reads
Blogs
PASS: Quantum Computing Slides
By Brian Kelley
If you're an attendee at the PASS Data Community Summit this year, there are...
A New Word: Dead Reckoning
By Steve Jones
dead reckoning– v. intr. finding yourself bothered by somebody’s death more than you would...
PASS Data Community Summit 2025 Slides and Code
By alevyinroc
Thank you for attending my PASS Summit 2025 session Answering the Auditor’s Call with...
Forums
Personal Contact Is Vital
Comments posted to this topic are about the item Personal Contact Is Vital
Getting the Schema for Tables
Comments posted to this topic are about the item Getting the Schema for Tables
An Unexciting Exciting Release
Comments posted to this topic are about the item An Unexciting Exciting Release
Question of the Day
Getting the Schema for Tables
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'Person.Person')) AS [Object Definition]; GOSee possible answers