> ## Content Index > Fetch the complete content index at: https://nolongerset.com/llms.txt > Use this file to discover other available public pages before exploring further. # Archive Collection: SQL Server - URL: https://nolongerset.com/archive-collection-sql-server/ - Published: 2024-06-01T15:00:00.000Z - Updated: 2026-05-08T12:40:35.000Z - Description: I'm on vacation (shh...don't tell anyone)! I'll be back soon, but until then enjoy today's curated collection of articles from the archive. Today's topic: SQL Server. - Author: Mike Wolfe - Tags: Archive, #Import 2026-05-20 02:59 *From September 1, 2020, through April 27, 2024, I posted an article here every single day. Beginning on April 28, 2024, I started slacking by taking off Sundays. So, while my daily streak has been broken, I still have an automated weekly email that goes out every Sunday morning and includes details of the last six articles I've posted. (You should sign up for it if you haven't already; just hit the \[Subscribe\] button above.)* *In other words, I still need to post a new article every Monday through Saturday or my weekly email doesn't work right. I'm currently on vacation, though, which makes maintaining this streak a bit...tricky.* *I don't want to be writing and publishing articles on vacation. And I still want to provide you with something of value to read each day. So I settled on creating a series of curated article lists that I think you'll find beneficial.* *I'm hoping at least some of these articles are ones you haven't read before. And if you're so obsessed with me that you *have* read all my articles, I'm hoping that they'll keep you busy enough that you don't come looking for me and my family 😳.* *Enjoy!* --- ## SQL Server [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.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/construction-site-541197_1920.jpg)](https://nolongerset.com/troubleshooting-sql-server-connections/) [B-BEAR: Quick and Dirty SQL Server TestingBegin, Before, Execute, After, Rollback. This technique makes testing your SQL Server statements a snap.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/04/B-BEAR.png)](https://nolongerset.com/quick-and-dirty-sql-server-testing/) [All Hail Ola!If you’re managing SQL Server and you’re not using Ola Hallengren’s scripts, then you’re doing it wrong.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2020/11/sweden-4594420_1920.jpg)](https://nolongerset.com/all-hail-ola/) [Save $3,500 by Creating Scheduled Backups Using SQL Server ExpressYou don’t need to spend big bucks to get automated database backups with SQL Server. This simple step-by-step process is nearly foolproof.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/04/time-5389154_1920.jpg)](https://nolongerset.com/sql-server-express-backups/) [5 Tips for Making Changes on Live SQL Server DatabasesMaking database changes on production? These 5 tips will make one of the most dangerous programming activities a little bit safer.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2023/01/Live-Database-Changes--1-.jpeg)](https://nolongerset.com/live-database-changes/) [Editing Data Directly in SSMSQuery results in SQL Server Management Studio are read-only by default. Follow these steps to edit SQL Server table data directly inside SSMS.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2022/03/Editing-Data-in-SSMS.jpg)](https://nolongerset.com/editing-data-in-ssms/) [Using Windows Authentication to Connect to SQL Server from Outside the DomainYou don’t need to join your computer to a domain to be able to connect to SQL Server using Windows Authentication. You just need to know this simple trick.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/12/one-985535.jpg)](https://nolongerset.com/runas-netonly/) [Yes/No Fields in SQL ServerThe SQL Server equivalent of an Access Yes/No field is the “bit” data type. Or is it?![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2021/01/pexels-pixabay-210600.jpg)](https://nolongerset.com/yes-no-fields-in-sql-server/) ### Additional Reading [SQL Server - No Longer SetArticles directly related to Microsoft SQL Server, my preferred back-end data storage solution for Access applications.![](https://nolongerset.com/favicon.png)No Longer SetMike Wolfe![](https://storage.ghost.io/c/eb/d7/ebd732c1-5f03-4f07-b386-5d08557e15c9/content/images/2024/05/SQL-Server.png)](https://nolongerset.com/tag/sql-server/)