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 […]
Entries Tagged as 'networking'
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:
Using Flash in the Browser post-2021
January 21st, 2021 · No Comments · IT News, networking, security, Windows
Think Flash is dead? Think again. I present you a method to run Flash in a variant of Google Chrome in 2021.
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:
Tracking through Lightspeed: Complexity vs Reliability
December 18th, 2017 · No Comments · networking, non-computer, servers
If you haven’t yet seen “The Last Jedi” and don’t want part of it spoiled, you may want to give this one a pass. I’m going to focus on how a scene from the movie relates to current technology. In the “The Last Jedi”, part of the plot revolves around trying to shut down a […]
Tags:
Supporting Outlook with G Suite
May 4th, 2017 · No Comments · IT News, networking, security
Where I’m at, we use Google Apps (G Suite) for e-mail, but still rely on Active Directory for individual accounts and use MS Office rather than Google Docs most of the time. One situation to come up in the last few years is Google no longer supports MS Outlook out of the box. If you […]
Tags:
What are “Less Secure Apps” in Google?
May 4th, 2017 · No Comments · IT News, security
If you’ve tried to use Outlook or another traditional e-mail client with GMail, you may have run into this requirement to enable “Less Secure Apps”. There are other situations that may prompt you to turn this on, as well. What does that mean? Why does it matter? I think I can explain. Google, by default, […]
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:
Cleaning an Infected Computer at Work
September 23rd, 2014 · No Comments · security, superuser
I have two basic philosophies underpinning how I approach infected computers. To begin with, I don’t really believe in cleaning an infected computer at all. I could cover the reasoning for this in more detail, but I already have a well-voted answer on SuperUser.com that I think says it better than I could fit here. For computers […]
Tags:
The N Word
May 9th, 2014 · No Comments · sql, Sql Server
No, not that N word. I’m talking about N string literal prefixes in T-SQL. Like this: SELECT * FROM Foo WHERE Bar = N’Baz’ If you don’t know what that N is for, it tells Sql Server that your string literal is an nvarchar, rather than a varchar… that is, that the string literal may […]
Tags: