Adding Row Numbers to a Query: #SQLNewBlogger
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
2,354 reads
I realized that I hadn’t done much blogging on Window functions in T-SQL, and I’ve done a few presentations, so I decided to round out my blog a bit....
2024-10-09
2,354 reads
How simple should software development be? Steve notes it can be simple, but not too simple.
2024-10-09
178 reads
2024-10-09
315 reads
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...
2024-10-08
37 reads
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend, Tim Mitchell is hosting and he’s got a neat invite. He’s asking us how to...
2024-10-08
11 reads
2024-10-07
300 reads
I got a message a few months back that Microsoft was deprecating the MySQL server version that I was using in Azure. The cost was going up, and while...
2024-10-07
14 reads
How much load do real time updates place on a data warehouse? Steve has a few thoughts on the analysis of the Amazon Redshift dataset, Redset.
2024-10-07
229 reads
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-06 (first published: 2024-10-05)
18 reads
Thanks to everyone that came to my talks. Slides are below. Best Practices for Seamless Deployments Balance in Life with a Career If you have questions, please reach out.
2024-10-05
4 reads
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item 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