SQL Server Monitoring Using Free Tools
You can do essential monitoring of SQL Server instances and databases with a FREE toolkit!
2022-01-28
6,345 reads
Uncategorized
Most of Us Are Vulnerable
Security is hard, and while data professionals might not be responsible for network issues, we ought to be aware that there could be vulnerabilities that might attack our systems.
2022-01-19
238 reads
Creating and Using Inline Table-Valued Functions
Inline Table Valued Functions (iTVFs) are one type of user defined function that is available to implement in SQL Server since SQL Server 2000.
iTVFs remain a very useful tool in our SQL armoury, so let's quickly revisit them and the different ways we can use them in our code.
2020-10-07 (first published: 2020-09-08)
41,980 reads
Your Data After Life
Today Steve thinks about what to do when planning for your digital assets after you pass.
2020-07-17
300 reads
2020-07-15
114 reads
Is AI human-ready?
Aleksander Madry discusses roadblocks preventing AI from having a broad impact and approaches for addressing these issues.
Continue reading Is AI human-ready?.
2019-04-17
8 ways for banks to use AI
If a bank gets in touch with a software company and wants to know how it could use artificial intelligence (AI), that means two things. First, the bank is...
2019-04-16
Here and now: Boosting anti-money laundering efforts with Artificial Intelligence
Anti-money laundering has been an issue for banks and financial institutions for some time. Transaction monitoring systems have been around for many years. Meeting and complying with regulations at...
2019-04-15
Its time to accelerate the State of DevOps
Redgate is joining forces with DevOps Research and Assessment (DORA), now part of Google Cloud, as a sponsor of the 2019 Accelerate State of DevOps Report, and we're excited...
2019-04-11
Index Column Order – Be Happy!
Ever wonder about index column order; this piece should give some insight.
2020-12-04 (first published: 2019-02-28)
8,247 reads
Blogs
How to Run Databases on Kubernetes: An 8-Step Guide
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
Forums
What is the best index strategy for a table that gets truncated?
Hi everyone My SSIS package does a bulk insert of csv files into a...
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers