You are browsing archives for
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
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 […]
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 […]
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 […]
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 […]
Its been a busy few weeks for me and I haven’t had as much time to catch up on my reading as I’d have liked. This is the list of things that I have been / trying to read. Software Development at Microsoft Observed Microsoft Research paper on developers� typical tools and work habits and […]
