Upcoming full day training: “How to Architect Successful Database Changes”
I’m excited to be teaching a full day session with Steve Jones at the SQL PASS Summit on Tuesday, November 5, in Seattle. Steve and I will be discussing...
2019-04-19
1 reads
Take the 2019 State of SQL Server Monitoring Survey: Here’s What’s in It For You
Calling all Database Administrators, Developers, Analysts, Consultants, and Managers: Redgate has a survey open asking how you monitor your SQL Servers. Take the survey before April 5, 2019. Your...
2019-03-19
2 reads
The SQL Server Data Row Size Question: Why is It Bigger?
This morning, I received the following question from a user: Hello Madam, Could you please clarify SQLServer “Data Row” size: If I run the script below on SQL Server...
2019-03-19
1 reads
Why to Avoid Using the Current Database Name in Object Definitions in SQL Server
I’ve recently published an article, “Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures,” over on Simple Talk. In the article, I discuss:...
2019-03-18
1 reads
PASS Summit 2019 Call for Speakers is Open – How I Sketch Out My Submission Ideas
Are you interested in speaking at the Professional Association for SQL Server’s annual Summit conference? The call for speakers is now open, and you may submit up to three...
2019-03-13
1 reads
Contest: Tell Your Database Development Disaster Story (5 winners get $150 USD or more each)
Redgate is building a library of real-world stories about database development disasters. Your mission: Tell us a true story in 500 words or less about a time when you...
2019-03-12
Watch: Kendra Breaks and Fixes SQL Source Control (9 minutes)
I love breaking technology. Well, I love breaking technology on purpose, in a place where it’s not going to slow anyone else down. It’s a great way to learn...
2019-03-04
4 reads
New Free Videos on SQL Prompt, SQL Compare, and SQL Doc with Redgate’s SQL Change Automation
I’m excited to have just clicked ‘publish’ on four new videos in the brand new Evangelist Tutorials playlist on Redgate’s YouTube channel. These videos step through setting up and...
2019-02-15
1 reads
What a Software Evangelist Does – and Where the Job is Going (Dear SQL DBA Episode 67)
I’ve been working as an Evangelist at Redgate for close to six months now, and one question keeps coming up: what exactly does an Evangelist do at a software...
2019-01-29
3 reads
State vs Migration for Database Source Control – decide based on one question
One controversial topic in database development is how to properly store and deploy database changes. This is generally described as choosing between two options, which are approximately as easy...
2019-01-23
3 reads
Blogs
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
T-SQL Tuesday #180: Good enough is perfect Roundup
This month, I prompted bloggers to discuss whether good enough is perfect. Thank you to all...
Using SQL Compare with Read-only Access
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
Forums
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
New SQL Server 2022 Functions
Comments posted to this topic are about the item New SQL Server 2022 Functions
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