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
For most DBAs, Management Studio is the primary work tool.
That’s why properly using it can save a-lot of time and effort.
Here’s a few tricks that can improve your productivity when working with it:
1. Snippets and Keyboard Shortcuts
The amount of time these two features saved me is… Read more
I came across a cool open source tool called “SQL Space Map“.
The tool, written by Ryan McCauley, presents a visual representation of table and index sizes:
It can be very handy when you need to quickly understand what are the main tables in a database.
It… Read more
I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard and watched, as well as to other interesting stuff. Each category will usually have 3-5 links, depending on my pace and focus on that week.
Below are the links… Read more
Views, table variables and local variables are great in terms of programming principles.
But In terms of performance, they can be a honey trap: They don’t scream “DANGER!” like cursors or user defined functions, but they can cause serious problems very easily.
That’s why I call them “The… Read more
One of the most fundamental DMF’s a SQL Server DBA should know is sys.dm_exec_query_plan.
This Dynamic Management Function allows us to see the Execution Plan for queries that are either currently running or have been cached.
For example, the following query will return the plan for queries that are currently… Read more
Assuming you’ve been on earth lately, you probably heard the terms “Big Data”, “Hadoop”, “NoSQL” and so on.
Companies want to check what they can do with Hadoop, trying to understand what Big Data is and how it can generate more income. Big Data experts pop up on LinkedIn, newspapers… Read more
About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.
Today, I want to talk about the various video sources for SQL Server (luckily for us, there are lots of them).
The video medium is great because you can view sessions from… Read more
Two weeks ago I delivered a presentation called “Things You Can Find In The Plan Cache” to the israeli SQL Server user group. Among the subjects we talked about were:
- Why the Plan Cache is needed
- The right ways to work in order to increase plan reuse
- Plan Cache Dynamic…
About a year ago, I came across an online deal for a car stereo system with a USB port.
After the purchase, I had to wait a long time until the guy at the shop installed the system, but after passing this hurdle, it turned out to… Read more
I read this awesome post by Joe Sack, titled “Detecting Cardinality Estimate Issues with sys.dm_exec_query_stats”.
I was amazed by the beauty of his detection query, ran it on my environment, and discovered some interesting things.
Then I revised it a little to reveal more information and filter out more… Read more
Usually, a database is meant to serve some kind of application, and .Net applications have a few possible ways to query the database.
In this post we will see how ADO.Net queries, NHibernate, Linq to SQL and Entity Framework query the database, and how it affects SQL Server Plan Cache… Read more