Populating My DBA Database for Power Bi with PowerShell – Databases

Following my post about using Power Bi with my DBA Database I have been asked if I would share the...

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...

Power BI Custom Visuals Contest Round-up

It's really exciting to see the first round of entries into the Power BI Best Visuals Contest, which has been...

Repairing a replication subscriber

It’s a question which has come up a couple of times. If a subscriber of a transactional replication publication becomes...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful...

SQL Server 2014: ONLINE operation on a single partition of partitioned object

Here I continue a series of articles devoted to new options in SQL Server 2014. Today let’s review another useful operation – ONLINE rebuilding some partitions of partitioned objects...

I'm alive!!!!

Hi all!
Sorry for long delay but i was a pretty busy preparing SQLSat
Now mission is accomplished and i'll return to...

No thrills about spills

Statistics, in simplest terms, refer to the distribution of data in a column or index. They are represented in a...

Predicates and Event Data

A predicate is a filtering mechanism used in SQL Server to target specific data when either querying or updating rows.
Related Posts:

Short Circuiting Your Session January 5, 2019

How To:...