Exposing SQL Server Risks in 1 minute

Often we find ourselves meeting new SQL Server environments for the first time and for SQL Server Reporting and/or Business Intelligence servers this is no exception.   Whilst your role may be purely business intelligence developer, it is handy to know where the current exposure to risks are (such as recoverability) that could potentially derail the Business Intelligence project later.

Developing a quick DIY dashboard in Report Builder or Power Pivot is now an easy reality however you could find yourself investing some time in developing the various datasets that interrogate SQL Server’s back end tables.

This nice article by Brent Ozar shows there is plenty of available out of the box community resource available, to help you build a set of datasets that expose some of these common risks.

SQLServerPedia Auditing Configuration

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s