Basic Checks on a New AWS RDS SQL Server
When you first become responsible for a new RDS instance, what do you do? Kenneth Igiri gives you a few queries to get you started.
Upgrading SQL Server Central
It's time to look at an instance upgrade for SQL Server Central. Or is it? Steve shares some thoughts about the process and decision making.
Introducing the MySQL DELETE statement
In this article, I focus exclusively on the DELETE statement to help round out our discussion on the core DML statements in MySQL. Overall, the DELETE statement is fairly basic, but one that’s no less necessary to have in your arsenal of DML tools.
Reviewing SQL Migration Files Before a Flyway Migration
This article demonstrates how, once armed with the file path locations of all the scripts, you can use PowerShell to search them for various purposes such to review them for potentially disruptive changes, or run code quality checks, or to verify documentation standards.
Automate Power BI desktop data model with a PowerShell script
Learn how you can use PowerShell to update the Power BI data model.
The Time Thieves
Learning to efficiently manage time in a team is hard. Steve has a few ideas today, based on a book.
Exploring Hive Tables with Spark SQL
In this article, we will look at how to use an Azure Databricks Workspace to explore Hive tables using Spark SQL along with several examples.
New DevOps Process Improvement Course
However chaotic or predictable your DevOps processes currently are, the new video learning pathway from the Redgate University will help you prioritize what to improve first, provide step-by-step guidance on how to implement those improvements, and show you ways to measure them. Start learning.
Poking the Bear
If you're an experienced, knowledgeable, seasoned (I won't say old), SQL Server data professional, and you choose to use Trace Events (Profiler), more power to you. That's it. That's all I have to say. Do what you think best. I'm never, ever (again), going to second guess you. Further, my apologies for ever having done […]
Data Activity Tracking Using SQL Triggers
This article goes into a framework for tracking data manipulation activity using a few triggers.
Blogs
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
T-SQL Tuesday #200: When I Look at a Query …
By Steve Jones
This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...
Forums
ALAMAT KONTAK BCA KCP Cikande WA {08218154393}
WA:08218154393 Kawasan Industri Modern Cikande, Komp. Ruko, Jl. Raya Jkt No.Km. 68 Blok C-6,...
ALAMAT KONTAK BCA KCP Ciceri Telp:08218154393
WA:08218154393 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Alamat Kantor BCA KCU SIDOARJO Wa(082144477715)
Wa:0821-4447-7715 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa Timur...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers