- Single User Mode – Ba… by Jason Brimhall
Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios and ensure you are able to fully maintain and control your server. This article will show how to start in single-user mode via two methods.
- T-SQL Tuesday #102: Giving Back by Jason Brimhall
This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one’s personal life equal in some way to the amount of effort given towards the community.
- Change SQL Server Collation… by Jason Brimhall
Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire situation to ensure we are proceeding down the right path. It is better to be pensive about the course of action rather than to knee jerk into the course of action. Do you want to spend 5 minutes on the solution or 30-40 minutes doing the same thing? Changing collation can be an easy change, or it can be one met with a bit of pain doing a reinstall (more painful if more user databases are present). Keep that in mind and keep cool when you need to make a sudden change.
- T-SQL Tuesday #101: Essential Tools by Jason Brimhall
What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the same caliber as somebody else’s tools? And lastly, which tools do you not possess that you wish you possessed?
- Syspolicy Phantom Health Records by Jason Brimhall
SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is ignored by most people and few probably even know it exists. This job is the syspolicy_purge_history job.
- SQL Server Extended Availab… by Jason Brimhall
It may come as no surprise to many that Microsoft has hastened the SQL Server development cycle. Furthermore, it may be no surprise to many that Microsoft has also hastened the patch cycle for SQL Server.
- Extended Events File Initia… by Jason Brimhall
One of the recommended methods to trap payload data in an XE session is via the use of the event_file target. Sending data to a file has numerous benefits such as being able to take the trace and evaluate the trace file from a different machine (locally to that machine).
- Profiler for Extended Event… by Jason Brimhall
As of SSMS 17.4 we have been given the ability to control XEvents Profiler just a tiny bit more. For what it is worth, we as Database Professionals love to be able to control our database environment. So this teeny tiny bit of new control ability is potentially a huge win, right?
- SQL Server User Already Exi… by Jason Brimhall
One of my all-time favorite things in SQL Server is security. No matter what, it always seems that there is a new way to abuse permissions. When people abuse their access level or abuse the way permissions should be set in a SQL Server environment, we get the pleasure of both fixing it and then trying to educate them on why what they did was wrong and how to do it the right way.
- Database Corruption and IO Errors by Jason Brimhall
A quick way to have your day turned upside down and rip your gut out with nerves and anxiety is to come in one day to find that users are panicked, applications are not working and the HelpDesk team is curled up in the fetal position in the corner. Why? The sky is falling and everybody thinks the database has blown up. You appear to have a corrupt database and nasty IO errors.
- David about Database ToolsSpeaking of tools that foster database development in SSMS, I also highly recommend Devart Developer Bundle. Essential if you're working…
- Jason Brimhall about Single User Mode – Ba…yes. An unfortunate side effect. The linked post should be back soon.
- Jazz about Single User Mode – Ba…Nice post, however, Your link to "http://jasonbrimhall.info/2018/05/30/lost-that-sql-server-access/" is broken. It currently leads to a 404 page.
- Jason Brimhall about Lost that SQL Server Access?THat is a very good point to which I am uncertain how the system account is able to do that…
- Hubi about Lost that SQL Server Access?Hi, Great article, any idea why it works? From SQL 2012 'NT AUTHORITY\SYSTEM' is not a member…
- Jason Brimhall about Change SQL Server Collation…I didn't show the impact to my existing databases on the test instance because I felt it out of scope.…
- Jason Brimhall about Change SQL Server Collation…Agreed.
- Garland MacNeill about SQL Server Extended Availab…Nicely done. Came across the article at the end of April and was slack jawed. I couldn't figure out how…
- Blair Christensen about Change SQL Server Collation…One thing to note: this was a brand new install with no data in the database. Thus the…
- AG about Change SQL Server Collation…I don't see a mention of how or if, existing databases are affected. IIRC, changing server collation only affects…