- Please open this page in th… by Jason Brimhall
I am taking a slight deviation from the usual type of posts that I share. This time, I just want to share a quick and easy fix that I ran across due to a broken blog site that lasted for about a day starting on July 28th. I didn’t even know there was a problem[...]
- Top 10 Recommended Books… by Jason Brimhall
So the title says it all, right? Well, only really partially. Recently an article was published listing the top 10 most recommended books for SQL Server. That’s the part the title doesn’t say. It is really important to understand that we are talking about the top 10 recommended books for SQL Server. The beauty of[...]
- SSIS: Value does not Fall W… by Jason Brimhall
Every now and again I find myself working with SSIS for one reason or another. Every now and again I find myself fighting with SSIS because it provides less than useful error messages. This is one of those error messages that can be a pain until you understand what can be causing it. Albeit, that[...]
- Murder In Denver by Jason Brimhall
I am about to set sail on a new venture with my next official whistle stop. This year has been plenty full of whistle stops and I plan on continuing. You can read (in full) about previous whistle stops and why they are called whistle stops here. Suffice it to say at this point that it all[...]
- The SQL Sac wrap!! by Jason Brimhall
Every SQL Saturday leaves a mark of some sort. This time around, the folks in Sacramento have really helped leave a BIG mark. That’s right, this last weekend was SQL Saturday in Sacramento Ca. You might have seen my announcement about it here. This event had a lot of Unique flair to it. Besides having[...]
- July 2014 Vegas UG Meeting by Jason Brimhall
Coming up this week is the Vegas UG meeting. Keith Tate has been gracious enough to accept our speaker invitation and will be presenting. The meeting will be held 10 July 2014 at 6:30 Pacific. Location and time details can be found on our meetup page. BIO Keith Tate is a Microsoft Certified Master in SQL[...]
- Is your Team Willing to Tak… by Jason Brimhall
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community, this means a little party as many of you may already know. This is the TSQL Tuesday Party. This month represents the 56th installment of this party. This institution was implemented by Adam Machanic (b|t) and[...]
- Free SQL Training In Sacramento by Jason Brimhall
In a few short days the newest SQL Saturday event. This one will be on the far West coast of the United States. This marks the first time for me to present at a SQL Saturday so far West. From where I live, I have had to travel East for every SQL Saturday so far.[...]
- Using Synonyms to Extend SSIS by Jason Brimhall
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for you nor for your data nor for your database. Recently I wrote an article about some good and some bad with synonyms. You can read that[...]
- Auditing and Event SubClasses by Jason Brimhall
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields related to auditing as it stands in SQL Server. In talking to the person who raised the valid concern about the lack of good documentation, I[...]
- Dan Hess about The SQL Sac wrap!!Thanks for coming, Jason, it was great to meet you. Pencil us in for next year!
- Jason Brimhall about The SQL Sac wrap!!We thought it was pretty slick. And it was great for much conversation.
- Andy Warren about The SQL Sac wrap!!I'm envious of that gift - nice!
- Jason Brimhall about Last Known Good CheckDBThanks Robert. Glad to hear this was useful to you.
- Robert Every about Last Known Good CheckDBJason: T-SQL code you shared at http://jasonbrimhall.info/2012/11/20/last-known-good-checkdb/ is EXACTLY what I need! Thanks a whole bunch. I'd like to add you to my …
- Jason Brimhall about Can you partition a tempora…Thanks Wayne.
- Wayne about Can you partition a tempora…Nice post Jason. I sure hope that a temp table never gets so big that partitioning becomes desirable!
- Jason Brimhall about Can you partition a tempora…Thanks Joey. I should do a follow up on temp table compression. I have it in my presos …
- Joey D'Antoni about Can you partition a tempora…Jason-- Cool post--One thing I wanted to add is that you can also compress a temp table. We had a use …
- JSWhite about Missing Indexes Script v2Excellent script, thank you!