Skip to main content

VSCode Tip – Rename Multiple Attributes At The Same Time

Multiple cursors is one of my favorite features in VS Code. Just highlight what you want and hit cmd/ctrl + d to highlight all matching snippets. Then type away! I use this to add multiple classes, delete multiple elements, and edit attributes. pic.twitter.com/1ukxXsVdHS — Emma Wedekind ✨ (@EmmaWedekind) March 27, 2019

Get free technical eBooks on SQL Server 2017 from Microsoft

Build your Microsoft SQL Server expertise with technical deep dives for your database journey. Free PDF eBooks from Microsoft SQL Server eBook series Get the technical resources and documentation you need to explore SQL Server 2017 – a comprehensive, mission-critical database for demanding workloads. With this series of technical eBooks on SQL Server, you’ll learn […]

10 Programming Terms in Normal Human Language

Immutable Immutable is another word for unchanged. If a state is said to be immutable, it means that it’s not supposed to change. Whatever value you’ve set is not going written over or have the potential of changing. In JavaScript, const is a way to partially declare an immutable value. You can still change the […]

SQL Server Table Function Performance

Rob Farley has a great post on when is a SQL function not a function? Read the two below functions – they return the same thing, but one is more effecient than the other. If you can’t see why, head over to Rob’s post that shows the execution plans for a great explaination. CREATE FUNCTION dbo.FetchSales_inline(@salespersonid […]

ANSWER: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’

I came across an interesting problem last night – a stored procedure that had been created years ago was suddenly coming up with this error message: UPDATE failed because the following SET options have incorrect settings: ‘ANSI_NULLS, QUOTED_IDENTIFIER’. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or […]