SQL Saturday #57 – Houston
SQL Saturday #57 was this weekend! Sean and I went, talked, webshow-ed, and then presented a total of SIX sessions!
Travel
Sean and...
2011-01-31
1,633 reads
Jen McCown
Un-SQL Friday #002 Roundup (finally)
The invitation for Un-SQL Friday #002 (Tech Giants) was, like, a week ago! I’ve gotta get this train a-rollin, or...
2011-01-28
957 reads
My Surprise MVP Party
Two Fridays ago, Sean and I sat down for our weekly DBAs@Midnight webshow* as usual. Unusually, we were expecting an out-of-town...
2011-01-24
571 reads
RTFM365, Week 7
[Commence whine-a-thon, thinly veiled as an introductory paragraph to a blog.]
As I knew it would, it is getting VERY difficult...
2011-01-24
483 reads
Blog Sins
Thoughts come together, and the hybridization of your thoughts give rise to new ideas. Here are the thoughts:
I have this...
2011-01-21
663 reads
Un-SQL Friday: Your Tech Giants
This started as just a regular blog…but it’s sparked such a big conversation online, I’ve decided to make it an...
2011-01-19
1,078 reads
Who do you want to see at SQLRally and 24HOP?
I dig democracy: I like all this voting for SQL sessions at events.
Voting is open this week, Jan17 – 23, for...
2011-01-19
613 reads
RTFM365, Week 6
Just a quick note this week….things are quite crazy right now, and I’m struggling to keep reading on my days...
2011-01-18
428 reads
T-SQL Tuesday #014 Roundup
Wow…the inagural 2011 T-SQL Tuesday was so big, it lasted a week! A few quick observations, then on to the...
2011-01-18
1,265 reads
T-SQL Tuesday: Resolutions
In my invitation to T-SQL Tuesday #014, I picked the topic “Resolutions”, clearly to play on the new year. The...
2011-01-11
745 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