1.
How I Get By Without sysadmin | facility9
What most people don’t know is that I don’t have sysadmin access on our servers, nor do I have any of the other permissions that would let me collect trace ...
2.
How I Get By Without sysadmin | facility9
The people who follow me on twitter have probably noticed that when I'm not tweeting absolute nonsense, I'm tweeting about performance tuning SQL.
3.
Retrieve the top X random rows from a query | facility9
Let's suppose for a minute that you want to retrieve the top x number of rows from any given query. Keep in mind that x is a value that your users can ...
4.
Avoiding Cross Database Ownership Chaining | facility9
Cross database ownership chaining is a security risk. But, what's a poor DBA to do when they need to provide data access between two databases?
5.
Avoiding Cross Database Ownership Chaining | Jeremiah Peschka, SQL ...
Cross database ownership chaining is a security risk. But, what's a poor DBA to do when they need to provide data access between two databases?
6.
SQL Server Security - Database Roles | facility9
Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level.
7.
SQL Server Security - Database Roles | facility9
Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level.
8.
SQL Server Security - Database Roles | facility9
Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level.
9.
Whoops! The SQL DBA Quiz | facility9
Brent Ozar has tagged me to share two mistakes I've made as a DBA throughout my career. (Apparently this was started by Chris Shaw.
10.
SQL Server Security - Database Roles | facility9
Database roles (also referred to as database-level roles) are security roles that exist on a database level, as opposed to the server level.