- Internal Tables and Space Used by Jason Brimhall
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.
- What’s the Size of th… by Jason Brimhall
When you need to figure out how indexes are contributing to the overall size of a table within a database, this script will help you!
- Extended Events Removed from 2016 by Jason Brimhall
Extended Events continue to grow and improve – even with the removal of a few events.
- TSQL Recipes – 2014 Edition by Jason Brimhall
Announcing…the book At long last the wait is over. After much blood, sweat and more blood and sweat, the next edition of the SQL Server Recipes book is finished. This edition brings several changes and quite a bit of re-write. It has been updated for many of the new SQL Server 2014 (well, new, at[…]
- Murder and XE Train in Louisville by Jason Brimhall
Bringing years of experience together in two all day workshop sessions.
- SQL Server and Defaults by Jason Brimhall
What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the OS has a bunch of settings that are predefined. These are notoriously the default settings. Or as some would say: “Set it and Forget it Settings.”[…]
- PASS Summit 2015 – Gu… by Jason Brimhall
Quick run the other way! PASS Summit will never be the same! Why? Well, because for the first time in the history of me, I have been selected to speak at such a prestigious event. Isn’t that just crazy? In some ways it seems crazy. When I received the email I was exhilarated and completely astonished.[…]
- Database Settings Changes &… by Jason Brimhall
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that the change has occurred and nobody claims to have any knowledge of it or having done the deed. This happened again recently where a database was[…]
- In memory of Grandpa Greenland by Jason Brimhall
Dan “L” Greenland (1935 ~ 2015) Dan “L” Greenland, 80, passed away June 30, 2015. Born June 3, 1935 in Highland, Utah, to William John and Cressie Althera Loveridge Greenland. He grew up in Highland and attended schools in American Fork. Graduated from American Fork High School in 1953. Married his high school sweetheart, Eleanor Bunker, October 21,[…]
- New Extended Events for 2016 by Jason Brimhall
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available to us in order to help support and troubleshoot these new features. With that, it is well worth a look[…]
- Jason Brimhall about Adventures with NOLOCKI think you missed the point. The article was a quick demonstration to remind people that the NOLOCK directive is …
- Viktor Stolbovoy about Adventures with NOLOCKI'd never think that the fact that nolock causes dirty reads is a surprise for anyone who use even semiconsciously. …
- Jason Brimhall about Audit who Dropped the DatabaseFor SQL Server 2012 you will need to use the Map Key value instead of the value name. In this case …
- Abhinav Singh about Audit who Dropped the DatabaseI'm on SQL 2012 SP2 and getting the following error: Msg 25713, Level 16, State 23, Line 1 The value specified for …
- Jason Brimhall about SQL Cruise Mediterranean+I have intended to write an article on that and have yet to put out the article. Basically, resources just …
- Scott R. about SQL Cruise Mediterranean+Thanks for this feedback on the value of SQL Cruise. Although I have not yet attended one, I may …
- Jason Brimhall about Execution Plans in Extended EventsThanks Hennie, glad you liked it.
- Hennie Leach about Execution Plans in Extended EventsSurely you can get around that by adding a filter on the IO's. One are generally pulling execution plan's for …
- Shiv about Adventures with NOLOCKNOLOCK to me has always been about dirty reads, and as side affect you could avoid some locking conflicts and …
- Luis Cazares about Adventures with NOLOCKUsing Microsoft SQL Server 2012 (SP1) - 11.0.3153.0 (X64) I could effectively reproduce this with a table as long as …