Replacing Cursors with Set-Based SQL Queries – Part 2
Part 2 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a recent post I discussed...
2011-07-06
12,510 reads
School Data Move Done!
A brief mention that we are done with the school year flip process for transitioning to the new school year.
I...
2011-07-01
811 reads
Replacing Cursors with Set-Based SQL Queries – Part 1
Part 1 of a discussion about replacing cursors with SQL statements for significant speed improvements.
In a previous post I discussed...
2011-06-27
7,992 reads
Google as the Ultimate SQL Repository
A discussion of how Google can serve as an invaluable resource when facing a SQL-based challenge.
Today I briefly want to...
2011-06-23
745 reads
Table Backups and the TableArchive Database
A discussion of how a separate database is used for storing table backups.
In a recent article, one of the things...
2011-06-20
906 reads
Being Cautious With SQL Based Processes
Why being careful is such an important mindset when working with SQL and databases.
At the Boston Public Schools, certain processes...
2011-06-17
1,163 reads
SQL Books Arrived Today
A small post regarding a couple SQL books I bought from Amazon.
A couple new books arrived in the mail from...
2011-06-15
864 reads
Database Documentation with a Data Dictionary Part 2
A continuation of the data dictionary discussion with information about how the documentation is done.
Today I’m going to continue discussing...
2011-06-13
1,492 reads
Some Good SQL-Related YouTube Videos
A brief discussion and links to a series of YouTube videos from Stéphane Faroult.
I’ll continue the discussion of the table...
2011-06-11
1,217 reads
Database Table Documentation with a Data Dictionary
Why table and column documentation is useful and some SQL for setting up the data dictionary tables.
At Boston Public Schools,...
2011-06-10
1,937 reads
Blogs
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
Forums
does anyone used https://github.com/ktaranov/sqlserver-kit
Could you please let me know if anyone is used https://github.com/ktaranov/sqlserver-kit github for deployment...
How Can Database Performance Improve the Overall Website Experience?
I’ve been looking into ways to improve the connection between a website and its...
When And How to Automate?
Comments posted to this topic are about the item When And How to Automate?
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers