SQL Server Updating Linked SQL Server Views in Access When Changing the Underlying Table Data Types If you change the data type of a table field in SQL Server, follow these steps to be sure all related views are updated in Microsoft Access.
SQL Server 5 Tips for Making Changes on Live SQL Server Databases Making database changes on production? These 5 tips will make one of the most dangerous programming activities a little bit safer.
SQL Server Epoch Differences Between VBA and SQL Server Do you have unexplained dates of December 30, 1899 in your SQL Server database? VBA's epoch (i.e., zero date) could be the culprit.
Under 100 What is rowversion in SQL Server? The concept of SQL Server's rowversion data type explained in under 100 words. #Under100
Debugging Fixing a Persistent "Write Conflict" Error If you are getting consistent "Write Conflict" warnings when using bound forms to update SQL Server tables with datetime fields, there may be an easy fix.
Migration Scripted SQL Server Migrations Use this batch file to automatically backup a database on one instance of SQL Server and restore it on a different instance of SQL Server.
Migration SQL Server Migration Steps My SQL Server migration philosophy consists of two priorities: (1) Avoid disasters and (2) Minimize production downtime.
SQL Server HOW TO: Automate Batch Deletion of SQL Server Records Using a single DELETE statement to remove 20 million+ records from SQL Server is a bad idea. Here's a better approach.
SQL Server Deleting a Large Number of Records in SQL Server Let's explore four options--two bad and two good--for deleting one million or more records from a single SQL Server table.
SQL Server How to Install SQL Server on a Read-Only Domain Controller (RODC) The official Microsoft documentation says it's not possible, but with a little ingenuity and poor judgment, we can get SQL Server to run on an RODC.
Tools 3 Free Options for Managing Linked Tables in Access The original linked table manager was a terrible tool. Let's look at three better options for today's Microsoft Access developers.
SQL Server Advanced Server-Side SQL Server Query Troubleshooting The XEvent Profiler in SSMS is a powerful troubleshooting tool, but what happens when the standard sessions are not enough? We need to customize...
SQL Server IIF ... IS NULL vs. Nz(): Testing a Hypothesis Which is better in a WHERE clause: IIf...Is Null or Nz()? Or is there a third option that's better than both of those?
Migration Convert Common Access Field Defaults to SQL Server Here's the Select Case statement I use to convert common Access field default calculations--Now(), Date(), etc.--to their SQL Server equivalents.
SQL T-SQL ISNULL() vs. VBA IsNull() vs. Jet IS NULL vs. Access VBA Nz() How do I check thee for NULL? Let me count the ways.
SQL Server Save $3,500 by Creating Scheduled Backups Using SQL Server Express You don't need to spend big bucks to get automated database backups with SQL Server. This simple step-by-step process is nearly foolproof.
AutoHotKey Toggle ODBC TraceSQLMode with an AutoHotKey Script Traditional methods of enabling and disabling ODBC TraceSQLMode are a pain in the neck. This AutoHotKey script makes it as easy as pushing a button.
SQL Server Making Sense of SQLOUT.TXT You've enabled ODBC Trace SQL Mode and created a sqlout.txt file. But do you know what to do with it now? Let's explore.
SQL Server Editing Data Directly in SSMS Query results in SQL Server Management Studio are read-only by default. Follow these steps to edit SQL Server table data directly inside SSMS.
Tools 3 Ways to Find sqlout.txt Finding ODBC TraceSQLMode's sqlout.txt file can be deceptively difficult. Here are three approaches to make it easy. At least one is guaranteed to work.
Debugging Troubleshooting SQL Server Connection Errors "SQL Server does not exist or access denied." One error. Dozens of possible causes. Read on for a bunch of practical troubleshooting tips.
SQL Server SQL Server Connectors in 2022 To get access to the latest features--especially security features--be sure you're using the latest ADO provider and ODBC driver for SQL Server.
SQL Server How Access Reads Data From SQL Server How does Microsoft Access pull data from SQL Server? You'll be amazed when we pull back the curtain to expose how Access interacts with SQL Server.
SQL Server Quick Way to Troubleshoot SQL Server ADO Connections This simple trick provides you with plenty of clues when debugging a failed SQL Server connection on a user's computer.
SQL Server 3 Gotchas of the SQL BETWEEN Statement The SQL BETWEEN statement produces very readable condition expressions. But developers of all skill levels can still get into trouble with it.