Storage Tiers What SQL Server DBAs Need to Know

“One Gerbil, Two Gerbils or Three Gerbils?” is a common DBA joke about server and storage performance. No matter how many gerbils power your storage, you need to know what type they are and the power that they provide. Storage is not about gerbils it is about IOPs, bandwidth, latency, and tiers.

sqlespresso.com

19th Jan 2021

The MySQL Clone Wars: Plugin vs. Percona XtraBackup

Large replication topologies are quite common nowadays, and this kind of architecture often requires a quick method to rebuild a replica from another server. The Clone Plugin, available since MySQL 8.0.17, is a great feature that allows cloning databases out of the box.

percona.com

19th Jan 2021

Azure Cloud Shell–Do You Use It?

One of the challenges of being a consultant is having to work with a number of clients, and having different login credentials and accounts.

joeydantoni.com

19th Jan 2021

SQL Server temporal tables and JSON columns: Entity Framework Core 6.0 plans laid bare

It’s the season of planning the year ahead, so with 11 months to go until the next release, the team behind Microsoft’s object-database mapper, Entity Framework Core, got busy sketching out version 6.0 of the project.

devclass.com

19th Jan 2021

Indexed Views As Filtered Indexes

But there’s an interoperability issue when you try to use things together. You can’t create a filtered index with the filter definition on a computed column, nor can you create a filtered index on an indexed view.

erikdarlingdata.com

19th Jan 2021

Imposter Syndrome and Public Speaking: 5 Tips for a Successful Tech Talk

I've done hundreds of presentations at large and small events. I’ve delivered keynotes in front of a thousand people. You probably think I enter the stage each time with full confidence that I’ll give a solid and engaging presentation. You’re wrong.

mongodb.com

19th Jan 2021

Export Amazon Aurora MySQL or Amazon RDS snapshots to AWS S3 buckets

Amazon RDS is a relational managed database service for Microsoft SQL Server, MySQL, PostgreSQL, Oracle and Aurora (MySQL & PostgreSQL compatibility). AWS automatically takes regular database snapshots and stores them into the S3 bucket.

sqlshack.com

19th Jan 2021

Performance of sys.partitions

sys.partitions appears to be a UNION ALL of two result sets (row store and columnstore) and most of my queries are resulting in two scans of sysrowsets. Is there any filter I can put on a query of sys.

sqlperformance.com

19th Jan 2021

Building a knowledge graph in Amazon Neptune using Amazon Comprehend Events

Organizations that need to keep track of financial events, such as mergers and acquisitions or bankruptcy or leadership change announcements, do so by analyzing multiple documents, news articles, SEC filings, or press releases.

aws.amazon.com

19th Jan 2021

MySQL in Azure

Cloud computing is becoming more and more famous among the IT circles and it is growing super fast. Industries are charmed by its flexible character and the avoidance of having their own infrastructure.

dasini.net

19th Jan 2021

Have you tried the Quick Scan Report?

Have you tried out Database Health Monitor and the Quick Scan report? The Quick Scan report does a quick check (sometimes not so quick depending on the system). It checks for server best practice recommendations, and security and performance recommendations as suggested by Database Health Monitor.

stevestedman.com

19th Jan 2021

Install VMware Workstation 14 on Windows

If you want to setup a lab for testing or development you can create virtual machines with the help of VMware Workstation software. You don’t need to procure additional hardware to setup test/dev machines, this can all be done with virtual machines.

mssqltips.com

19th Jan 2021

GridDB fdw 1.3 released

We have just released version 1.3 of the Foreign Data Wrapper for GridDB. This release can work with PostgreSQL 9.6, 10, 11, 12 and 13. This release supports following features :

postgresql.org

19th Jan 2021

SQL SERVER – Two Advantages of Sort in TempDB Options

Just another day a client of Comprehensive Database Performance Health Check asked me why I suggest enabling Sort in TempDB Options for creating and rebuilding indexes. Let us discover two advantages of the SORT_IN_TEMPDB Option.

blog.sqlauthority.com

19th Jan 2021

Ten Reasons your SQL Server Monitoring will Scale

This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers.

red-gate.com

18th Jan 2021

The Curious Case of… the failing differential restore

Stepping away from SQLintersection Over the last year, after we were forced to move our Immersion Events online, we’ve realized the power and flexibility of online training and we Explore Spring 2021 classes, recorded classes, blackbelts, and discounts! Our classes are all open for registration

sqlskills.com

18th Jan 2021

When do Statistics get updated?

Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts of a given query and to allow the SQL Optimiser to form efficient execution plans to delivery those query results.

matthewmcgiffen.com

18th Jan 2021

Renaming Files by Padding Numbers with PowerShell

Some time ago I had downloaded all the SQL Saturday XML files. I’ve been meaning to flatten those into a database, but that project keeps getting away from me. And now it’s become an archive task. In any case, I’ve been looking to work with Jekyll and get a list of events.

voiceofthedba.com

18th Jan 2021

Scylla Open Source Release 4.3

The Scylla team is pleased to announce the release of Scylla Open Source 4.3, a production-ready release of our open source NoSQL database. Scylla is an open source, NoSQL database with superior performance and consistently low latencies. Find the Scylla Open Source 4.

scylladb.com

18th Jan 2021

Supplemental Defect

Here’s an anomaly that appeared in a question on the ODC recently about tweaking the output of dbms_metadata.

jonathanlewis.wordpress.com

18th Jan 2021

January 18 | MVCC in PostgreSQL — 6. Vacuum

We started with problems related to isolation, made a digression about low-level data structure, then discussed row versions and observed how data snapshots are obtained from row versions.

postgrespro.com

18th Jan 2021

Challenges of Scaling the Moodle PostgreSQL Database

Moodle is the most popular Learning Management System (LMS) allowing educators to create their own website with courses or content that extend learning.

severalnines.com

18th Jan 2021

Normalizing To Reduce Blocking

I see a lot of tables that look something like this: CREATE TABLE dbo.orders ( order_id int NOT NULL PRIMARY KEY DEFAULT (NEXT VALUE FOR dbo.

erikdarlingdata.com

18th Jan 2021

Enabling low code graph data apps with Amazon Neptune and Graphistry

One of the common challenges to unlocking the value of graph databases is building easy-to-use, customer-facing data tools that expose graph-powered insights in impactful and visual ways.

aws.amazon.com

18th Jan 2021

Migrating user-defined types from Oracle to PostgreSQL

Migrating from commercial databases to open source is a multistage process with different technologies, starting from assessment, data migration, data validation, and cutover. One of the key aspects for any heterogenous database migration is data type conversion.

aws.amazon.com

18th Jan 2021

The MySQL 8.0.23 Maintenance Release is Generally Available

The MySQL Development team is very happy to announce that MySQL 8.0.23 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.23 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.

mysqlserverteam.com

18th Jan 2021

Creating Azure Synapse Analytics Workspaces

This article will help you understand the process to create an Azure Synapse Analytics workspace and some other features related to it.

sqlshack.com

18th Jan 2021

Gitflow Workflow Hotfix Branching for SQL Database Projects

As a database developer, Git is a great tool for source control. In this tip we look at how you can utilize Git source control to build and deploy database hotfixes. Using the Gitflow Workflow Hotfix Branching model with a SQL Database Project we can meet any database hotfix related requirements.

mssqltips.com

First 2 3 4 5 Last