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 […]

11 things I wish I could tell myself as a Junior Software Developer – Michael’s Coding Spot

I’d like to tell my junior self that in 10 years, there wasn’t a single bug I didn’t eventually solve one way or the other. Even bugs that seem extremely scary, are eventually conquered. — Read on michaelscodingspot.com/2019/01/10/11-things-i-wish-i-could-tell-myself-as-a-junior-software-developer/

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 […]

Queensland SQL Server User Group Meeting Tonight

QSSUG Meeting This Thursday – 26th of November   The emerging field of "Location Intelligence" brings the worlds of Geographic Information Systems (GIS) and Business Intelligence (BI) together. These capabilities are now available with SQL Server in a no-coding, user-driven environment provided by the Integeo (www.integeo.com) Map Intelligence product. SQL Server 2008 also introduces a […]