SSMS Keyboard Shortcut Fun
Andrea Allred (@RoyalSQL) just gave her SQL tips and tricks session at SQL Saturday Salt Lake City, and a great time was had by all! I learned some things...
2019-08-03
54 reads
Jen McCown
Fun with PowerShell: I made a game
So we got to playing around with PowerShell last week – one son is making a game hack, and the other...
2018-11-19
211 reads
Live blog: Women in Technology lunch at #PASSSummit #passwit
11:48am This will be starting shortly! We’re stuffing our faces, first. Today’s featured speaker is Lauri Bingham, Director of Technology Engineering...
2018-11-08
204 reads
SQL work-vacation, Thursday! (#Workation #PASSSummit)
Hello yet again! I’ve been writing about our time this week in Seattle, for the PASS Summit. Saturday, I wrote that we’re here...
2018-11-08
186 reads
SQL work-vacation, Monday (#Workation #PASSSummit)
Hello again! Sunday, I wrote that we’re here in Seattle for the PASS Summit, and that it’s my tenth year. AND that...
2018-11-05
189 reads
SQL work-vacation, T-2 days (#Workation #PASSSummit)
We are at PASS Summit 2018 in Seattle, and I will write a bit about each day I'm here, just...
2018-11-04
200 reads
Regular Expressions: tagging expressions
I re-discovered something very cool while using RegEx in SSMS today: tagging expressions and referencing them in the same line! I’ll take...
2018-10-15
374 reads
sqlhelp: limit the x-axis of a geometry line graph
I have a #sqlhelp question that requires some code. So hey, blog post time! TL;DR: the geometry::STGeomFromText graph provides too wide...
2018-09-26
367 reads
More PowerShell for fun (and profit) – filter files by date
PowerShell provides an easy way to search for and/or delete just the files you want. Let's look at navigating in...
2018-09-24
733 reads
All about PASS Summit 2018
Here are the things you must/should probably know about PASS Summit 2018, as told by me. First Timers Read this...
2018-09-19
245 reads
Blogs
T-SQL Tuesday #193 – A Note to Your Past, and a Warning from Your Future
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
Keeping MS Docs Up to Date
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
Patch Tuesday – Where to get more information
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
Forums
Change Tracking – Troubleshooting
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to the 1st 21 rows?
is there a no code way to limit an ssis extract from excel to...
Pivot but preserve all rows on Aggregate column
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
Question of the Day
What is the PRODUCT
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers