Introduction According to Microsoft, Database Mail is an enterprise solution for sending e-mail messages from the SQL Server Database Engine. Using Database Mail, your database applications can send e-mail messages to users. The messages can contain query results and can also include files from any resource on your network. This article is going to discuss […]
2021-04-27
720 reads
Introduction According to Microsoft, DTSX is an XML-based file format that stores the instructions for the processing of a data flow from its points of origin to its points of destination, including transformations and optional processing steps between the origin and destination points. In a nutshell, when you are creating your SSIS package, the SQL […]
2021-03-25
2,297 reads
Introduction "Sometimes" just having all the database backups in one place is not enough. In fact, most of the time, putting all the eggs in one basket is a bad idea. You want to have some piece of mind that during the time of crisis, all your database backups are restorable. This is probably why […]
2021-02-11
2,077 reads
SQL Server Agent is heavily used by many organizations, but it hasn't changed much in years. This article speculates on some new features that might improve the scheduler.
2020-12-21
3,136 reads
Introduction Performance, performance, performance. While performance in SQL Server can be achieved with code improvement and proper infrastructure maintenance, both tasks require an effort. Code reviews and deep index analysis would take time, but sometimes the obvious is right in front of you. Let's talk about HEAP tables, aka tables with no clustered indexes that […]
2020-12-08
7,015 reads
Getting informative error messages when something goes wrong with an SSIS package is critical, especially if you are not in front of your computer.
2020-11-25
5,093 reads
This article explains how to get around one of the issues when the SSRS databases are part of an Availability Group.
2020-11-17
2,296 reads
Introduction The Master database. Just in case that you are not familiar with this database, the Master database is used in SQL Server to store all the system information, instance-level settings, logon information, database file locations, etc. SQL Server can't run without access to a fully functional master database. It's highly recommended not to use […]
2020-11-10
3,276 reads
2020-10-22
4,270 reads
Introduction A popular joke about DBAs and database backups goes like this. There are two types of DBAs: DBAs that do backups DBAs that will do backups The joke is only stating the obvious – lack of database backups might be the end of a DBA career and/or the supported business. Unfortunately, that joke fails […]
2020-01-07
7,924 reads
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
By John
You might be asking why on earth would you want to get a database...
Hi Everyone. i am planning to shift my website to AWS I want...
Hi Everyone, I'm trying to do something that seems pretty simple, but SQL Server...
Hello everyone, Again with this question. 🙂 I've got a log-shipped database, and I...
Ask SSC