How User-Defined Types work in PostgreSQL: a complete guide
I’m sure I’m not alone when I say, sometimes I get sidetracked. In this particular instance, I hadn’t intended to start learning about User-Defined Types (UDT) in PostgreSQL – I just wanted to test a behavior that involved creating a UDT. But, once I started reading, I was hooked. I mean, four distinct UDTs with different behaviors? That’s pretty cool. Let’s get into it.
Configure Extensible Key Management Using Azure Key Vault - Level 3 of the Stairway to TDE
In this third level of the Stairway, we examine how to store your encryption certificate in the Azure Key Vault.
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Stairway to Reliable Database Deployments introduces a progressive approach to managing database changes with clear intent, predictable rollback, and explicit behavioral guarantees. Starting from change design and moving toward execution and coordination in complex environments, the Stairway provides a conceptual framework for deploying database changes safely and consistently, independent of specific tools or automation platforms.
Level 24: Time Intelligence – Dates Functions: The DAX OPENINGBALANCE*() Functions
Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces three similar DAX Time Intelligence functions related to Date: OPENINGBALANCEMONTH(), OPENINGBALANCEQUARTER(). and OPENINGBALANCEYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
Level 27: Time Intelligence – Dates Functions: The DAX “Parallel Period” and “Same Period Last Year” Functions
Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
Removing TDE from a Database: Level 4 of the Stairway to TDE
Learn how to remove TDE from a database and return it to a normal state.
Restore a Backup of a TDE Database to Another Server: Level 2 of the Stairway to TDE
In the second level of the stairway to TDE, we examine how you can restore your databases on another instance after moving the encryption certificate.
Stairway to DAX and Power BI - Level 1: Getting Started with PowerPivot and DAX
Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.
Stairway to DAX and Power BI - Level 10: Function / Iterator Function Pairs: The DAX Product() and ProductX() Functions
As a part of his “Function / Iterator Pairs” mini-series, Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX Product()and ProductX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Product()and ProductX(), respectively, in returning the product of numbers in a column and in returning the product of an expression evaluated for each row in a table.
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers