Arrays and Lists in SQL Server
Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods.
Several methods on how to pass an array of values from a client to SQL Server, and performance data about the methods.
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.
In spite of what may be a controversial title to many of my regular blog readers, I don’t really want you to stop that practice in most of your T-SQL code, because the schema prefix is important and useful most of the time. At Stack Overflow, though, there is a very specific pattern we use where not specifying the schema is beneficial.
I recently changed jobs and my commute time doubled, I found myself with more time to think and I started asking questions.
In SQL and relational databases, NULL values are an important part of managing data and information stored in SQL tables. A NULL value is used as a placeholder for missing values or values that are unknown in a database column or cell.
A year ago, I started a monthly blogging event for the PostgreSQL community, inspired by T-SQL Tuesdays. I decided to call it PGSQL Phriday. (Time will tell if my insistence on trying to use a literation was a good idea or not.) Like the event for the SQL Server community, we ask someone to be […]
You will learn how a blockchain works and then use a SQL database to analyze data from a series of transactions.
Steve asks about your team at work today. What you like, what you need, even what you want to see in those with whom you work.
Credit card fraud detection is an important application of machine learning techniques, including Decision Trees. The goal is to identify and detect fraudulent transactions and separate them from valid transactions to prevent financial loss and protect user accounts.
Learn how you can interact with ChatGPT from PowerShell.
Can you trust your colleagues? We all want to, but there are always temptations, especially when life gets hard. Steve wonders today how we look at the issues of security inside of our organizations.
This June, LearnSQL is throwing down the gauntlet with a fresh SQL Practice challenge....
By Steve Jones
I delivered a talk today on database deployment best practices at the Denver Dev...
By Steve Jones
desanté – n. the brooding delirium of being sick, which makes time slow to...
Comments posted to this topic are about the item The SQL Assessment API
Comments posted to this topic are about the item Bridging Snowflake and Azure Data...
Comments posted to this topic are about the item DBCC CLONEDATABASE is Semi-Discontinued