SQL Server - No Longer Set (Page 3)

Pushing Field Comments to SQL Server

A VBA routine that takes field comments from a front-end linked table and pushes them to the corresponding back-end table in SQL Server.

SQL Server

Setting Field Descriptions on Linked SQL Server Tables

What good are field descriptions in SQL Server if you don't see them in your Access front-end? Here's some code to bring those comments forward into Access.

SQL Server

UPSERT a Column Description in SQL Server

Let's combine the stored procedures to Update and Insert SQL Server field comments into a single, all-encompassing solution.

SQL Server

Setting SQL Server Field Descriptions

There are two basic ways to set field descriptions in SQL Server: via SSMS and T-SQL. Let's explore both.

SQL Server

Brent Ozar: Date Table Fan

Brent Ozar, legendary SQL Server guru, makes his case for using a "Date Table." The video is all done in T-SQL, but the concepts apply equally to ACE backends.

SQL Server

Securing Access and SQL Server

Wherein Anders Ebro demonstrates how easy it is to circumvent application-level security in an Access program.

Risk Management

Securing Your Data

Relying on application-level security to protect your data would be like using guard rails to keep out your enemies.

SQL Server

Role-based SQL Server Security

There are many reasons to implement SQL Server roles even if you use Windows Authentication with Active Directory security groups.

SQL Server

Playing Telephone with SQL Server

You won't believe how Access and SQL Server actually talk to each other. You're going to need to see this for yourself.

SQL Server

ODBC Driver 17 Prevents SSMS Install

3 steps to fix SSMS installation error 0x80070643: (1) Uninstall ODBC Driver 17; (2) Restart the machine; (3) Rerun the installer

SQL Server

Yes/No Fields in SQL Server

The SQL Server equivalent of an Access Yes/No field is the "bit" data type. Or is it?

SQL Server

Working around the "Reboot Required" error when installing SQL Server

A previous installation required a reboot... To proceed, [uninstall ODBC Driver 17,] restart your computer and then run Setup again.

SQL Server

SQL Server Read-Only Mode

Before running a final data migration, you want to ensure no further changes will be made to the old data. One way to do that is to set the database to read-only.

SQL Server

Tuning Access Query Performance

The four best tools/techniques for tuning Access query performance: JetShowPlan, Process Monitor, TraceSQLMode, and SQL Profiler.

SQL Server

Cloning a SQL Server Database

The fastest, simplest, and cheapest way to clone a SQL Server database for debugging or testing. Even works with SQL Server Express!

SQL Server

All Hail Ola!

If you're managing SQL Server and you're not using Ola Hallengren's scripts, then you're doing it wrong.

SQL Server

Peeking Under the Hood

Don't let these gotchas trip you up when using SQL Server as a backend for Microsoft Access.