Hostettler the Viking Needs a New Ship and Your Help
Hostettler the Viking Needs a New Ship…And Your Help.
My good friend Justin Hostettler Davies (Blog@DBExpertise) pinged me a mail in...
2011-04-11
582 reads
Gethyn Ellis
Microsoft Migration Assistant v5.0 Released
As I was surfing around twitter after the marathon TV event that was the Royal Wedding came to end last...
2011-04-06
685 reads
Blog Syndication
I got sent an email recently asking how I went about syndicating my blog on some of the popular SQL...
2011-03-21
1,729 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-18
2,146 reads
Becoming a DBA: How to gain experience
Last week I had an interesting telephone call from a someone who I connected with on linkedin.com. On Linkedin I’m...
2011-03-16
1,683 reads
Stored Procedure Definitions and Permissions
I wrote a post a while back that showed how you can grant execute permission ‘carte blanche’ for a database...
2011-03-14
2,781 reads
The Joy of Contracting
As you may or may not know I have been contracting since 2007, almost 4 years now and I have...
2011-02-21
910 reads
February Update
I haven't written anything for a while and again, for the second month running I missed TSQL2usday. It's a shame...
2011-02-15
474 reads
Shameless Plug: My First SSC Article Published Today
Please forgive the shameless plug. My first article was published today on sqlservercentral.com. It’s titled “Backup and Housekeeping with Maintenance...
2011-01-26
548 reads
Ebooks: Deal of the Day
Apress, as I expect you know, publish some really good SQL Server books. Some of which are on the MCM...
2011-01-24
620 reads
Blogs
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...
How to find free space in Azure PosgreSQL
I wanted to figure out how big (or approximately how big) my dump file...
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