SQL Server - No Longer Set

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.