The Right Consultant Is Worth All The Money
Hiring consultants is like buying a new washing machine. In other words, you get what you pay for some times. A couple of months ago, my washer and dryer...
2019-11-15
1 reads
John Morehouse | Sqlrus.com
Rounding Out PASS Summit 2019
If you are like me, when certain events end, it is a bittersweet time. You’ve enjoyed your time with people you consider family, got to learn some new things...
2019-11-15 (first published: 2019-11-08)
425 reads
Presenting Two Sessions at PASS Summit 2019
In just a few days, I’ll begin my annual journey to Seattle, Washington for the PASS 2019 Summit. This is one of my favorite conferences to attend. It is...
2019-10-30
15 reads
Improving TweetDeck with Better TweetDeck
If you are at involved with the #sqlfamily, you are bound to hear about the benefits of social media platforms such as Twitter. Twitter helps us to engage each...
2019-10-31 (first published: 2019-10-18)
315 reads
HammerDB for Azure SQL DB
Bench marking your environment is an important step when introducing new hardware, which is accomplished by running a test workload against the hardware. There are multiple ways to...
2019-10-03 (first published: 2019-09-27)
762 reads
Using Powershell for SQL Saturday Logos
Out of necessity are born the tools of laziness. This is a good thing. I have found that organizing and running a SQL Saturday event is a great way...
2019-09-23 (first published: 2019-09-13)
355 reads
Moving to Azure SQL Database Serverless
In a previous post, I discussed the public preview of Azure SQL Database Serverless. This is a newer product released from Microsoft for the Azure ecosystem. Moving to this...
2019-09-13 (first published: 2019-08-30)
960 reads
Finding the Best Azure Datacenter
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
298 reads
Getting Your SQL Server Backup Footprint
Recently, I needed to be able to determine the total size for all the most recent full backups for certain servers. Luckily for me these particular servers were using...
2019-07-15 (first published: 2019-06-28)
455 reads
SQL Server Data Pages on Linux
One of the new phrases coming out of Microsoft is that “SQL is just SQL” regardless of what operating system...
2019-03-22
439 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
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