Right-Click File Options in SSMS and SSDT
Ordinarily I wouldn’t blog solely about a set of right-click options in an application, but in this Eleven Days of Festivus series I’m sharing some quick tips that have...
2019-12-17
221 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
SSMS Tip: Regular Expressions in SSMS
Regular expressions (or simply regex for short) have long been used by system administrators and data professionals for searching and manipulating text. Regular expressions allow the user to find,...
2019-12-16
52 reads
SSMS Tip: Portable User Settings
I’m a creature of habit. With the software tools that I use, I like to have everything in the same place every time, even if I’m working on a...
2019-12-15
287 reads
SSMS Tip: Management Studio Script Projects
Did you know that SQL Server Management Studio can help you arrange your SQL scripts into logical groupings? SSMS includes the ability to associate multiple code files together into...
2019-12-14
42 reads
SSMS Tip: Vertical Text Selection
Occasionally, I’ll stumble across one of those neat tricks that makes me ask myself, “Why didn’t I know about this years ago?”. This next tip was one such discovery,...
2019-12-13
53 reads
SSMS Tip: Beep When Query Completes
I’m old enough to remember when multitasking was considered a good thing. From the same mouths that brought you “work smarter, not harder” came the advice to always be...
2019-12-12
51 reads
The Eleven Days of Festivus 2019
The weather is turning cooler, there is holiday music everywhere, and the relatives are all excited to get together and talk about politics. That can only mean one thing:...
2019-12-12
15 reads
PASS Summit 2019 – Day 1 Keynote
Today is the first full day of the PASS Summit, and this morning we kicked things off with a 2-hour opening ceremony and keynote. Networking and Growth PASS president...
2019-11-11 (first published: 2019-11-06)
460 reads
Using the SSIS Term Extraction for Data Exploration
Data exploration is an essential piece of any new ETL (extraction-transformation-load) process. Knowing the structure, type, and even the semantics of data sources can help the ETL developer or...
2019-10-01 (first published: 2019-09-23)
405 reads
Using the SSIS Error Output On the Data Flow
When working in the SSIS data flow, you’ll notice that many sources and transformations and some destinations have a built-in output to handle errors. The error output allows the...
2019-09-30
138 reads
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers