CSO recently published an article based on a report from Harmonic about generative AI data leaks, and the findings were eye-opening. According to the report, over 8% of employee prompts to public large language models (LLMs) contained sensitive data, ranging from security and compliance issues to privacy and legal vulnerabilities. This wasn’t just a handful […]
Learn how to download and restore AdventureWork 2019 Database.
Today Steve asks if you track the details of your table growth inside a database.
There are many functions and tools available to database professionals that can solve data math challenges, regardless of complexity.
Learn about how you can efficiently load data in Azure Synapse.
The job outlook for database professionals is good, but it's not that easy to get a great job. Steve has some advice for you today.
Learn how to simplify conditional logic in SQL Server 2022 using the IIF and CHOOSE functions.
SQL 2022 introduced the function generate_series which permits us to solve problems for which we previously had to use a table of numbers (also known as a "tally table"). generate_series is a great addition, because when using a table of numbers there was always a risk that you could run out of numbers. Or some joker could have deleted rows from the table. All these worries are gone with generate_series.
Geographic information systems (GIS) play a critical role in emergency response planning and risk assessment. One of the key challenges in this field is determining whether a specific location falls within an area of interest. This capability is especially valuable for property and casualty (P&C) insurers, who need to assess their insured property exposure when severe weather events such as tornadoes occur.
Steve has a few thoughts on natural keys, which often turn out not to be as unique as we expect.
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
By Zikato
Learn how to deploy schema changes in an always-online SQL Server environment without a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
Comments posted to this topic are about the item Shadow AI Data Leak Risk...
Hello SSC, I am not sure if I posted this in the right spot,...
What does this code return in SQL Server 2022+?
select bit_count(2.4)See possible answers