Can you believe SQL is nearly 50 years old? Not many programming languages have that kind of longevity. For much of that time, common convention for the language has been to list the keywords in ALL CAPS: SELECT column FROM table WHERE predicate This convention dates back a long way, and is not followed as […]
Entries Tagged as 'development'
Improving Readability of Complex Nested SQL
March 8th, 2023 · No Comments · development, sql, Sql Server, stackoverflow
Tags:
What you need to know about (nolock)
February 7th, 2023 · No Comments · development, sql, Sql Server
I sometimes see SQL posted online using a (nolock) query hint. If you’re inclined to use this hint, you should know it probably doesn’t accomplishing the benefit you hope for. It’s not an automatic “go faster” option. In fact, if such an option existed you can be sure it would be already enabled. Yes, (nolock) […]
Tags:
Let’s Make a Single Statement Mode for ADO.NET
September 5th, 2022 · No Comments · .net, security, sql, Sql Server, stackoverflow
One of the issues I see often in code on Stack Overflow is SQL injection. I still typically answer multiple questions per week that include, along with the rest of answer, some form of the text, “This is scary-vulnerable to SQL injection issues.” This is a “Really Big Deal”™. It’s one of about three things […]
Tags:
SQL and Dates
July 13th, 2022 · No Comments · development, sql, Sql Server
I want to clear up a few common issues I often see related to date values in SQL. Column Types The first of these is storing dates in a string column type, like varchar or nvarchar. Schemas that do this need to be fixed, because they really are broken. When you do this, you don’t […]
What’s up with MySql
May 4th, 2022 · No Comments · development, servers, sql
Historically, when one considers database server platforms there are four major players: Oracle, MySql, Sql Server, and Postgresql. (One could argue for Sqlite and even Access, but those are in-process engines and really belong in a different category.) Unfortunately, I question whether MySql still belongs with this group. It’s come to the point where I […]
Tags:
SQL vs NoSql
April 29th, 2022 · No Comments · development, sql, Sql Server
If you’ve heard of NoSql, maybe you wonder what it is and how it compares to a traditional SQL database. Let’s take a look. SQL databases store well-structured data using known schemas. They require rigid adherence to a set of design principles, but provide amazing power if you can learn those principles and the associated […]
Tags:
Certificate Authentication in SQL Server
November 23rd, 2020 · No Comments · development, networking, security, sql, Sql Server
I sometimes see questions asking how to do certificate authentication in SQL Server. Contrary to what you may have heard, SQL Server does indeed have support for certificate authentication. It just looks a little different from how some other database products do it. Instead, SQL Server’s equivalent option is the Integrated Security feature. It works like this…
Tags:
Indexing a CSV file with .Net
November 28th, 2018 · No Comments · .net, stackoverflow
I recently answered a Stack Overflow question, where I supplied what I believe may be a useful tool for indexing simple CSV data where you might not want to hold the entire data set in memory. I wanted to list it here, because I added the solution that supports CSV as an afterthought; the question […]
Tags:
PowerShell ExpandProperty vs Property
October 2nd, 2017 · No Comments · development, Powershell
I’m only an occasional PowerShell user, and therefore it’s taking some time to develop a deeper understanding of the language. I’m gonna share something that recently clicked for me that I think isn’t well explained elsewhere: using ExpandProperty, especially in combination with understand putting values vs Objects on the pipeline. ExpandProperty is part of the […]
Tags:
The Missing DHCP snap-in for Windows 10 Remote Server Administration Tools
November 6th, 2015 · 4 Comments · .net, c#, development, networking, Powershell, servers
If you’re used to managing Windows Servers, you’re likely familiar with the Windows Server Remote Administration Tools. These tools are packaged as a download for each client (not server) version of Windows. They provide the same set of MMC snap-ins you’ll find on a server, such as Active Directory Users and Computers, DNS, or Group […]
Tags: