Dear McAfee, Why are you destroying my buffer pool?
For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...
2017-05-02
1,308 reads
SQL Server 2016 for Performance Tuning Lovers
Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of...
2017-05-02
2,121 reads
T-SQL Tuesday #90 – Shipping Database Changes
I was once asked to add a new feature to an application. It was installed on multiple SQL Server instances...
2017-05-02
412 reads
How Can I Get Accepted to Speak at the PASS Summit?
There has been some discussion and concern over the changes to the speaker selection process for the PASS Summit. I’ve...
2017-05-12 (first published: 2017-05-01)
1,056 reads
Power BI Custom Visuals Class (Module 49 – SandDance)
In this module you will learn how to use the SandDance Power BI Custom Visual. The SandDance visual is an...
2017-05-16 (first published: 2017-05-01)
2,363 reads
Simple Security Report
Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...
2017-05-12 (first published: 2017-05-01)
2,306 reads
SQL Saturdays – down memory lane
A casual twitter-conversation with Karla Landrum and some other peeps led me down memory lane on older events. Our SQL...
2017-05-01
434 reads
Monday Coffee 2017-05-01
Morning all, I know it’s a bank holiday in the UK & Ireland today but some of us still have to...
2017-05-01
280 reads
Azure Data Factory and the Case of the Missing JRE That Wasn’t
On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...
2017-05-11 (first published: 2017-05-01)
1,303 reads
DAX calculations with hierarchies: Set the order straight.
[2017-Apr-30] If you have ever tried to create calculated measures in SSAS Tabular/ Power BI models where different levels of...
2017-05-10 (first published: 2017-04-30)
4,791 reads
Blogs
T-SQL Tuesday #201 Round-Up: Temp Tables, Friend or Foe?
By ReviewMyDB
The T-SQL Tuesday #201 round-up: nine bloggers on whether temp tables are a friend...
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers