Find Unused or Backup Tables
If you rename old or backup tables, learn how to find easily find and drop them.
2024-03-18
5,044 reads
Administration
2024-03-15
363 reads
2024-03-01
403 reads
This is Why You Use Git for Scripts
Git is a good tool for DBAs and other Operations staff. Today Steve gives you a few reasons why.
2024-02-14
414 reads
2024-02-09
401 reads
Query Exercise: Find the Best Time for Maintenance
If we’ve gotta take the database down for maintenance – perhaps a version upgrade, perhaps upgrading our own code, maybe scaling up the hardware – when’s the best time to do it?
2024-02-07
Deploying Azure SQL Database Using an ARM Template
Provisioning infrastructure in a timely and reliable manner is essential for agile development. One well-liked method that lets you use code to automate resource management and provisioning is infrastructure as code (IaC). Azure Resource Manager templates are one IaC solution for Azure (ARM templates).
2024-02-02
2,609 reads
Backup SQL Server on Linux Databases using SQL Server Agent on Windows
In this tip, we're going to look at the steps to backup SQL Server on Linux databases using SQL Server Agent on a Windows server.
2024-01-01
The Profiler Extension in Azure Data Studio (ADS)
This article covers the basics of the Profiler extension in Azure Data Studio, a handy way to trace your application calls.
2024-03-25 (first published: 2023-12-29)
3,574 reads
Understanding Maximum Server Memory in SQL SERVER
This short piece explains the value of maximum server memory and shows you how to change this.
2023-12-27
5,320 reads
Blogs
Build a Snapshot Backup Catalog in Pure Storage - The SQL Server 2022 Edition
In my previous post, I showed you how to build a snapshot backup catalog...
Advice I Like: Training Employees
By Steve Jones
Train employees well enough that they could get another job but treat them well...
Creating a Striped Backup Set with AI
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Why Data Modelling Still Matters - More Than Ever
Comments posted to this topic are about the item Why Data Modelling Still Matters...
hops from sql server to mysql to s4 hana - possible?
Hi when i think of server hops , i think of how kerberos assists...
Question of the Day
Strange String Splits
When I run this code, how many rows are returned?
DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食' DECLARE @s NVARCHAR(1) = N'食' SELECT value FROM STRING_SPLIT(@meals, @s) GOSee possible answers