SQL Server Management Studio Dark theme
Enable dark-theme for SSMS Purpose Guide to enable dark-theme in SQL Server Management Studio(SSMS). Reading time +/- 10 minutes References www.sqlserver.info...
2018-03-14
132 reads
Danny Riebeek
- Interests: SQL Monitoring
- Website: https://www.sqltreeo.com
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
450 reads
Blocking Locks and Deadlocks
Situation Your query is waiting for another query and the other query is doing nothing. Blocking Locks A blocking lock...
2018-02-28
219 reads
GDPR Compliant worden
Op 25 mei 2018 treedt de General Data Protection Regulation (GDPR) in werking. Deze nieuwe Europese privacywetgeving is van toepassing...
2017-12-29
277 reads
Stretch database to cloud.
Microsoft Azure stretch database Purpose Information regarding the new feature in SQL Server 2016. Reading time +/- 20 minutes References Microsoft...
2017-11-22
202 reads
Why do you want to use SQL Service Broker
Why use SQL Service Broker It enables you to execute SQL Statements faster and do the real work later. SQL Server...
2017-11-08
355 reads
Create a Login in a SQL Server Availability Group
Situation In SQL Server Availability Groups (AG), Logins must have the same SID (Security identifier) on all the nodes where...
2017-10-28
343 reads
Dashboard Server Status
Dashboard Server In the Server Dashboard the tile background can change between Green (Ok), Orange (Warning) and Red (Error). When...
2017-10-20
169 reads
Deactivate SQLTreeo license
Version SQLTreeo SSMS Add-in version 0.8.4 or higher. Purpose Deactivate a SQLTreeo license when your workstation is unavailable. SQLTreeo is...
2017-10-19
127 reads
SQLTreeo SSMS addin issues
Purpose Get help soon with SSMS Addin issues. In some cases a user might experience problems with their SSMS Add-in....
2017-09-28
246 reads
Blogs
Simple Talks Episode 9–Data masking and subsetting
By Steve Jones
The episode on data masking and subetting is out. You can see it here:...
T-SQL Tuesday #180: Avoid Perfect for Good Enough
By Brian Kelley
I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...
Book Review – Humanizing Data Strategy by Tiankai Feng
This book was making its rounds on social media, and the concept seems interesting...
Forums
SQL server help (converting rows to columns)
I am using the following sql to convert rows into columns for each pid,...
Ingesting Data From REST API endpoints: Data Engineering with Fabric
Comments posted to this topic are about the item Ingesting Data From REST API...
Separate Reads
Comments posted to this topic are about the item Separate Reads
Question of the Day
The Hash Join I
What are the two inputs called to a hash join operation in SQL Server? (choose 2)
See possible answers