(blobeater) Do you execute DBCC CHECKDB on your Azure SQL Database? From past experience I know some people do, I would suggest not to bother.
Community
Using PowerShell to Generate Logins, Server and Database Permissions
(Greg Larsen) If you have been a DBA for a while you have probably gone through at least one migration to a new version of SQL Server, or maybe even more than one migration.
SQL 101: Killing Open Query File Operations with SQL Cursors
(Rafael Victoria-Pereira) The prospect of “killing” those error-prone, problem-magnet Open Query File operations sounds nice, doesn’t it?
Annotation Handling and JPMS
(Peter Verhas) All Java developers have heard about annotations. Annotations are with us since Java 1.5 (or only 1.6 if you insist).
dotnet new worker – Windows Services or Linux systemd services in .NET Core
(Scott Hanselman) You’ve long been able to write Windows Services in .NET and .NET Core, and you could certainly write a vanilla Console App and cobble something together for a long running headless service as well.
Use Azure Cache For Redis In ASP.NET Core
(Bipin Joshi) Many ASP.NET Core application resort to caching for performance improvement reasons. I have discussed a few caching techniques in this, this, and this article.
You’re Using HttpClient Wrong
(Peter Vogel) There’s a very good chance that, every time you need to access a Web Service, you’ve been creating an HttpClient object and then throwing it away.
How to Build a Percona Server ‘Stack’ on a Raspberry Pi 3+
(Wayne Leutwyler) The blog post How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3 by Walter Garcia, inspired me to create an updated install of Percona Server for the Raspberry Pi 3+.
Delete MGMTDB and MGMTLSNR from OEM using emcli
(mdinh) Doc ID 1933649.1, MGMTDB and MGMTLSNR should not be monitored.
GoLang: Inserting records into Oracle Database using goracle
(brendantierney) In this blog post I’ll give some examples of how to process data for inserting into a table in an Oracle Database. I’ve had some previous blog posts on how to setup and connecting to an Oracle Database, and another on retrieving data from an Oracle Database and the importance of set