Find when your SQL Server database grew
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...
2017-05-25
330 reads
How to write a SELECT query
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
168 reads
Power BI – Problem, Design, Solution (Concatenated Tooltip)
Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series...
2017-05-24
800 reads
SSAS high availability
If you are looking at providing high availability (HA) for SSAS, here are 3 options:
Install SSAS on a Windows Server...
2017-05-24
1,049 reads
TIL: Microsoft Azure Part 2
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure. This is part two of...
2017-05-24
941 reads
Looking Back at Build–CosmosDB
Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.
One of the...
2017-06-09 (first published: 2017-05-24)
1,540 reads
Running multiple queries at the same time.
I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at...
2017-06-08 (first published: 2017-05-24)
10,096 reads
Measuring SQL Query Performance
When running workshops on the subject of SQL Query Performance the first question I always ask is how do we measure...
2017-06-08 (first published: 2017-05-24)
37,633 reads
Disabling the identity cache in SQL Server 2017
One of the changes that’s been brought into the database engine in SQL Server 2017 is the ability to disable...
2017-06-07 (first published: 2017-05-24)
4,711 reads
Power BI Custom Visuals Class (Module 52 – Bowtie Chart)
In this module you will learn how to use the Bowtie Chart Power BI Custom Visual. The Bowtie Chart visual...
2017-06-06 (first published: 2017-05-23)
1,776 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