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
SQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended Events enhancements, and more.
But there are other little and less known tweaks that might seem less revolutionary, but can make our lives much easier. Below are a few of them:
24 Hours of Pass is tomorrow. If you haven’t registered yet, now is a good time.
I expect to:
- Have little to no sleep time
- See some cool tricks like this one pulled out of someone’s sleeve
- Expand my troubleshooting and performance tuning arsenal
- Practice my architectural and database…