More SQL Server Updates
Updates this week for SQL 2014, 2016, 2017 and SSMS have Steve thinking about the pace of patching.
The DefaultBufferMaxRows and DefaultBufferSize Properties in SSIS
This article shows how DefaultBufferMaxRows and DefaultBufferSize properties can be used to improve dataflow task performance.
How to Get a Random Row from a Large Table
Brent Ozar takes a look at four different ways to get a random row from a large SQL Server table.
Charles Bachman and Pointer Chains
Joe Celko reminisces about the origins of databases and one of the early pioneers, Charles Bachman. He explains how pointer chains were used to traverse data in the NDL standard and referential integrity that we use today.
Balancing Performance and Readability
Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.
Different Ways to Import JSON Files into SQL Server
Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.
If only the US would follow ...
Governments are requiring better security, and Steve wishes the US would follow.
Set-Based String Splitting table function
Describe and provide a set-based method that takes a multiple character split term and returns as a table
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
DML Trigger Types
Comments posted to this topic are about the item DML Trigger Types
PostgreSQL in action with Opensearch
Comments posted to this topic are about the item PostgreSQL in action with Opensearch
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers