How to get Open Live Writer working with Blogger
Wow – I didn’t blog at all in 2016! While I’m certain that falls squarely on me, perhaps a small part...
2017-02-10
1,596 reads
New York City .NET
Fixing Truncation Issues with T-SQL Flex
If you’ve worked with SQL Server for any length of time, you’ve run into this error:
Msg 8152, Level 16, State...
2015-12-21
1,051 reads
Talking TypeScript on the .NET Rocks! Podcast
I appeared on the .NET Rocks podcast show #1149 this week. I had a blast talking about TypeScript, the new...
2015-06-09
797 reads
Excel 2013 Conditional Formatting for Columns
If you have two columns in an Excel sheet, and you want to conditionally format fields in the second column...
2015-01-14
776 reads
Enabling Portable Git in Node.js command prompt on Windows
GitHub for Windows doesn't put Git in the PATH by default. If you'd like your Node.js command prompt to have...
2015-01-08
1,340 reads
Using an alternate TypeScript compiler inside Visual Studio
TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:
https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204
He...
2015-01-06
1,179 reads
Gmail and Match.com are Conspiring to Breakup My Marriage
My wife and I are happily married. Both of us were surprised the other day when she started getting Match.com...
2014-12-01
696 reads
Setting up WebStorm to debug grunt with TypeScript
It’s possible to use the WebStorm editor to debug grunt tasks if you are using TypeScript and generating .map files. ...
2014-11-28
1,660 reads
New Add-on for SSMS: T-SQL Flex
Do you ever copy query results out of SQL Server Management Studio, paste them into your text editor, and then...
2014-09-11 (first published: 2014-09-08)
10,885 reads
How to Generate a Fiddler SAZ File
Fiddler is a free program that will log HTTP and HTTPS requests on Windows. These instructions demonstrate how to use...
2014-07-08
2,856 reads
Blogs
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers