Pride and Prejudice... and Triggers
This post is part of #tsql2sday event 🙂
I know, in the world of the database administrators and developers, the triggers are the ugly duck of the database development.They are...
2018-09-11
2 reads
SQL Guatemala
Pride and Prejudice... and Triggers
This post is part of #tsql2sday event :)I know, in the world of the database administrators and developers, the triggers...
2018-09-11
546 reads
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code, for my own projects or reviewing someones else code....
2018-09-10
13 reads
Different methods to generate query execution plans
One of the things I enjoy about my job is when I have to develop or review some T-SQL code,...
2018-09-10
753 reads
Format Query as JSON
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it also used to stored NoSQL unstructured data, and because...
2018-08-22
4 reads
Format Query as JSON
JSON (JavaScript Object Notation) is a file format used to transmit data from various applications, very similar to XML, it...
2018-09-06 (first published: 2018-08-22)
3,720 reads
Performance Basics: Indexed views
Views help our query writing by simplifying writing the same sentences and/or aggregations over and over again, but it has...
2018-08-17
328 reads
Announcing new Guatemala SQL Server user group
I am very happy to announce that after a long time struggling and filling all the requirements, we were able...
2018-08-16
722 reads
Determine SQL Server Network Protocol Information using T-SQL and DMVs
I have recently started as an author for MSSQLTips.com website, this is an excellent site where you can start writing...
2018-08-09
172 reads
Extended events (XE): Create a simple XE
When someone says still uses SQL Profiler.
Image is taken from hereAn ancient, dark place, a source of many legends and...
2018-07-23
1,540 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers