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)
574 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
29 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)
475 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)
379 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)
218 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,273 reads
Blogs
The Ireland and UK DevOps Roadshow
By Steve Jones
We’re taking the roadshow across the water. Hope the plane makes it. The Redgate...
SQL Aggregate Functions: Your Essential Guide & Cheat Sheet
SQL aggregate functions are your go-to tools for transforming raw data into actionable insights....
T-SQL Tuesday #174 – My Favorite Interview Question
By Steve Jones
This month is a great topic to me. I think growing and improving your...
Forums
Creating Statistics on XML
Comments posted to this topic are about the item Creating Statistics on XML
Managing SQL Agent in Azure Data Studio
Comments posted to this topic are about the item Managing SQL Agent in Azure...
Database design help and tips for a small app used to coach tennis players.
Hi, I hope this isn't too long of a question- I tried to make...
Question of the Day
Creating Statistics on XML
I have a table in SQL Server 2022 that is an XML data type. I have an index on this column and want to create statistics using CREATE STATISTICS for some of the data in the column. What should I do?
See possible answers