DBplatz
24th Jan 2020

Building SQL Server Indexes in Ascending vs Descending Order

When building indexes often the default options are used to create an index which creates the index in ascending order. This is usually the most logical way of creating an index, so the newest data or smallest value is at the top and the oldest or biggest value is at the end.

23rd Jan 2020

Break barriers in the data maturity curve with IBM Cloud Pak for Data and MongoDB

Data is everywhere, but using data to build modern applications that create business value is far from easy. That’s why IBM Cloud Pak for Data teamed up with MongoDB to accelerate the process from ingestion to insight.

23rd Jan 2020

MariaDB Day Brussels 0202 2020 Provisional Schedule

MariaDB Day is a complementary event to MySQL, MariaDB and Friends, giving an opportunity to more speakers and for more in-depth MariaDB coverage. Attendance is free, but space is limited, so please RSVP on the Meetup page if you plan to attend.

23rd Jan 2020

Making Sense of Group Replication Consistency Levels

From the initial release, one of the biggest complaints I had about Group Replication is that it allowed “stale” reads and there was no way to prevent them or to even know that you read “stale” data. That was a huge limitation.

23rd Jan 2020

Cool Query Hints

Yeah, I surf in dark mode. I’m a dark kinda guy. But wait – what’s that colored box? ENHANCE! I could make jokes here, but … every single thing in that caution is true. SQL Server really does typically select the best execution plan for a query, like 99.

23rd Jan 2020

Deleting Lost Transactions in MS SQL Server

In this article, take a look at a tutorial that explains deleting lost transactions in MS SQL Server. Introduction Quite often, transactions in MS SQL Server are lost by those who launched them.

23rd Jan 2020

An overview of the SQL cursor @@FETCH_STATUS function

SQL cursor is one of the most popular database objects. It is used to retrieve data from the result set of an SQL query one row at a time. Even if the cursor is not recommended from a performance perspective, they are still widely used especially when handling a small amount of data.

22nd Jan 2020

Machine Learning Predictions in Mobile Apps with Couchbase Lite Predictive Query

Couchbase Lite’s Predictive Query API allows applications to leverage pre-trained, Machine Learning(ML) models to run predictive queries against data in embedded Couchbase Lite database in a convenient, fast and always-available way.

22nd Jan 2020

Auditing in AWS RDS SQL Server

This article explores the server and database audit in AWS RDS SQL Server. Data security is a critical task for any organization. We should only provide data access to authorized persons. Our main aim is to protect any data while in rest or data in transit.

22nd Jan 2020

Ever Heard of Postgres?

Hello! My name is Robert and I am a PostgreSQL Consultant at Percona. I’ve been here since the summer of 2019 but things have been so busy that this is the first chance I’ve had to write. For my first blog, I’d like to write about … you.

22nd Jan 2020

Managing SQL Server Docker containers in macOS

In the second article of this series, Carlos Robles explains how to manage Docker images and containers.

22nd Jan 2020

Learn SQL: SQL Script

I can hardly imagine making any complex database changes without using SQL scripts. We actually used them in this series so far, but we haven’t pointed out what they actually are. Today we’ll stand up against that injustice. Sit back, relax, and get ready to learn something new and useful.

22nd Jan 2020

Database Mail configuration in SQL Server Express edition

In this article, I am going to explain step by step process to perform Database Mail configuration in SQL Server Express edition using the T-SQL script.

22nd Jan 2020

How to Create an Ubuntu PowerShell Development Environment – Part 1

Since SQL Server now runs in Linux, more database professionals will begin to learn this operating system. In this article, Robert Cain demonstrates how to set up an Ubuntu virtual machine for learning. Microsoft has made great effort over the last few years toward multi-platform compatibility.

22nd Jan 2020

Deploying the Percona Kubernetes Operator for XtraDB Cluster in Amazon (AWS)

Being that Amazon is one of the most-used cloud vendors, it is only natural that one may ask “How can Kubernetes be used in AWS?“. And the answer is – not that different than with other cloud vendors.

22nd Jan 2020

Relational vs NoSQL and RDBMS to NoSQL Migration

In this article, see a comparison of relational and NoSQL databases and also look at RDBMS to NoSQL migration options. Overview Given the choice of a Relational Database (RDBMS) vs a NoSQL database, it has become more important to select the right type of database for storing data.

22nd Jan 2020

A minor office reorg – part 1

Moving to Wayfair meant spending a lot more time in my home office compared to commuting to an office in South Charlotte. When we moved from Rhode Island, I brought a whole slew of desks I had in my home office there. They are Bush Series A in beech top / slate base, and they are tanks.

22nd Jan 2020

Beware of Unstable Query Digests in MySQL

If you’re using MySQL’s Performance Schema you may use “query digests” as IDs to identify specific query patterns in the events_statements_summary_by_digest Performance Schema Table.

22nd Jan 2020

Types of SQL Server Indexes

Query Performance. This is the area within database administration that I find most interesting and challenging. Taking a query and making it run faster than it did before or use fewer resources to complete always gives me a sense of accomplishment.

22nd Jan 2020

Configuring SQL Server Express edition as SQL witness server in Database Mirroring

In this article, I am going to explain how we can use the SQL Server Express edition for the SQL witness server of the database mirroring setup. Database mirroring is a cost-effective and easy to configure high availability solution.

22nd Jan 2020

Running Database Console Commands (DBCCs) on Azure SQL Database

Practically every SQL Server Database Administrator operating in an on-premises environment is familiar with Transact-SQL DBCC statements that serve the role of Database Console Commands.

22nd Jan 2020

Building SQL ConstantCare: Let’s Tune an Index in Postgres.

This week, our SQL ConstantCare® back end services started having some query timeout issues.

22nd Jan 2020

SQLintersection Spring 2020 coming up fast!

As we head towards our SQLintersection Spring 2020 in April (our 15th show!), I’m excited to say that it’s once again our most diverse, complete, and information-packed show yet!

22nd Jan 2020

Database Compatibility Level and Query Store

A question I’ve gotten a few times when teaching relates to database compatibility level and Query Store. I was talking to a client yesterday about post-upgrade plans and implementing Query Store, and the topic came again.

21st Jan 2020

SQL RDBMS Basics: What is a Commit? – DataGeek.blog

This post is cross-platform and applies to all RDBMSes. It is interesting to see, as a person experienced with a technical tool, some of the disadvantages of the newer ways of learning technical topics.

SQL SERVER – SQL Server Agent Missing in SQL Server Configuration Manager

If you search on the internet, you will find various combinations of missing services. One of the common situations is to have ALL SQL related services missing from SQL Server Configuration Manager.

Controlling who commits code to a given database schema in Git with Azure DevOps

One of most the fun things about working as an Advocate at Redgate is getting to help clients determine their preferred workflow for database DevOps.

Upgrading MySQL InnoDB Cluster Metadata

As on every release MySQL Shell 8.0.19 includes several bug fixes as well as new features.

First 179 180 181 182 Last
  • About
  • Blog
  • Privacy Policy
Contact Us Twitter Instagram
2020 © DBplatz