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,565 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
1,000 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
783 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
751 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,307 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,162 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
682 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,640 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,862 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,818 reads
Blogs
Terraform Commands
I realized I never created a post to show how to deploy Terraform from...
T-SQL Tuesday #189–AI and your Career
By Steve Jones
I’m late to the party this month. Taiob Ali has a great invite for...
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and...
Forums
Building a Database Dashboard with SSRS
Comments posted to this topic are about the item Building a Database Dashboard with...
CDC job running for 17 days?
Good morning, I've noticed my CDC job running for 17 days. I've noticed it...
Database growth events for unidentified databases
We have recently upgraded from SQL Server 2016 to 2022 Standard Edition. Our nightly...
Question of the Day
Determining the Updated Columns
I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:
CREATE TABLE CustomerLarge ( CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED , CustomerName VARCHAR(20) , CustomerContactFirstName VARCHAR(40) , CustomerContactLastName VARCHAR(40) , Address VARCHAR(20) , Address2 VARCHAR(20) , City VARCHAR(20) , CountryCode CHAR(3) , Postal VARCHAR(20) , creditlimit INT , discount numeric(4,2) , lastorderdate DATETIME , lastorderamount NUMERIC(10,2) , lastordercontact VARCHAR(20) , created DATETIME , modified DATETIME , modifiedby VARCHAR(20) , statusid INT , active BIT , customersize INT , primarysalesid INT) GOIf I want to detect that the creditlimit was updated, what IF statements should I use? See possible answers