Using TOP clause in a SELECT statement
This article is part of Greg Larsen’s continuing series on Learning T-SQL. To see all 9 items in the series, click here. TOP Clause Syntax The syntax for the top clause is simple and is shown in Figure 1. TOP (<expression>) [PERCENT] [ WITH TIES …
Schedule Jobs on a Clustered SQL Server
High availability or Always On is achieved in SQL Server using Cluster. Clustering is a logical collection of 2 or more physical servers (nodes) that individually host SQL instances and access the common shared storage. The applications will connect to …
The Database DevOps Transformation
The post The Database DevOps Transformation appeared first on SQLServerCentral.
Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1
The post Privileges and Roles in SQL Server, Oracle and PostgreSQL – Part 1 appeared first on SQLServerCentral.
Power BI Dataset Scale-Out
Power BI has evolved into the leading platform for both self-service and IT-managed enterprise business intelligence. The decision to migrate to Power BI Premium depends on the requirements of each customer. Customers should carefully evaluate addition …
Testing Databases: What’s Required?
The post Testing Databases: What’s Required? appeared first on SQLServerCentral.
Extend your Power BI Reports with Analysis Services 2022 Data
The post Extend your Power BI Reports with Analysis Services 2022 Data appeared first on SQLServerCentral.
Nullable vs Non-Nullable Columns and Adding Not Null Without Downtime in PostgreSQL
In this article, we are going to talk about nullable and non-nullable columns specifically related to Postgres databases. While the reasons to use nullable or non-nullable columns may seem obvious at first, there are pitfalls associated with each decis …
PostgreSQL Constraints: Learning PostgreSQL with Grant
PostgreSQL supports constraints much like any other database management system. When you need to ensure certain behaviors of the data, you can put these constraints to work. I’ve already used several of these in creating my sample database (avail …
[Video] Office Hours: 22 Good Questions and a Stinker
Lots of good questions on today’s broadcast! If you’d like to submit one, go to https://pollgab.com/room/brento and upvote the ones you’d like to see me cover. Here’s what we covered today: 00:00 Start 01:05 Testing123: When ins …
[Video] Office Hours: Quickie Before Dinner
Before heading out to dinner, I went through your highly-upvoted questions from https://pollgab.com/room/brento. Here’s what we covered in this episode: 00:00 Start 00:20 Mert: Hi Brent, what is the relation between AlwaysOn and Windows Failover …
The Data Fabric – Future of Data Management
Data is the new gold and is truly an asset to any enterprise. As predicted by IDC, the size of the world’s data – the Datasphere – will grow from an estimated 85 zettabytes (ZB) by the end of 2022 to 175 ZB by 2025. With the increased volume, velocity, …
Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory
The post Ingesting Data from Google Drive to Azure Data Lake Gen2 using Azure Data Factory appeared first on SQLServerCentral.
Optimizing Queries in MySQL: Optimizing Reads
Office Hours, ChatGPT Edition: AI Answers 4 of Your Questions
In a recent Office Hours post, David Reabow suggested letting ChatGPT answer a few of the questions y’all posted at http://pollgab.com/room/brento/. Brilliant! Let’s see how it does. I purposely cherry-picked the questions that I thought Ch …