I am traveling to New York and New Jersey for a Database Architecture and Implementation discussion, so replies to comments and emails will wait two days.
Fast Bulk Inserts From Python
Bulk inserts from Python work best with parameterized executemany, measured batch sizes, a tested fast_executemany path, and clear restart rules.
SQL SERVER – Two Different Ways to Comment Code – Explanation and Example
SQL Server has two different ways to comment code. Let us learn all of them here in this blog post. Various the options in the blog posts.
Orphaned Users After a Restore, and How to Fix Them
Find orphaned users after a SQL Server restore, compare user and login SIDs, and repair the intended mapping with ALTER USER.
SQL SERVER – FIX : Error 945 Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details
Error 945 means the database cannot be opened due to inaccessible files or low disk space. My four checks: disk space, autogrow, permissions and read only files.
MSSQL or MySQL? Clearing Up the Name Mix-Up
MSSQL or MySQL? The names are one letter apart and the products are not. Here’s who makes each, and the syntax differences that trip people up.
Why SQL Server Has Cumulative Updates, Not Service Packs
Understand why SQL Server uses Cumulative Updates instead of service packs, what each CU contains, and how to plan a reliable patch cycle.
Index Maintenance on Modern Storage
Index maintenance on modern storage needs query evidence, page density, and statistics checks before you choose a rebuild or lighter action.
SQLAuthority News – Birthday of SQL Authority Author
Today is the birthday of the SQL Authority Author, and my thought of the day is a simple one that I truly believe: family is everything.
SET_BIT: Return a Changed Value Without Updating Data
SET_BIT returns a value with one bit set or cleared. Compare the default one with explicit zero, and keep scalar calculation separate from updates.