PostgreSQL Copy
Article Overview In this article, we will discuss the ‘COPY’ functionality of PostgreSQL database which is one of the most important and often used features in practical world. There are two variants of ‘COPY’ statement, copy a database and copy a tabl …
Data Transfer from Snowflake to Azure Blob using Synapse Analytics
The post Data Transfer from Snowflake to Azure Blob using Synapse Analytics appeared first on SQLServerCentral.
30%-off health checks and self-service via credit card – no waiting!
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget approval, just click and go! Once you purchase the health check, you get access to our health check pac …
[Video] Office Hours at Sea: Leaving Juneau
I stopped piloting the ship long enough to answer your top-voted database questions from https://pollgab.com/room/brento. Here’s what we covered: 00:00 Start 00:42 Dirty_Pages: You mentioned recently how much you swear, what is your favorite swea …
Unmasking SQL Server Dynamic Data Masking – Part 2 – Setting up Masking
This is the second part of a series on SQL Server Dynamic Data masking. The first part in the series was a brief introduction to dynamic data masking, including use cases. The focus of this blog will is setting up masking and some base examples. Config …
[Video] Office Hours in Glacier Bay, Alaska
Thankfully, we didn’t hit any icebergs or glacier droppings, so I put my comfiest coat on to answer your top-voted questions from https://pollgab.com/room/brento. Here’s what we discussed: 00:00 Start 01:29 gb DBA: Hi Brent, I have over 200 …
PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones)
The post PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (CT and BST Time Zones) appeared first on SQLServerCentral.
PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones)
The post PostgreSQL 101: Getting started with PostgreSQL for SQL Server Developers (AEST and SGT Time Zones) appeared first on SQLServerCentral.
Analyze Data with a Serverless SQL pool in Azure Synapse Analytics
Introduction Azure Synapse Analytics is a Powerful analytics tools which combines data warehousing and big data analytics together. Azure Synapse provides two types of SQL Pool – Serverless and Dedicated. The dedicated SQL pool is designed for high per …
Power BI Connections Management
Some time between January and now, a new preview feature was included in Power BI Portal. It’s a new Manage Connections and Gateway window, still in preview. We can access this option on the Settings button. In the past, the connections were rela …
AWS Aurora Cut Our Database Costs for SQL ConstantCare® – Again.
In May, Amazon brought out a new Aurora I/O Optimized Serverless instance type. By switching to it, we cut our database costs by 43% overnight, saving us about $1,200 per month. No strings attached. Just lower prices. So what’s the magic? Well, c …
Poll: Are You Going Back to In-Person Events?
Two short yes/no questions about regional & national conferences: var gform;gform||(document.addEventListener(« gform_main_scripts_loaded »,function(){gform.scriptsLoaded=!0}),window.addEventListener(« DOMContentLoaded »,function(){gform.domLoaded=!0}) …
First speakers announced for Summit 2023
The post First speakers announced for Summit 2023 appeared first on SQLServerCentral.
Bing Chatbot vs ChatGPT
Introduction In previous articles, we learned about ChatGPT, and we also learned how to use it to generate T-SQL code. This time we will talk about the Bing Chatbot vs ChatGPT. Also, we will first talk with the Bing Chatbot and show its features and th …
How to Filter a SQL Server Audit with a Predicate
The post How to Filter a SQL Server Audit with a Predicate appeared first on SQLServerCentral.