SQL SERVER Management Studio – Rebuild All Indexes on Table

Today, we are going to see a very simple trick about SQL SERVER Management Studio (SSMS), where we will learn how to rebuild all indexes on the table with a single click.

blog.sqlauthority.com

6th Mar 2020

Setting Up a Geo-Location Database Cluster Using MySQL Replication

A single point of failure (SPOF) is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity strategic plans.

severalnines.com

5th Mar 2020

SQL Server Auto Shrink database property

In this article, we will discuss the SQL Server Auto Shrink database property, which allows SQL Server to automatically shrink the database files when the value is configured as True in the database option.

sqlshack.com

5th Mar 2020

How to configure SQL Server Log Shipping

SQL Server Log shipping provides a DR (disaster recovery) solution for the SQL Server databases and it can be configured at the database level. In a specific time-gap, SQL Server Transaction Log backup will be taken and copied to the destination site and will be restored.

sqlshack.com

5th Mar 2020

Deploy MySQL InnoDB Cluster in OCI with Terraform

As you know, Oracle Cloud Infrastructure (aka OCI) becomes more and more popular. You can find OCI data centers almost everywhere and the price is very attractive. Oracle provides a lot of modules to deploy your architecture on OCI using Terraform. Those are called oracle-quickstar repos.

lefred.be

4th Mar 2020

Part 2: N1QL: To Query or To Analyze?

When you need to query documents using SQL, there are two options available in Couchbase. The Query service and the Analytics service. Our blog, N1QL: To Query or To Analyze? provides a detailed overview of both services. I highly recommend reading it before this one.

blog.couchbase.com

4th Mar 2020

5 Query Pushdowns for Distributed SQL and How They Differ from a Traditional RDBMS

A pushdown is an optimization to improve the performance of a SQL query by moving its processing as close to the data as possible.

blog.yugabyte.com

4th Mar 2020

An Overview of DDL Algorithm's in MySQL ( covers MySQL 8)

Database schema change is becoming more frequent than before, Four out of five application updates(Releases) requires a corresponding database change, For a DBA schema change is a more often a repetitive task, it might be a request from the application team for adding or modifying columns in a table

mydbops.wordpress.com

4th Mar 2020

How to use database backups to recover data after SQL Delete and SQL Truncate statements

This article explores the recovery of data removed by SQL Delete and SQL Truncate statements using SQL database backups. Before you go further with this article, go through the following articles to understand how delete and truncate statements work in detail.

sqlshack.com

4th Mar 2020

Developing PostgreSQL for Windows, Part 2

In the previous blog post, we discussed the different Windows build variants that PostgreSQL supports. In this post, we’ll discuss how, as a Unix-based developer, you can check whether your patch might work on Windows. (For simplicity, I’ll say “Unix” to mean Linux, BSD, macOS, and similar.

postgr.es

4th Mar 2020

Reduce WAL by increasing checkpoint distance

If you are running PostgreSQL in production you might have already noticed that adjusting checkpoints can be a very beneficial thing to tune the server and to improve database performance overall.

cybertec-postgresql.com

3rd Mar 2020

How to install SQL Server 2019 on Windows Server 2019. Lab @ Home.

In a previous post, we learned about installing Db2. Now I'm installing SQL Server. Therefore, I've downloaded Windows 2019 Standard (Evaluation) from this link. (Evaluation 180 days).

blog.dbplatz.com

3rd Mar 2020

Dirty Deeds Done in SQL

Yes, I wrote a loop to find a gap in an identity-value sequence. Sue me. (Or don’t, that’d be cool too.) I’ve done some things I’m not proud of.

natethedba.com

3rd Mar 2020

A Brief History of Securing the Hybrid Cloud

More and more organizations are getting on board with infrastructure as a service and the hybrid cloud and it looks like that trend is only accelerating this year.

cyberark.com

3rd Mar 2020

Celebrating Kube-ArangoDB’s 1.0 Release!

Kube-ArangoDB, ArangoDB’s Kubernetes Operator first released two years ago and as of today is operating many ArangoDB production clusters (including ArangoDB’s Managed Service Oasis). With many exciting features we felt kube-arango really deserves to be released as 1.0.

arangodb.com

3rd Mar 2020

Women’s History Month and Being Better

This month is Women’s History Month, and it’s a chance to stop and think about the impact that women have had in history. After reading Monica Rathbun’s post on being a women in the SQL Server community, I wanted to drop a few notes.

sqlservercentral.com

3rd Mar 2020

How to Enable TimescaleDB on an Existing PostgreSQL Database

If you have a PostgreSQL cluster up-and-running, and you need to handle data that changes with time (like metrics collected from a system) you should consider using a time-series database that is designed to store this kind of data.

severalnines.com

3rd Mar 2020

Overview of the T-SQL If Exists statement in a SQL Server database

This article walks through different versions of the T-SQL IF EXISTS statement for the SQL database using various examples. Suppose you want to deploy objects such as tables, procedures, functions in the SQL Server database.

sqlshack.com

3rd Mar 2020

Performance Best Practices: Hardware and OS Configuration

Welcome to the sixth in a series of blog posts covering performance best practices for MongoDB. If you are running MongoDB on Atlas, our fully-managed and global cloud database service, then many of the considerations in this section are taken care of for you.

mongodb.com

3rd Mar 2020

How does SQL Server Management Studio get its data

Have you ever wondered where SQL Server Management Studio (SSMS) gets its information from and how you can retrieve the same data without using SSMS? Well it's not a big secret.

mssqltips.com

3rd Mar 2020

How to Rebuild an Inconsistent PostgreSQL Slave

PostgreSQL Streaming Replication is a great way of scaling PostgreSQL clusters and doing it adds high availability to them.

severalnines.com

2nd Mar 2020

Translating a SQL Server Schema into a Cassandra Table: Part II Integrity Constraints

Complex integrity constraints are more challenging to enforce in Cassandra than they are in a relational database. In this article, Shel Burkow walks through four modelling examples in Cassandra involving constraints.

red-gate.com

2nd Mar 2020

SQL Server Replication Interview Questions & Answers

In this article, we will discuss a number of interview questions that cover the SQL Server Replication concept, components, types, and troubleshooting scenarios.

sqlshack.com

2nd Mar 2020

INSERT INTO Yugabyte (We’re Hiring!)

If you’re looking to turn your passion for Yugabyte into your profession, then we have great news for you! Yugabyte is currently looking for talented people to join our team and help us keep the momentum going.

blog.yugabyte.com

2nd Mar 2020

Setting 2020 Learning Goals

I deliberately didn’t set any goals at the start of 2020 since I was taking six weeks off for a sabbatical. That’s done, and it’s time to look forward. I know I have a few things that will be important for work.

sqlservercentral.com

2nd Mar 2020

SQL Database MI benefits

As I see a huge number of customers migrating their on-prem databases to the Azure cloud, the main question they ask is about whether they should go with an IaaS solution (SQL Server in a VM) or a PaaS solution (SQL Database).

sqlservercentral.com

2nd Mar 2020

Altering an indexed view in SQL Server drops all indexes

I learned an interesting thing about ALTER VIEW behavior in SQL Server when applied to indexed views.

littlekendra.com

2nd Mar 2020

The Future of the Intelligent Application: Why Graph Technology Is Key

Data, AI, intelligent applications. They’re no longer separate topics, or even separate conferences. O’Reilly announced that it is merging its data and AI conferences, saying, “Data feeds AI; AI makes sense of data.” Further, both power applications.

neo4j.com

First 167 168 169 170 Last