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
147 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
485 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
237 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
284 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
212 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
377 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
375 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
176 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
131 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
255 reads
Blogs
Stop Using Pandas for Aggregations — Try DuckDB Instead
If you've ever loaded a 2 GB CSV into pandas just to run a...
Understanding Fabric Ontology
By James Serra
What problem is Fabric Ontology trying to solve? For years, most data conversations have...
QUOTENAME Basics: #SQLNewBlogger
By Steve Jones
Recently I ran across some code that used a lot of QUOTENAME() calls. A...
Forums
Stairway to Reliable Database Deployment Level 3 – Rehearsing Changesets Across Environments
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
QUOTENAME Quote Parameters
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Limit the Blast Radius
Comments posted to this topic are about the item Limit the Blast Radius
Question of the Day
QUOTENAME Quote Parameters
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers