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. ...

Reblog: SSIS Performance Testing

I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...

SQLKonferenz in Darmstadt: Vorstellung der Security Features von SQL Server 2016 mit dem Leiter des Security-Teams aus Redmond

Azure SQL Database Error

I was on SQL Cruise where I was scheduled to present a session on Azure SQL Database. I recorded all...