SSIS Design Pattern - Staging Fixed Width Flat Files
Learn how to load fixed width flat files to staging tables in this article from Samuel Vanga.
How to find a specific text string in a SQL Server Stored Procedure, Function, View or Trigger
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or anything like a string starting with 'XYZ'?
Considering Other Views
When we build software, are we empathetic to how others (literally) view our software?
Monitor Query Performance Using Query Store in SQL Server
The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.
Row-Level Security Predicate Functions - Level 2 of the Stairway to Row Level Security
In this level, we dive deeper into predicates and the various ways to structure them in an RLS environment.
Software Testing Skills Must Shift with AI
Artificial intelligence (AI) is touching many parts of our lives and careers. Rama Anem discusses the impact of AI on software testing and how testers’ skills must adapt.
“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps
Brent Ozar explains that if you're going to do continuous integration or deployment, you've got a rocky road ahead of you.
Blogs
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...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
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