SQLSaturday Orlando Notes – 45 Minute Sessions
Earlier this Brent ran a poll about the preferred session length and more than 50% liked the idea of 45 minute sessions. Interesting, the idea of trying to fit...
2019-10-27
9 reads
Andy Warren
Taking Notes – Paper or Keyboard?
Today we have a guest editorial from Andy Warren. When you need to take notes, how do you do it? Have you thought about it and experimented? Read on to see what Andy Warren does.
2019-10-25 (first published: 2012-01-31)
582 reads
SQLSaturday Orlando Notes – Speaker Gifts & Bags
I like to give speakers something to say thank you beyond the standard speaker shirt. It doesn’t have to be big, fancy, or expensive. I’ve always appreciated a hand...
2019-10-24
7 reads
SQLSaturday Orlando Notes – Speaker Shirts
I’ve always considered it important to offer a shirt to a speaker – part thank you, part making it easier for attendees to identify them as key volunteers. Does...
2019-10-24
10 reads
SQLSaturday Orlando 2019 Summary
Our 13th SQLSaturday is done. Some quick notes about the overall event, then as time/energy allow I’ll post separately on some things that went well (or didn’t) and some...
2019-10-22
30 reads
Would a Duress Password be a Good Idea?
Today we have a guest editorial from Andy Warren. Should we adopt a duress password, just in case we find ourselves in a movie situation while at work?
2019-09-26 (first published: 2015-04-21)
480 reads
Turn Out the Lights
Today we have a guest editorial from Andy Warren that looks at the costs associated with our behavior.
2019-09-06 (first published: 2016-01-18)
388 reads
SpeedPASS Printing
Based on the great post and script from Wayne Sheffield I decided to try again pre-printing the SpeedPASS for everyone this year. I dislike the line of shame and...
2019-09-05 (first published: 2019-08-21)
219 reads
Should Salary Information Be Confidential?
Today we have a guest editorial from Andy Warren as Steve is away from the office. Salary is a difficult topic for many, but Andy shares some thoughts.
2019-08-27 (first published: 2015-06-05)
608 reads
Worst Practices - Objects Not Owned by DBO
Last week Andy launched a new series about Worst Practices by talking about why the Hungarian naming convention is bad for column names. This week he's at it again, declaring that the practice of having objects owned by anyone other than dbo is BAD! Agree or disagree, we think you'll enjoy reading this article and adding your thoughts to the discussion!
2019-08-01 (first published: 2002-09-12)
38,336 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