How to store a password in a database
Hello, and welcome to today’s class on storing passwords in a database. Don’t store passwords in a database. Thanks for attending. Photo by James Sutton… Read More »How to store a password in a database
My IT department installed an antivirus with SQL Server
Time for another short blog post, and this one combines two topics I am very passionate about: security, and SQL Server performance. Let’s start by… Read More »My IT department installed an antivirus with SQL Server
Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I… Read More »Do you even PowerShell, bro? An ode to dbatools and dbachecks.
Secure or fast? Secure, obviously …
By now you have probably seen the news about a major flaw in the design of CPUs from all major vendors (Intel, AMD, and ARM)… Read More »Secure or fast? Secure, obviously …
All Mac users should do this immediately
This post is a public service announcement for all users of macOS High Sierra (10.13). (Note: Apple has already released a fix, but if you… Read More »All Mac users should do this immediately
SQL Server 2017 Administration Inside Out
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
Is Transparent Data Encryption just security theatre?
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t already have enough on my… Read More »Is Transparent Data Encryption just security theatre?
Connect Windows 10 client to a VPN on Windows Server 2012 R2
I got a strange request in a Slack channel the other day. A colleague in South Africa, who uses Windows, was unable to connect to… Read More »Connect Windows 10 client to a VPN on Windows Server 2012 R2
Wait For Service Pack 1
Conventional wisdom tells us that when Microsoft releases a new version of any server product, we should wait until Service Pack 1 before deploying it… Read More »Wait For Service Pack 1
Do you need access to Production?
During a recent client meeting about a database migration, I realised that I have never logged into a SQL Server on their production environment. My… Read More »Do you need access to Production?
Compressed and Encrypted Backups on the Cheap
We back up our databases regularly. We store them on a secure network location so that if the database drive fails, we can still satisfy… Read More »Compressed and Encrypted Backups on the Cheap
Modifying Temporal Tables – A Primer
This is part three of the Temporal Tables series. You can read parts one and two here. Last week I demonstrated how temporal tables in… Read More »Modifying Temporal Tables – A Primer
End of Life for Microsoft Windows XP and Server 2003: Six-One or Up
Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an… Read More »End of Life for Microsoft Windows XP and Server 2003: Six-One or Up
- « Previous
- 1
- 2