Documenting SQL Server Access – Who Can Do What? - Syndication – WaterOx Consulting

When is the last time you audited who has SQL Server access? No really? When did you last do this?...

SSRS 2016 – Part 2 New Features for Paginated Reports

This second post of 3 on SSRS 2016 looks at the new features for the SSRS portal and the paginated reports using the...

T-SQL Tuesday #75: Round Up

This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...

T-SQL Tuesday #75: Round Up

This month I challenged the blogging community to share their own creations in Power BI. We got a ton of great entries this month, thank you everyone who participated!...

Wait Stats Baseline Comparison – Idera Diagnostic Manager

Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server.  Sometimes...

Wait Stats Baseline Comparison – Idera Diagnostic Manager

Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server.  Sometimes something changes without our knowledge and is running differently...

You are not logged on as the database owner or system administrator.

I had one of my developers ask me why he keeps seeing the following warning when he tries to modify...

Introduction to Big Data

So you’ve been working as a DBA or a BI developer for several years now. You know your stuff very...

Schema-design for SQL Server: recommendations for Schema-design with security in mind

More SQL Saturday Precon News(Real-time Dashboards)!!!!

As you read in my earlier post, I am delivering a couple of precons in Tampa, FL and Richmond, VA. ...