(Pablo Echeverria) For compliance auditing, a customer asked for a list of users who have read or write access in any database on the SQL Server instance. Although there are several tables that can provide us the information, the permissions can be at the instance level or at the individual database
Other News
Implement Column Chart With Fusion Chart Library In ReactJS Application
(Ankit Kanojia) Fusion Charts is a JavaScript charting library which provides more than 95 charts and 2,000 maps which can be used fully in mobile and web applications.
designMode
(David Walsh) Every once in a while I stumble upon an API or browser setting that I can’t believe ever existed.
Visual Studio now includes an integrated Terminal
(Scott Hanselman) It’s early days (preview) but there’s now a Terminal integrated into Visual Studio! Taking a nod from the 2017 plugin, the Terminal is now build in as an experimental feature using features from the NEW open source Windows Terminal.
Improved MySQL Query Performance With InnoDB Mutli Value Indexes
(Dave Stokes) Multi-Valued Indexes are going to change the way you think about using JSON data and the way you architect your data.
OIC: Making a REST Integration Returning a 404 instead of 500
(Jan Kettenis) In this article I describe how to return a HTTP 404 (resource) Not Found with a REST integration that on its turn calls another REST service that returns a 404.
SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally
(Pinal Dave) My favorite part of Comprehensive Database Performance Health Check is to resolve slow issues which are often very complicated to resolve. Recently I was hired for a specific task where my client had a very important query running usually in just subsecond, running for over 60 seconds o
I Have an Employee That Spends All Day on His Phone
This question came from a busy business owner. I have an employee that spends all day on his phone, but he always gets his work done well. Other members of the team are annoyed by him. Do I fire him? I am sure that “spends all day on his phone” is an exaggeration, but I get your point. I have...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Database Fundamentals #22: Using the Join Operator, CROSS JOIN
(Grant Fritchey) While the CROSS JOIN is not used much, and, depending on the size of your data it can be dangerous, there are some uses for it.
The DB2Night Show #217: Light at the End of the Encrypted Tunnel
(Martin) 100% of our studio audience learned something!Greg presented a thorough introduction to using TLS with Db2 LUW 11.5.