Trunk Based Database Development
Trunk based development is what many of us do with shared database servers.
2019-03-29
608 reads
Editorial
Giving Computers Ethics
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
229 reads
No More SQL Server Installs
Today, Steve wonders when we'll stop installing SQL Server on a host machine.
2019-03-26
1,256 reads
What's Worse than Announcing a Data Breach?
Steve has a few thoughts on what is worse than telling your boss about a data breach.
2019-03-25
118 reads
Query Tuning Assistant: A Tool for Upgrades
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
2019-03-25
1,103 reads
2019-03-22
83 reads
Dealing with Failure
A minor disaster in Colorado reminds Steve about the need to prepare, and think about the failure points in our preparations.
2019-03-18
69 reads
The V1 Team’s Doomed Redesign
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
92 reads
2019-03-15
113 reads
2020-02-19 (first published: 2019-03-14)
448 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
Impact of adding the opening of the Master Key in a SQL job for SSIS packages
Bonjour à tous, J'ai un problème d'exécution de mes packages SSIS. A chaque opération...
Being an extroverted introvert at a conference
Comments posted to this topic are about the item Being an extroverted introvert at...
Need to group the same valued ID fields to run an aggregate average over them
I have data that contains poll results, with the poll_id consistuting a single row...
Question of the Day
How are statistics stored?
How are the statistics for query optimization stored in SQL Server?
See possible answers