(Peter Vogel) In many of these tips, I’ve suggested ways that you might want to change Visual Studio’s default configuration. That’s not always a good thing.
Other News
Guru: When Playing With SQL
(Paul Tuohy) One of the questions I have been asked a lot at conferences is “How do you figure out x in SQL?” In this article, I will discuss four things I use a lot when playing with SQL in Run SQL Scripts: VALUES, SYSIBM.SYSDUMMY1, global variables, and the system catalog.
Troubleshooting SQL Server 2017 backup/restore problems
Troubleshooting SQL Server 2017 backup/restore problems If you have problems with SQL Server 2017 backup/restore, review this troubleshooting checklist to find potential solutions. 1. Check that you have appropriate permissions to make backup/restore. To backup database or transaction log, you should have BACKUP DATABASE or BACKUP LOG permissions granted to you, or you should be a member of the sysadmin…...
Monitoring Your Databases and Servers and…
(Grant Fritchey) You absolutely need to know about the servers you have under management in your estate. You need to know about the databases. Uptime, performance, behaviors, errors, corruption and a much longer list of items that will frankly fill this blog post, are very important to you.
How Roles Have Changed in MySQL 8.0 and How to Use Them
(Joshua Otwell) Database Security is important to any MySQL setup. Users are the foundation of any system. In terms of database systems, I generally think of them in two distinct groups:
The Action Pattern: Clean, Obvious, Testable Code
(Ryan Glover) Let’s convert a mock API endpoint for signing up new users in a mobile app into using the action pattern.
Powershell script to find SQL Server Instances on a Server
(Jack Vamvas) Question: How can I find the SQL Server Instances on a server using Powershell ? Either the local server or remote SQL Servers.
SQL SERVER – Stretch Database – ERROR: The Provided Location is Not Available for Resource Group
(Pinal Dave) This was my first experiment with this feature called Stretch Database. I have started the wizard and encountered at the very end. Here is the error message.
Java XML and JSON: Document processing for Java SE, Part 2
(Jeff Friesen) In this post, we’ll continue exploring XML and JSON in Java 11 and beyond.
Managing Containers and Code for DevOps
(Stephen Watts) Containers help applications run reliably in a number of different environments, from testing to deployment, on a variety of devices, both large and small. Using containers in the development process creates a solution to the problem of how code runs in non-identical environments.