Query Store and Recompile

One of the many advantages of SQL Cruise is the ability to have enough time during a presentation to be...

SQL – List Server and DB Permsission

Database Level Permission
DECLARE@DBuser_sql VARCHAR(4000)DECLARE@DBuser_table TABLE(
DBName VARCHAR(200),
UserName VARCHAR(250),
LoginType VARCHAR(500),
AssociatedDatabaseRole VARCHAR(200))SET@DBuser_sql='
SELECT "[?]" AS DBName,a.name AS Name,
a.type_desc AS LoginType,
USER_NAME(b.role_principal_id) AS AssociatedDatabaseRole
FROM [?].sys.database_principals a
LEFT OUTER...

SQL Filegroup/File Proportional Fill Algorithm

[read this post on Mr. Fox SQL blog] I had a question at work recently where there was some confusion around how SQL Server allocates data across data files within a filegroup...

TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...

TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of the participants, Rob Farley (Blog | Twitter) made me...

TSQL Tuesday #75 Round Up Redux

Okay so I already posted a round up post for this month. You can see it here. Tonight one of...

Webinar – SQL Server BI Best Practices

I’ll be giving a webinar for MSSQLTips.com on Thursday March 10, 2016.

The title is SQL Server BI Best Practices and its...

Why Is The Server Slow?

This is blog post #2 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel.
If you haven’t been working in SQL Server for very...

Columnstore Indexes – part 77 (“SSIS 2016 & Columnstore”)

Continuation from the previous 76 parts, the whole series can be found at http://www.nikoport.com/columnstore/
I have written previously about SQL Server...

Monitoring wait stats

This post, like last week’s, is based off the presentation I did to the DBA Fundamentals virtual chapter.
The request was...