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.
Tag: Database Administration
SSRS Subscription Schedules
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
Reporting Services is a pretty feature rich tool for delivering reports to various consumers. Unfortunately, the scheduling capability within SSRS is fairly weak.
SQL Server Fixed Role Permissions
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 – Database Roles
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
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 Characters – Back to Basics
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 – Back to Basics
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.
Database Backups – Back to Basics
In this article, we will explore database backups. More specifically, how do you truly know if you have a successful backup? Here’s a hint: it has to deal with restores.
Database Backup History – Back to Basics
In this article I explore the basic of querying backup history data as a foundation to reporting on essentials such as storage and job management.