2023-01-09
474 reads
Uncategorized
Using sp_prepare and sp_execute to utilize prepared SQL statements
Learn about prepared statements in SQL Server, what they are, and how to use them along with the commands sp_prepare and sp_execute.
2023-01-06
2023-01-06
164 reads
Ethical Hacking Tutorial
This article explains ethical hacking and how this might be a career field worth pursuing.
2023-01-06
3,782 reads
The Tech That is Gone
As we start a new year, Steve looks back at old technology that doesn't exist anymore.
2023-01-04
159 reads
2023-01-04
477 reads
2023-01-02
467 reads
2023-01-02
A New Year, New Efforts
Happy New Year! You're going to be seeing a lot of summaries for 2022 and predictions for 2023 around this time of year. I'm not writing one of those. You'll also see people calling for new years resolutions and the like. I'm not going for that either. Nope, let's keep it simple. It is a […]
2022-12-31
70 reads
Secure File Transfer Protocol (SFTP) support for Azure Blob Storage
In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.
2022-12-30
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers