Bob is a set of Go packages and tools to work with SQL databases. Bob's philosophy centres around the following: This is just a fluent query builder that has no concept of your DB, and by extension ...

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects simply to a non-technical, business audience. Over… SQL is a programming ...

Part of the SQL Server 2022 blog series. Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database ...

Snowflake has thousands of enterprise customers who use the company's data and AI technologies. Though many issues with generative AI are solved, there is still lots of room for improvement. Two such ...

AP Invoice Payments.sql AP Invoices with Payment Details.sql AP Open Items Subledger.sql AP PO matched query.sql AP Payments Query.sql AP Pending Invoices for Validation.sql AP Query.sql ...

I first came across the Value.NativeQuery() M function about six months ago, but it didn’t do anything useful then so I didn’t blog about it. I checked it again recently though and now it does ...

SQL Server DBA specializing in performance tuning and disaster recovery. Bad code rarely begins the cascade of most SQL Server performance problems. Typically, it begins with something that is much ...

Part of the SQL Server 2022 blog series. Today, we announced the general availability of SQL Server 2022, the most Azure-enabled release of SQL Server yet, with continued innovation across performance ...