SQLServerCentral Article

Dealing with Addresses

David writes about the system he put together to handle addresses and the pros and cons of various techiques. Familiar with Soundex? He uses that too! Even though some of the info is specific to Great Britain, it's good reading. Addresses are one of the hardest pieces of information to handle!

SQLServerCentral Article

SQL Server Security: Security Admins

As we mentioned before, Brian will be writing a column covering all facets of security. Turns out that there is so much to cover, he has agreed to write two columns per month! This article talks about the principle least privilege, why it doesn't always work, and some good info about removing the Builtin\Admin account.

SQLServerCentral Article

Managing Jobs - Part 4

Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.

Technical Article

SQL Server DTS Best Practices

This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.

Blogs

When is the perfect moment to build a data strategy in a company?

By

The post When is the perfect moment to build a data strategy in a...

How to Run Databases on Kubernetes: An 8-Step Guide

By

In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...

Episode 11 of Simple Talks: Oracle

By

The 11th episode is now live, recorded a few weeks ago at the PASS...

Read the latest Blogs

Forums

Rebuild Index Job on a Large DB

By cooldude001

We have a db close to 3 tb and rebuilding/ reorganizing indexes weekly is...

Authentication Error 0x8009030c

By Tallboy

Hi, I'm using a small database on SQL Server 2019 on Windows 10 Pro....

how to stop command prompt window from appearing when running PowerShell script?

By water490

Hi everyone I have a PowerShell script that is run by Execute Process Task...

Visit the forum

Question of the Day

Renaming a Database

If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)  

See possible answers