PostgreSQL HAVING,LIMIT and FETCH Clauses
Overview In this article, we will cover these PostgreSQL clauses with examples: HAVING, LIMIT and FETCH. In a previous article we discussed the WHERE, ORDER BY and GROUP BY clauses. Click the link if you wish to learn about those clauses. HAVING …
Step by Step Guide to Install Jupyter Notebook
Whether you work as a Data Engineer or a Data Scientist, a Jupyter Notebook is a helpful tool. One of the projects I was working required a comparison of two parquet files. This is mainly a schema comparison, not a data comparison. Though the two .parq …
How to Manage Date Formats in the Power BI Service
The post How to Manage Date Formats in the Power BI Service appeared first on SQLServerCentral.
Win DevOps books with Redgate’s competition
The post Win DevOps books with Redgate’s competition appeared first on SQLServerCentral.
SQL Server T-SQL CASE Statement Examples
The post SQL Server T-SQL CASE Statement Examples appeared first on SQLServerCentral.
Data Saturday #8 – SouthWest US
The post Data Saturday #8 – SouthWest US appeared first on SQLServerCentral.
I’m on the KasperOnBI Podcast Talking About Careers and the Future of SQL Server
I sat down with Microsoft’s Kasper de Jonge this month for an hour-long conversation about how I got started speaking, careers, and the future of SQL Server: You can also listen on Spotify and Apple Podcasts. In the podcast, we talk about my Epic …
Conditional DELETE and INSERT in PostgreSQL
Introduction We are comfortable with inserting/deleting record(s) into/from a table. But we sometimes get confused when we need to insert or delete records conditionally from a table. Let us look at an example. Example scenario Suppose we have a table, …
Automating Azure DevOps with Logic Apps
The post Automating Azure DevOps with Logic Apps appeared first on SQLServerCentral.
Take our survey to win a $500 Amazon gift card
The post Take our survey to win a $500 Amazon gift card appeared first on SQLServerCentral.
Oracle Sequences: RAC
The series so far: Oracle sequences: The basics Oracle sequences: RAC In my first article on Sequences, I reviewed the fundamental reason why Oracle Corp. introduced the mechanism (i.e. synthetic/surrogate keys) and the mechanical threats (cache size a …
Free Video: Deadlocks: Let’s Do One, Understand It, and Fix It
You keep getting warnings and emails about deadlocks, but let’s be honest: you’re not really sure how they happen or what to do about it. In this one-hour session from the SQLBits conference, I will show one, use sp_BlitzLock to analyze it, …
SQL Server Sequence Numbers
The post SQL Server Sequence Numbers appeared first on SQLServerCentral.
Understanding CRUD Operations on Tables with B-tree Indexes, Page-splits, and Fragmentation
Introduction Every DML transaction reads the data before it makes any changes. Not only during a SELECT query, but when you run any DML statement, insert, update, or delete, SQL Server first fetches a bunch of pages into the buffer pool locating the de …
Running Dynamic Code Quality Checks on Flyway Databases: Table Smells
The post Running Dynamic Code Quality Checks on Flyway Databases: Table Smells appeared first on SQLServerCentral.