New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT
The post New functions in SQL Server 2022 – LEFT_SHIFT and RIGHT_SHIFT appeared first on SQLServerCentral.
The Basics of PostgreSQL Views
Article Overview This article will help you to understand what is a database view in general and in turn what is a PostgreSQL view. This article will help you to learn how to create/query/drop a PostgreSQL view, their syntaxes with working examples, an …
What are the biggest challenges organizations face in their digital transformation efforts?
The post What are the biggest challenges organizations face in their digital transformation efforts? appeared first on SQLServerCentral.
SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types
The post SQL Server .WRITE() Function to Update VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX) Data Types appeared first on SQLServerCentral.
Slow Startup, Failover, and Restore Times with In-Memory OLTP
When In-Memory OLTP came out, I worked with it briefly, and I remember coming away thinking, “Who in their right mind would actually use this?” I was so horrified that I wrote a presentation about it and gave it at a couple of conferences: …
The SELECT Statement in Oracle
The SELECT statement is used to retrieve information from a database. Following the execution of a SELECT statement, a tabular result is held in a result table (called a result set). It allows you to select the table columns depending on a set of crite …
Recording What’s Changed when Running Oracle Migrations with Flyway
The post Recording What’s Changed when Running Oracle Migrations with Flyway appeared first on SQLServerCentral.
[Video] Office Hours at Sea: Heading to Jamaica
I’m on a boat! I’m on a 10-day Panama Canal cruise, and I stopped (well, not the boat) off the coast of Florida to answer questions y’all posted at https://pollgab.com/room/brento. 00:00 Start 00:56 DBe: In several places I’ve w …
Are PostgreSQL memory parameters magic?
Configuration parameters are the most mythical creatures in the world of PostgreSQL. Ordinary PostgreSQL users often do not know that PostgreSQL configuration parameters exist, let alone what they are and what they mean. There is a good reason for such …
Better Keep Up: More Free PowerShell Videos This Week.
We’re almost halfway through the month. How’s it coming? You keeping up? Or are you having a tough time because your work schedule is so busy and you can’t make 30 minutes of free time? Hey, maybe that’s because you’re a p …
How to Install the AdventureWorks Sample Database in Azure SQL Database
The post How to Install the AdventureWorks Sample Database in Azure SQL Database appeared first on SQLServerCentral.
Find Invalid Objects in SQL Server
One of the most important responsibilities of any database administrator is to maintain the integrity of the database, schema, and data stored in the underlying tables of any database. This article will teach us how to identify invalid or broken object …
On-Demand Webinar – Monitoring: The ROI of Build vs. Buy
The post On-Demand Webinar – Monitoring: The ROI of Build vs. Buy appeared first on SQLServerCentral.
How to Implement CI/CD in Azure Data Factory (ADF)
Continuous Integration and Continuous Deployment (CI/CD) are integral parts of the software development lifecycle. As a Data Engineer/ Data Professional when we build the ETL pipeline using Azure Data Factory (ADF), we need to move our code from a Deve …
SELECT DISTINCT SQL Command to Return a Unique List of Values
The post SELECT DISTINCT SQL Command to Return a Unique List of Values appeared first on SQLServerCentral.