On Saturday, I had the pleasure to present my session, “Things You Can Find in the Plan Cache”, at SQLBits!
Thanks to everyone who attended my session.
The scripts and presentation can be downloaded here.
About two months ago, after two and a half years, I left Microsoft.
Microsoft is an amazing place to work for. It’s comfortable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined… Read more
About two months ago, after 2.5 years, I left Microsoft.
Microsoft is an amazing place to work for. It’s conformable, balanced, challenging and educating. I feel like the factors of my maturity and interests, the challenges I had to face and the people I worked with, combined perfectly to make… Read more
Over the time as a SQL Server professional, I’ve come to an understanding about 3 important interview-related factors you’ll need in order to find a job you’ll love (Of… Read more
This Thursday, 10AM GMT, I will be hosted by Dell’s Richard Douglas (blog|twitter) for a webcast. I will present my session called “Small Changes Can Make a World of Difference”, talking about a bunch of “small” features that were introduced in SQL Server 2012 and 2014,… Read more
Earlier this week, I delivered a presentation called “Query Progress Tracking in SQL Server” to my local user group.
The issue is that using… Read more
I don’t like the MERGE statement. The syntax is weird, it’s tricky in terms of locks, and it has a history of weird errors. The other day a developer wanted my help in troubleshooting a MERGE that caused an ACCESS VIOLATION error and a stack dump generation. That… Read more
Here’s a newsflash: You may not thing so, but you are expensive. There’s no point in endless performance tuning. I love performance tuning a lot, and even more, I love challenges. But sometimes taking a query from the “good enough zone” down to “super-performance zone” will take a lot… Read more
2013 was an amazing and intense year. To recap it, I thought about sharing some of the things I learned:
- I love Parallelism. Once you get used to look for parallelism options in your queries, and…
This post is for T-SQL Tuesday #49, the monthly blog party of the community.
It’s Friday, Friday
It… Read more
While in SQLRally Amsterdam, I had the honor to interview Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter) to the Israeli SQL Server Radio, the Podcast I co-host with Guy Glantser (blog | twitter Read more
The past week I had the pleasure to attend SQLRally Amsterdam.
I took a flight from Tel-Aviv to Amsterdam and got there on Tuesday morning, which left me a whole day to get around the city. I traveled in the city center, ate a delicious pancake, drank a lot of… Read more
Resource Governor was introduced in SQL Server 2008 in order to allow us have better control over our system resource consumption. With Resource Governor, we can divide our users to groups, when each group gets a certain percent of our resources. That way, we can reduce the risk of a… Read more
Whether you’re just starting out or already a few years in the game, you’re probably wondering how you can become a better DBA.
Here’s what works for me:
1. Learn a Lot…of what you Find Interesting
There are no shortcuts – You have to learn. But it’s a lot easier… Read more
We were three: A DBA, a developer and a tester.
Our mission: To develop an ongoing process that will transfer one of our biggest and busiest tables to the cloud. Here’s the story of how we did it:
- Transfer the table insert and updates to Azure in a…
We talked about the best Podcast and video sites out there. Due to some technical issues we couldn’t talk about… Read more
Five months ago, I wrote a post about my love for Podcasts.
At some point, I started to think about starting a Podcast that will be addressed to the Israeli SQL Server community.
New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that matter the most.
SQL Server 2014 is coming. Go ahead and download the public CTP.
I’ve just started getting my hands dirty with the new version. Based on that and on the stuff that has already been published, here’s a few thoughts:
SQL Server 2014 is Mature
Microsoft takes care of… Read more
I’m 30 today.
In addition, it’s been 10 years since I started working with SQL Server.
In my twenties, I fell in love with T-SQL and SQL Server, got to a point I felt I needed a break, and came back fully energized.
One of my favorite parts of being… Read more