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
755 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
5 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,721 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
723 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
174 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,541 reads
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers