Friends of Redgate 2015
Reading Time: 2 minutes
It’s official, I am in Friends Of Redgate for 2015!
Ok, the last few months have been an...
2015-01-27
815 reads
WaterOx SQL
Identify Primary Keys That Are Not Identity Columns
Reading Time: 3 minutesPrimary Keys help keep your database in balance
Continuing the thoughts of knowing what is going on in...
2015-01-13
1,128 reads
Have We Devalued SQL Server Consulting?
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training of SQL Server...
2014-11-21
612 reads
Have We Devalued SQL Server Consulting?
Reading Time: 3 minutes
Have we given too much away?
SQL Server has an amazing community. It freely provides information and training...
2014-11-21
335 reads
12 Things To Check With SQL Server To Prepare For Winter
Winter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts are predicting massive...
2014-11-14
1,062 reads
12 Things To Check With SQL Server To Prepare For Winter
Reading Time: 8 minutesWinter is coming! Is your SQL Server ready?
There you sit, watching TV, when you hear it: “Analysts...
2014-11-14
632 reads
Versioning In Your SQL Database
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking about version control,...
2014-11-12 (first published: 2014-11-07)
6,986 reads
Versioning In Your SQL Database
Reading Time: 4 minutes
What Is The Point of Versioning?
How do you know change occurs in your database?
Now, I’m not talking...
2014-11-07
636 reads
When Things Align Unexpectedly
Things are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have aligned. I am...
2014-11-02
866 reads
When Things Align Unexpectedly
Reading Time: 4 minutesThings are happening
or: Learning to Not Look a Gift Horse in the Mouth
The stars seem to have...
2014-11-02
402 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