A Guide to INSERT, UPDATE, and DELETE Statements in Oracle
In this article, we’ll be focusing on three of the most used SQL commands in Oracle: INSERT, UPDATE, and DELETE. These commands are used to insert new data into tables, update existing data, and delete data from tables, respectively. In this arti …
Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders
The post Overcoming Organization Challenges in Cloud Migration: A Webinar for Senior IT Leaders appeared first on SQLServerCentral.
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.
[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 …