Common Mistakes in SQL Server – Part 4
Last week we have discussed how Null Values can cause a trouble in Common Mistakes in SQL Server – Part 3. This week I would like to draw your...
2023-10-09
15 reads
Blog Posts
October Is National Disability Employment Awareness Month
As many of you know, I was diagnosed with ALS or Lou Gehrig’s disease a couple of years ago. Since then, I have 9 made it a personal mission...
2023-10-09
21 reads
Penetration Testing your SQL Server, Part 1 – The Recon Mission
Since witnessing a rather nasty cyber attack around a year ago, I’ve been thinking quite a bit about security. Do we really know how secure our SQL Servers are?...
2023-10-09 (first published: 2023-09-26)
867 reads
Quick Tip: Taking advantage of Read-Only SQL Server replicas in your C# application
If you happen to be using C# there is a very easy way to set your application up to take advantage of Read-Only replicas.
Using this connection string: (Some portions...
2023-10-09 (first published: 2023-09-18)
1,504 reads
A New Word: Ringlorn
ringlorn – adj. the wish that the modern world felt as epic as one depicted in old stories and folktales – a place of tragedy and transcendence, of oaths...
2023-10-06
127 reads
Extended Events and I (T-SQL Tuesday #166)
Foreword
This month’s invitation is from Grant Fritchey (t|b), aka the Scary DBA, about Extended Events (XEs).
If you look at the Tags section of my blog, you can see that...
2023-10-06 (first published: 2023-09-13)
375 reads
Quick Filtering in SSMS–#SQLNewBlogger
I saw someone limit the databases they see in SSMS, which isn’t something I often do, but I thought this was great. A Long List This is the list...
2023-10-06 (first published: 2023-09-27)
307 reads
The Database DevOps Roadshow Continues (with fun photos)
At SQL Saturday Denver 2023, I had a few people ask me about the Redgate Database DevOps roadshow and how it was going. A few people asked about the...
2023-10-06
60 reads
6 Best SQL Training Courses for Beginners (2024 Updated)
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the intricacies of database management. Central to this booming sector is SQL, a programming language exclusively...
2023-10-04
26 reads
About 5 Minutes with Microsoft Fabric
Introducing the Fabric 5 from Data on Wheels Microsoft Fabric went to public preview this past summer. There has been content created around using the various cool features that...
2023-10-04 (first published: 2023-09-14)
336 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
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