Azure SQL Database Level Firewall Rules
I have written about Azure SQL Database LEVEL firewall rules before during my blog series, more specifically the security blog...
2017-10-20 (first published: 2017-10-11)
1,652 reads
All About SQL
SQL Server 2017 Encrypted Backups And Compression
Let’s work through some code to do an encrypted backup. This feature is available to you if you are using...
2017-10-18 (first published: 2017-10-09)
3,048 reads
Azure SQL Database Data Integrity Checks
If you remember last month I wrote about DBCC CHECKDB and Azure SQL Database, more specifically whose responsibility (Microsoft’s) it...
2017-10-04
478 reads
SQL Server Tracking Tempdb Size
Here is a quick Extended Events script I knocked up where I wanted to track Tempdb file size changes for...
2017-10-03
481 reads
SQL Server – Pause VS Stop
You have the ability to actually pause SQL Server, if you are in SQL Server Management Studio (SSMS), you might...
2017-10-02
352 reads
SSMS 17 Dark Theme
Have you ever wanted SQL Server Management Studio (SSMS) 17 to have a dark theme? Seeing the below image (visual...
2017-09-29
2,685 reads
Checking Out SQL Vulnerability Assessment
Apparently there is a new tool from Microsoft where you can discover, track, and remediate potential database vulnerabilities. This tool...
2017-10-09 (first published: 2017-09-28)
1,571 reads
Azure SQL Database Active Geo Replication Changes
Six months ago how you would go about setting up Active geo replication for your SQL Databases would be different...
2017-09-25
522 reads
SQL Server Tracking Suspect Pages
Did you know that SQL Server tracks suspect pages and puts the details into the msdb database in a table...
2017-09-25 (first published: 2017-09-19)
1,585 reads
SQL Server Schema Compare
A very common requirement which can be satisfied by various tools. Personally I like using Visual Studio 2017 Community Edition...
2017-09-18
516 reads
Blogs
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...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
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
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
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