- Endpoint Owners – Bac… by Jason Brimhall
“What the heck is an endpoint?” Well, that is a good question. An endpoint in the simplest form is a connection or point of entry into SQL server.
- SSRS Subscription Schedules… by Jason Brimhall
With the ability to create content delivery schedules, or to subscribe to report content delivery, it becomes very important to also know when the various reports are scheduled to be delivered.
- SSRS Subscription Schedules by Jason Brimhall
With the ability to create content delivery schedules, or to subscribe to report content delivery, this imposes a requirement to also know when the various reports are scheduled to be delivered.
- SSRS Custom Shared Schedule by Jason Brimhall
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.
- T-SQL Tuesday #089: The Clo… by Jason Brimhall
Do you fear the coming turbulence of the Cloud uprising? I think the cloud is a good thing for the data professional, when done right.
- SQL Server Fixed Role Permissions by Jason Brimhall
It is very important to understand who has what level of access within the server and databases on that server. Sometimes we see users being granted server or database access through the fixed roles available in SQL Server. How exactly do you know what permissions those individuals have via role membership? This article will help to reveal the permissions granted to the various roles and maybe a gotcha or two.
- SQL Server Permissions R… by Jason Brimhall
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
- Parse Dynamics AX Context Info by Jason Brimhall
In this article I will only be discussing the AX product and an easy tweak to make troubleshooting that product much easier from the perspective of the database administrator. This tweak is to enable the context info from within the administration console.
- User Contains Invalid Chara… by Jason Brimhall
While creating database users, it is possible to encounter an invalid character error message. This article will help clarify the error message.
- What Agent Job is Running &… by Jason Brimhall
It is quite common to be required to investigate performance issues on the server. With this, it is occasionally necessary to be able to interpret an obfuscated job name. Learn how to do that in this article.
- Steffen about TSQL SudokuI found your post coincidentally, nice solution :-) And have a simple way to format the output…
- Chuck about SQL Server Fixed Role PermissionsTheTARDIS should be blue not red. :) https://goo.gl/2Fh7EU
- Jason Brimhall about Last Known Good CheckDBActually, this method relies explicitly on a buggy cursor. SP_MSFOREACHDB comes with inconsistencies and a few bugs. The heart of…
- Jason Brimhall about Easily Shred Event DataMichael, Thanks for the excellent feedback. I am glad somebody took this and adapted it to posh. I will have…
- Jason Brimhall about Table Hierarchy updatedThanks for the feedback.
- Jefferson Elias about Table Hierarchy updatedHi, I've tried the version provided for schema support, but it never worked in my environment.…
- michael graham about Easily Shred Event DataJason, great job on your post. It started me down the path of making a truly dynamic xel shredding and…
- Yoda about Last Known Good CheckDBThere is a simpler way without the need for cursors. DECLARE @a TABLE (…
- Jason Brimhall about Last Known Good CheckDBThanks and you are welcome!
- Jason Brimhall about Column Level PermissionsI will add a followup concerning sp_helprotect. Thanks for the feedback.