Design Concepts for Better Power BI Reports Part 3: Gestalt Principles
The Gestalt principles of visual perception describe how humans tend to organize visual elements into groups or unified wholes to...
2017-12-18
717 reads
Creating a SQL Server Test Lab On Your Workstation – Part One, Installing The Domain Controller
One of the most useful tools to the DBA when we need to test new features, recreate a fault that...
2017-12-18
644 reads
Query Store Wait Statistics with sys.query_store_wait_stats
The second best thing to questions that people ask is when I sit down to write a book. It’s so...
2017-12-18
741 reads
Power BI – Problem, Design, Solution (Folder Source Option for JSON files)
Hello Everyone! In this episode of the “Problem, Design, Solution” series we will be talking about the “Folder” option inside...
2017-12-18
619 reads
Connect is dead! Long live feedback.azure.com!
After years of having to deal with Connect – the feedback platform of Microsoft – it is announced a successor has been...
2017-12-18
1,148 reads
SQL Server DBCC CHECKDB – Going Parallel
DBCC CHECKDB has the ability to perform parallel checking of objects. However, it absolutely depends on the edition of SQL...
2017-12-18
321 reads
When do usernames and passwords belong in connection strings
tl;dr: When using a windows or active directory authenticated id you do not put the username or password into your...
2017-12-18
715 reads
My SQL Server Management Studio Setup
We’re all creatures of habit, and work more efficiently when we know exactly where to find the tools we need....
2017-12-18
341 reads
The Fine Art Of Translation
I remember being thoroughly baffled in grade school by word problems. How in the world was I supposed to translate...
2017-12-18
360 reads
T-SQL Tuesday #97 Roundup: Learning goals for 2018
T-SQL Tuesday is a monthly blog party started by respected SQL Guru Adam Machanic. I was honored with hosting this...
2017-12-18
826 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