(Martin Berger) Sometimes it might be interesting to understand, what’s the SQL statement which is currently executed.
Other News
Excel Data Mapping to Update Existing Documents
(David McGahey) Excel began life as a simple spreadsheet tool. Over time, support for rich text styling options, built-in charts, and copy and paste formatting features has led many enterprises to create reports in Excel documents.
A Condensed 35-Year History of DB2 for z/OS (…and Db2 for z/OS)
(Craig S. Mullins) Let’s go back in time… over three decades ago… back to the wild and woolly 1980s! And watch our favorite DBMS, DB2, grow up over time.
Introduction to Azure SQL Database Instance Pools
(Marcin Policht) In one of the article, Considerations for Deploying Azure SQL Database Managed Instances, recently published on this site, basic characteristics of Azure SQL Database Managed Instance were described.
Decoded Statistics Names and More
(Jason Brimhall) Every now and again I am asked about the meaning behind the automatically generated names for statistics in SQL Server. The quick answer is short, sweet and really easy.
PART I: Overview of Distributed Database
Distributed Database Collection of several interconnected databases which are physically distributed to different locations and they can communicate over a computer network is called Distributed Database. Features of Distributed Database The databases in the collection are logically linked. They often represent a single logical database. Data is physically stored in multiple locations. The data of each location can be managed...
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
Explore Blazor WebAssembly – use custom style, call external WebAPI, employ JavaScript interoperability
(Èçäèñëàâ Èçäèñëàâîâ) This article will demo the usage of Blazor WebAssembly and how to create simple web application with it. The article consists of three parts. In Part 1, we will work with styles. In Part 2, we will call external webAPIs. In Part 3, we will work with JavaScript interoperability.
SQL Server Backup Size vs Database Size Script
(Alejandro Cobar) As SQL Server DBAs, we can all agree that backups are essential and must be managed properly so that we can be able to recover from any disaster scenario. However, there are some cases where having the backup file is simply just not enough because you might not know how much disk s
Becoming Familiar With the Little Known SQL Keyword LATERAL
(Vadim Tkachenko) Working on a weekend project, I became familiar with the SQL keyword “LATERAL”, which I had not used before because it was only introduced recently in MySQL 8.0.14, so I wanted to share how it can be used.
Printing Emoji Characters From Unicode CodePoints In Lucee CFML 5.3.5.92
(Ben Nadel) Now that I’ve enabled Emoji characters in my blog comments (via MySQL’s utf8mb4 character encoding), it’s got me thinking more about how else I might use Emoji in my blog.