(blobeater) As Microsoft states “online clustered columnstore index build enables you to optimize and compress your data with minimal downtime without major blocking operations on the queries that are executing while you are transforming the data.”
Community
Disk Space and SQL Server
(Jason Brimhall) One of the frequently required job functions of the database administrator is to track disk space consumption. Whether this requirement comes from management or from a learning opportunity after a production outage, the need exists.
Creating CRUD Stored Procedures in SQL
(Hannes Du Preez) Create, Read, Update and Delete operations are pivotal for any database application. These DML (Data Manipulation Language) statements can become risky to do, especially if you are new to databases and do not know how these statements work.
5 THINK Conference Dreams, Themes, and Details
(Dave Beulke) As I said before the IBM THINK conference was an interesting event. Having several different presentation venues, picking sessions to attend made planning your day and travel between sessions/venues a challenge.
Updated Choices for Java Updates
(Simon Ritter) Last month was of particular significance to both Java developers and users. The reason was the release of update 202 of Oracle JDK 8, which was the final public update (for commercial users) of JDK 8 from Oracle.
Logging and diagnostics in ASP.NET Core SignalR
(Andrew Stanton-Nurse) This article provides guidance for gathering diagnostics from your ASP.NET Core SignalR app to help troubleshoot issues.
Three Ways To Return Data From ASP.NET Core Web API
(Bipin Joshi) ASP.NET Core allows you to build RESTful services using web API. Typically you want to return data and HTTP status codes from an API controller.
Using The Non-Null Assertion Operator To Fix .shift() and .pop() Errors In TypeScript 3
(Ben Nadel) One of the things that I love most about TypeScript is that it forces me to think more deeply about my code because it is constantly checking the “assumptions” that I make about runtime truths.
Db2 for z/OS: Isolating REST Client Activity in Db2 Monitor Accounting Reports
(Robert Catterall) In an entry posted to this blog some years ago, I described the form of a Db2 monitor-generated accounting report that I most like to use to get an overall view of application activity in a Db2 for z/OS environment: an accounting long report with data ordered by connection type (h
The Lost Art of Right Aligning Code
(K. Scott Allen) When I started working with the Go language using Visual Studio Code a few months ago, the Go extension for VS Code auto-formatted one type definition like so: