(Jack Vamvas) Often organisations have a SQL server security policy dictating the ‘sa’ login is disabled.
Community
The Constant and Constantly Changing Role of the DBA
(Grant Fritchey) I’ve been working in and around data for over 30 years now. My title has changed a number of times and is poised to change again.
What does the User Mapping tab of Login Properties really tell us.
(Kenneth Fisher) In case it’s not clear, we are talking about the Login Properties GUI in SQL Server Management Studio (SSMS).
Improved data availability with pending ALTER COLUMN – a Db2 12 GA feature
(Regina Liu and Paul McWilliams) Db2 12 for z/OS introduced a new capability to alter certain attributes of table columns as pending data definition changes.
How to Debug LINQ queries in C#
(Michael Shpilt) LINQ is one of my favorite features in C#. It just makes the code look nicer. Instead of tedious foreach loops, we got a neat functional syntax that’s easy to write and understand.
Visual Studio tips and tricks
(Mads) Whether you are new or have been using Visual Studio for years, there are a bunch of tips and tricks that can make you more productive.
Considering Index Design When Using A Nullable DateTime Column To Record A Scheduled Action
(Ben Nadel) I had a lot of fun writing yesterday’s post on creating a composite index using ancestral keys in a hierarchical database.
Google App Engine adds Java 11 runtime
(Paul Krill) Google has added Java 11 as a second-generation runtime on App Engine, the fully managed platform-as-a-service on Google Cloud.
Introducing Tungsten Replicator (AMI): The High Performance Replication Engine For MySQL, MariaDB & Percona Server
(Chris Parker) We’re excited to announce the availability on the Amazon Marketplace of the new Tungsten Replicator (AMI).
RMAN Incremental with Block Change Tracking & Demo
(Zahid Anwar) This blog post is part of the “RMAN Back to Basics” series, which can be found here.