A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
SQL Server Permissions – Database Roles
Category: SSC
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.
Last Restore of a Database – Back to Basics
In this article I explore the basics around how to determine when a database was last restored.
Login from an Untrusted Domain – Back to Basics
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.
Finding Deprecated Uses in SQL Server
Do you know that your Server logs 300 million deprecation events a week? Do you know if code needs to be updated or how to find deprecated uses in SQL Server?
Seattle SQL Pro Workshop 2016
Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.