- Passion, Challenges, and SQL by Jason Brimhall
One of my biggest reasons why I do what I do, boils down to the challenges that I frequently get to encounter. There is a wild satisfaction to working on a very difficult and challenging task, product, tool, profession, skill, etc. This satisfaction often involves reward and a sense of accomplishment.
- Interview Trick Questions by Jason Brimhall
Anybody that has interviewed for a job has most likely run into the trick question. Some interviewers like to throw out multiple trick questions all in an effort to trip up the candidate and get the candidate to doubt him/her self.
- Defaults In msdb Database by Jason Brimhall
The defaults in the msdb database are about what is missing. It’s missing quite a few things that could be critical to your environment.
- Easy Permissions Audit by Jason Brimhall
This is an introductory level method demonstrating how to quickly audit database objects and principals for granted permissions.
- Audit SQL Agent Jobs by Jason Brimhall
One probably seldom thinks of the SQL Agent jobs scheduled on the SQL Server instance – unless they fail. What if the job failed because something was changed in the job? Maybe you knew about the change, maybe you didn’t.
- Quick Permissions Audit by Jason Brimhall
DBAs often need to figure out who has access to what. When that need arises, it is frequently adequate to just perform a quick permissions audit.
- Automating like an Enterprise DBA by Jason Brimhall
One of the things that should seem very commonplace to a data professional is the effort to become a lazy DBA. A lazy DBA is not a bad thing. It just means the DBA works hard to automate the repetitive mundane tasks that may be tedious and/or time consuming.
- ArithAbort and SQL Agent Failures by Jason Brimhall
ARITHABORT can be a short termed head scratcher. Pay close attention to what has changed in the environment. Test alternatives. And check those connection strings.
- Short Circuiting Your Session by Jason Brimhall
It isn’t very often that one would consider a short circuit to be a desired outcome. In SQL Server we have a cool exception to that rule – Extended Events (XE).
- Automatic Tuning Monitoring… by Jason Brimhall
Thanks to Extended Events (XE), we have access to a guide of sorts that will help us better understand if our shiny new tool (automatic tuning) is operating as desired.
- News ( 644)Recent Posts
- Passion, Challenges, and SQL by Jason Brimhall
- Interview Trick Questions by Jason Brimhall
- Defaults In msdb Database by Jason Brimhall
- Easy Permissions Audit by Jason Brimhall
- Audit SQL Agent Jobs by Jason Brimhall
- Professional ( 633)Recent Posts
- Passion, Challenges, and SQL by Jason Brimhall
- Interview Trick Questions by Jason Brimhall
- Defaults In msdb Database by Jason Brimhall
- Easy Permissions Audit by Jason Brimhall
- Audit SQL Agent Jobs by Jason Brimhall
- SSC ( 534)Recent Posts
- Passion, Challenges, and SQL by Jason Brimhall
- Interview Trick Questions by Jason Brimhall
- Defaults In msdb Database by Jason Brimhall
- Easy Permissions Audit by Jason Brimhall
- Audit SQL Agent Jobs by Jason Brimhall
- SQLServerPedia Syndication ( 301)Recent Posts
- Passion, Challenges, and SQL by Jason Brimhall
- Interview Trick Questions by Jason Brimhall
- Defaults In msdb Database by Jason Brimhall
- Audit SQL Agent Jobs by Jason Brimhall
- Automating like an Enterprise DBA by Jason Brimhall
- Extended Events ( 114)Recent Posts
- Easy Permissions Audit by Jason Brimhall
- Audit SQL Agent Jobs by Jason Brimhall
- Quick Permissions Audit by Jason Brimhall
- Short Circuiting Your Session by Jason Brimhall
- Automatic Tuning Monitoring… by Jason Brimhall
- TSQL Tuesday ( 77)Recent Posts
- Passion, Challenges, and SQL by Jason Brimhall
- Automating like an Enterprise DBA by Jason Brimhall
- T-SQL Tuesday Participation… by Jason Brimhall
- T-SQL Tuesday 109: Influenc… by Jason Brimhall
- To Influence or Be Influenced? by Jason Brimhall
- Scripts ( 74)Recent Posts
- T-SQL Tuesday #108: New Hor… by Jason Brimhall
- Audit Database Offline Events by Jason Brimhall
- T-SQL Tuesday #104: Just Ca… by Jason Brimhall
- Incorrect Syntax – What? by Jason Brimhall
- What’s that SSIS Password by Jason Brimhall
- SSSOLV ( 62)Recent Posts
- Las Vegas UG This week by Jason Brimhall
- October 2014 Las Vegas UG Meeting by Jason Brimhall
- September 2014 Las Vegas UG Meeting by Jason Brimhall
- SQL Server UG in Vegas Augu… by Jason Brimhall
- July 2014 Vegas UG Meeting by Jason Brimhall
- The Corner dep ( 58)Recent Posts
- Dedupe Data CTE by Jason Brimhall
- SQL Server Standard Reports… by Jason Brimhall
- DB Benchmarking by Jason Brimhall
- SQL Bitwise Operations by Jason Brimhall
- Database Maintenance by Jason Brimhall
- Corner ( 39)Recent Posts
- Cloud Nirvana by Jason Brimhall
- Scaring a Database Near you by Jason Brimhall
- MCM on Life Support by Jason Brimhall
- Rare Species, Extinction an… by Jason Brimhall
- T-SQL Tuesday #45 Follow th… by Jason Brimhall
- [...]
- Jason Brimhall about Defaults In msdb DatabaseYes it is a good idea. A fillfactor of 100 is great if the data in the table is always…
- Jason Brimhall about Endpoint Owners – Bac…When the ad account disappears, then you could see various abnormalities that could be intermittent.
- Jason Brimhall about Upgrading From SQL Server ProfilerThat is fine.
- Jason Brimhall about Interview Trick QuestionsI like to use that one as well.
- Bill Bergen about Easy Permissions AuditIn your outstanding script called "Script to auto generate a security report for your SQL Server instance" where can I…
- Dave Dustin about Interview Trick QuestionsOne I ask is "How would you go about identifying and removing duplicate rows from a table…
- Mike about Easy Permissions AuditNice quick, and easy check on db object security...thanks.
- Fermin about Upgrading From SQL Server ProfilerƊo you mind if I quote a feѡ ⲟf your articles ɑs ⅼong ɑs I provide credit аnd…
- John about Endpoint Owners – Bac…Thanks for sharing your knowledge. Do you happen to know what would happen if the owner of the endpoint…
- Henrik Staun Poulsen about Defaults In msdb DatabaseYou have set fill factor = 90. This makes your index 10% bigger than they need to be. Is this…