Initializing a merge subscription without a snapshot requires more than matching table names. Prepare the schema, data and replication metadata, account for local changes and plan recovery for the actual replication topology.
Staying Current Without Chasing Every Update
Staying current on SQL Server takes a repeatable CU cadence, fast security response, and a patch policy your team can actually keep.
MERGE Statement Pitfalls
MERGE statement pitfalls include duplicate source keys, concurrency races, trigger surprises, and complex actions that deserve testing.
Migrating From MySQL to SQL Server: The Gotchas
Migrating from MySQL to SQL Server needs identity, collation, paging, and date rules, with SSMA assessing and converting the bulk of the work.
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
My students got Msg 262, SHOWPLAN permission denied, when they tried to view an execution plan. One GRANT SHOWPLAN statement fixes it.
SQL SERVER – Find Location of Data File Using T-SQL
A short T-SQL script that finds where your SQL Server Data File folder is on disk, using master.sys.master_files. Handy when you forget where the files live.
SQL SERVER – Fix Error 1949, Level 16: Cannot create index on view. The function yields nondeterministic results
Fix Error 1949: cannot create index on view because a function yields nondeterministic results. A training attendee hit it; removing that function solved it.