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,551 reads
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
991 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
781 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
749 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,287 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,150 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
677 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,634 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,855 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,800 reads
Blogs
SQL Server 2025
By Vinay Thakur
Microsoft announced on November 2024 a preview for SQL Server 2025 another major release...
Advice I Like: Apologies
By Steve Jones
How to apologize: quickly, specifically, sincerely. Don’t ruin an apology with an excuse –...
Build a Serverless Todo App With AWS, Pulumi, and Python
Try this step-by-step guide to build and deploy a scalable serverless app that’s accessible...
Forums
SQL Clustered Resource in online pending for about 3-5 mins before coming online
Hello! SQL Clustered resource used to come online during manual or automatic failover in...
SQL Query to use in MS SSRS server to give you your report structure.
Code that can be used in order to create dashboard or SSRS report on...
Temp table security
So, I have an interesting situation that I need a double-check on. One of...
Question of the Day
Escaping Like I
I have this data in a SQL Server 2022 table:
PlayerIDPlayerNamePlayerStatus 1The \%ChampActive 2The ChampActive 3The_ChampionActive 4The__ChampionActive 5The\_ChampActiveHow many rows are returned by this code in SQL Server 2022?
select PlayerName from player where playername like 'The\_C%' escape '\'See possible answers