(Pinal Dave) One of my blog readers sent me the following mail after reading my earlier blog posts about Random Function and OTP Code. Before you read the email, you can read those blog posts here, here, and here.
Editorials
- Interesting: Data Bread Lines
- Happening Now: Virtual Conference – Free
- Last Day: Free Virtual Conference Tomorrow!
SQL Server
Tips for designing SQL Server 2017 tables (Part 1)
October 17, 2018Tips for designing SQL Server 2017 tables (Part 1) Avoid using CLR user-defined data types. SQL Server 2017 supports the CLR user-defined data types. [...]
Categories of Database and Database Users – Part 1
October 15, 2018Database User Interface and Database End User There are four (4) unique kinds of database – framework clients, separated by the manner in which [...]When to Conduct a Project ‘Lessons Learned’ Session
October 12, 2018Does your evaluation need to be done after every successful or failed project to see if the methods used need to be changed? The short answer is [...]
- Tips for using SQL Server 2017 configuration options (Part 2)
- Tips for using SQL Server 2017 configuration options (Part 1)
- Database and Hashing Technique – Part 6
Other News
Configuring the MySQL Shell Prompt
(Jesper Krogh) With the introduction of MySQL Shell 8.0, the second major version of the new command-line tool for MySQL, a new and rich featured prompt was introduced.
The future of ASP.NET SignalR
(Andrew Stanton-Nurse) In ASP.NET Core 2.1, we brought SignalR into the ASP.NET Core family. Many of our users have asked what this means for the previous version of SignalR: ASP.NET SignalR.
Practical RPG: New RPG Features
(Joe Pluta) If you’ve been following my recent articles, you probably noticed I’ve been bouncing back and forth between RPG programming and SQL programming.
String.valueOf(Object) versus Objects.toString(Object)
(Dustin Marx) The handy method String.valueOf(Object) has been around since JDK 1.0 and is one of the JDK-provided methods that I use on a frequent basis. I have blogged on its value before.
Query Store and Log Backups
(Grant Fritchey) A question that came up recently around Query Store is what happens when there are log backups in use on the database. Let’s talk about it.
SQL Join overview and tutorial
(Prashanth Jayaram) The ability to combine results from related rows from multiple tables is an important part of relational database system design. In SQL Server, this is accomplished with the SQL join clause.
Injecting a Scoped service into IHostedService
(Peter Groenewegen) In our projects we are using IHostedService to run background processes. What I have seen is that when injecting a scoped service into the IHostedService you get a InvalidOperationException on startup.
User Account Control Message Box
(Shane Findley) Have you ever wanted to utilize a secure desktop authorization in the same way that the Windows User Account Control dialog does?
Quantum Computing: What you need (and don’t need) to know
(Thomas LaRock) Everyone’s pegging quantum computing as the next big thing in enterprise technology. Quantum computing is becoming as overhyped as Blockchain, if such a thing is possible.