As I start this editorial, I am sitting at a PostgreSQL conference in New York City during the nighttime reception. The sound of 100 voices is not quite deafening, but it is certainly loud and understanding anyone in this group would be hard. It is also hard because I only know about four people at […]
SQL Server MVP Jeff Moden shows us a quick and dirty bit of SQL Spackle to display the content of VARCHAR(MAX) and NVARCHAR(MAX).
Steve reminisces about the older technology of putting words on paper, often from the web.
All developers hit the problem of how and where to store and set their configuration, profile, or initial data. A long time ago, it was generally decided that simple text files containing key/values were best, stored with the application. After all, you are relying on being able to entice busy people to get the permanent settings right for their requirements, folks who are generally not interested in your elegant computer science constructs. Not only that, but the settings must be parsed very quickly and efficiently, otherwise a process that uses the tool will slow to a crawl.
SQL Prompt has long been a customer favorite thanks to its ability to boost productivity. Discover how fellow database professionals are leveraging SQL Prompt to accelerate their coding speed and improve code quality.
How many of us clean up our databases and is it worth it? Steve has a few thoughts.
Learn how updates and concurrency can work in Fabric with Delta Parquet data.
Back by popular demand, casino night from SQL Server Central will return to PASS Summit this year. Casino night will take place on November 5 after the welcome reception. Tickets will be allocated at random via a lottery.
PySpark has some unconventional syntaxes which provide power to the development process, making it easier.
This article looks at the old style of calculating a running total and how to convert that to code that uses a window function.
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item Being an extroverted introvert at...
I have data that contains poll results, with the poll_id consistuting a single row...
Hi everyone. I am re-writing a portion of my SSIS logic. My SSIS package...
How are the statistics for query optimization stored in SQL Server?
See possible answers