An Effective Approach for High Volume Data in Azure Synapse
Introduction Azure Synapse Analytics, previously known as Azure SQL Data Warehouse, is a widely utilized platform for storing large volumes of data, thanks to its Massively Parallel Processing (MPP) architecture. This article aims to provide a practica …
SSMS Export to Excel
The post SSMS Export to Excel appeared first on SQLServerCentral.
Dark Mode in SSMS 21 and overall first impressions
Let me cut to the chase. If you are like me, you may have been searching for: How to turn on Dark Mode in SSMS V21. Searching for that very thing today inspired me to write this blog to help others do the same thing because I couldn’t seem to fin …
Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and migrations. When we talk about management in these frameworks, we’re referring to the practices that developers use to effi …
JSON in Microsoft SQL Server: A Comprehensive Guide
Introduction JSON (JavaScript Object Notation) has become a popular data format for storing and exchanging information. Microsoft SQL Server, starting from version 2016, introduced built-in support for JSON, allowing developers to work with JSON data m …
How to rename a SQL Server database
The post How to rename a SQL Server database appeared first on SQLServerCentral.
Accessibility, and the Need for Ingenious Simplicity in Computer Scripts, Languages and Programs
I’m very keen on accessibility in computer systems. Nowadays we tend to take a rather superior attitude to this problem, often assuming that the general public need only have an easy way of buying things. My old boss always felt that the only really im …
[Video] Office Hours and an AI-Generated Sweatshirt
I originally took these questions from https://pollgab.com/room/brento poolside at the Trixie Motel (really), but I forgot to use the good microphone, so I re-recorded ’em from my home studio when I got back: Here’s what we covered: 01:04 N …
SQL Endpoint Secrets you need to know
Recently I had a severe problem with SQL endpoints and I was required to build a quick workaround for this. The problem brought to light details we don’t know about SQL Endpoints and the care we need to have. SQL Endpoint has a Cache The SQL Endp …
Index Rebuilds Make Even Less Sense with ADR & RCSI.
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works. Without ADR, when you update a row, SQL Server copies the old values into the transaction log and updates …
Creating a Linked Server in Amazon RDS for SQL Server: A Step-by-Step Guide
A common requirement for database professionals working with SQL Server is the capability to connect seamlessly to other servers or databases. Amazon RDS for SQL Server facilitates this through the support of Linked Servers, allowing users to connect t …
A Practical Guide to Using Azure Key Vault in Enterprise Deployments
The post A Practical Guide to Using Azure Key Vault in Enterprise Deployments appeared first on SQLServerCentral.
What If You Need to Index a Lot of Duplicate Data?
Let’s get a little nerdy and look at database internals. Create two tables: one with a million unique values, and one with a million identical values: DROP TABLE IF EXISTS dbo.AllTheSame; DROP TABLE IF EXISTS dbo.AllDifferent; CREATE TABLE dbo.Al …
Creating Time Series Collections in MongoDB
This article is part of Robert Sheldon’s continuing series on Mongo DB. To see all of the items in the series, click here. Throughout this series, I’ve introduced you to different features in MongoDB and provided examples to help demonstrate how the da …
Weekly Blogging
I spent a few weeks away from the office in early January, just like last year, mostly on vacation. Something I started to do last year was to take some of my away-from-office time and do some writing, in particular, editorials for the year. I have to …