Azure Blob Storage Part 8: Blob Leases
In this article, Robin Shahan explains what Blob Leases are and how to use them, including code samples for calling the different methods available for managing Blob Leases.
Mail Fails with SQLCMD Error
I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.
Microsoft and R
R is an interesting language and one that might become more important to data professionals in the future. Microsoft is also making an investment here.
How to get Database Design Horribly Wrong
Database Design is one of those tasks where you have to carefully get all the major aspects right. If you mess-up just one of these, it can all go horribly wrong. So what are these aspects that can ruin database design, and how can you get them right? Robert Sheldon explains.
SQL Saturday #364 - Boston, MA
SQL Saturday is coming to Boston on April 18th 2015. Join us for a free day of SQL Server training and networking, and listen to great speakers like Grant Fritchey, Brent Ozar, and Andy Leonard. Register while space is available.
Using the ROLLUP, CUBE, and GROUPING SETS Operators
Greg Larsen discusses the ROLLUP, CUBE and GROUPING SETS operators. These operators are used with the GROUP BY clause and allow you to create subtotals, grand totals and superset of subtotals. Read on to find out more about these additional GROUP BY operators.
What is Behaviour Driven (Database) Development?
Behaviour Driven Development (BDD) is not always clearly understood, and the term is particularly unfamiliar in database circles. Seb Rose introduces us to the fundamentals of BDD, and make some suggestions for how it might be relevant to database development.
Computational Biologist
A job Steve Jones has never heard of is using data to improve medical treatments.
Converting to data-driven code
How converting extensive, repetitive code to a data-driven approach resolved a maintenance headache and helped identify bugs
Blogs
Designing a Storage Load Test for SQL Server
I’ve been doing storage load tests for SQL Server for a long time, both...
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers