Self SQL Injection
Based on a real fact, this article demonstrates how a bad use of sp_executesql can lead to unpleasant surprises
2018-04-30
1,823 reads
Alessandro Mortola
Work time calculation
One way to calculate how many minutes a person has worked considering holidays and shifts, being given starting and ending date / time
2016-09-29 (first published: 2016-09-08)
582 reads
Indexing Foreign Keys
Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?
2016-09-16 (first published: 2015-06-29)
15,770 reads
Cardinality Estimator – What’s new in SQL Server 2014
SQL Server 2014 has introduced a rebuilt Cardinality Estimator (CE) with new algorithms. Which are the biggest differences between the new CE and the previous one? Which one works better? Read more to find out.
2015-04-09
6,836 reads
Blogs
Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes
When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...
Reading SQL Server File Headers with DBCC FILEHEADER
I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers