Ars Technica

SQL: behavior of "WHERE Fieldname <> 'foo'" with null values, best solution?

just some info for anyone else who's not a sql guru:<BR><BR>i did the following selection on a table:<BR><BR>SELECT * FROM Table WHERE myField <> 'active'<BR><BR>the values in that colum are a mix of ...
Wired

SQL Basics: Four Reasons Never to Select All

Have you ever written a database call that went something like... select * from posts where id=3;? We probably all have, but it's bad for several reasons. Four of ...
Visual Studio Magazine

Speed Up Your Application with SQL Server In-Memory Tables

I've said it before and I'll say it again: If you want to speed up your application, don't look at your code, look at your data access. The two slowest things you can do in application development are ...
Visual Studio Magazine

Elevate SQL Development with VS Code

As SQL development increasingly becomes part of full-stack workflows, developers are looking for ways to simplify their tooling without compromising capability. While SQL Server Management Studio ...