SQL Server DBA Utility Dashboard
Create a quick application that stores your favorite queries that you can use to quickly connect to any server and return the results.
2021-03-08
dba
DBA in training: SQL Server under the hood
In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query anti-patterns to avoid.
2021-02-23
Mastering TempDB: The basics
Mastering TempDB is a critical skills for SQL Server DBAs. In this article, Monica Rathbun explains the basics of TempDB including configuration.
2021-02-19
SQL Server triggers: The good and the scary
SQL Server triggers are another tool in your DBA or Dev toolbox. Edward Pollack explains what can go wrong with triggers and how to correct those issues.
2021-02-18
SQL Update Statement with Join in SQL Server vs Oracle vs PostgreSQL
In this article we look at the different SQL syntax you need to use when updating data when joining tables for SQL Server, Oracle and PostgreSQL.
2021-01-29
DBA in training: Know your server’s limits
Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to measure the physical resources drive space, latency, memory, and CPU.
2021-01-06
DBA in training: Backups, SLAs, and restore strategies
There are a handful of options when backing up SQL Server databases. A DBA must understand the differences and come up with a plan that protects the organisation’s data. In this article, Pamela Mooney explains service level agreements, recovery models, and some strategies to ensure that the data can be restored quickly.
2020-12-09
SQL Server Backup Types
One of the most important responsibilities for a DBA is to ensure that a database can be restored in case of corruption, a dropped table, or another disaster. In this article, Greg Larsen explains the different types of backups available with SQL Server.
2020-12-01
DBA in training: Security
Securing data is not always easy to do, but it should be the top responsibility for database administrators. From protecting the physical servers to preventing copies of backups files from getting into the wrong hands, there is a lot to consider. In this article, Pamela Mooney covers what DBAs need to think about when securing their organisation’s data.
2020-11-19
Blogs
The Redgate Seminar – Brisbane
By Steve Jones
On Thursday, May 2, we have the Redgate Seminar in Brisbane. I’ll be at...
Microsoft Fabric Training and Tutorials
By Brian Kelley
Microsoft Fabric is the new data offering in Microsoft Azure and there is a...
DBA and Developer: Allies or Adversaries?
By Rohit Garg
In the expansive landscape of software development, the relationship between Database Administrators (DBAs) and...
Forums
Report definition has an invalid target namespace
I'm hoping someone here has encountered this before and was able to fix it....
Query about GAC (Global Assembly Cache)
Hi everyone, So I have a SSIS package that performs some importing/exporting from MySQL...
How to check for data loss after rollback
Hello SSC, I am not a DBA,. I have some DBA knowledge, but my...
Question of the Day
Reporting Services Editions
In which editions of SQL Server 2022 can you run Reporting Services?
See possible answers