Bard, Google’s ChatGPT Competitor
See how the Google AI, Bard, works and answers questions about data topics.
2023-07-03
3,749 reads
Articles
Six Things to Monitor with PostgreSQL
To get the most out of your PostgreSQL database, find out the six performance metrics that ought to be central to your PostgreSQL monitoring strategy.
2023-07-03
SQL Server Database Backup and Restore Failure Notifications
My SQL Server backups and restores fail infrequently, but when I find out it is too late. How can I find out sooner?
2023-07-03
Unpivot Data Using Python
This article looks at manipulating data using Python to unpivot data received in a cross tab format.
2023-06-30
3,416 reads
Searching Flyway Migration Files using Grep and Regex
This article demonstrates a cross-RDBMS way of searching through a set of SQL migration files, in the right order, to get a narrative summary of what changes were made, or will be made, to one or more of the tables or routines within each migration file. Getting these summary reports, even from a set of SQL migrations, isn't difficult, but having a few examples makes it a lot quicker to get started.
2023-06-30
Understanding Power BI Security Options - Row-Level, Column-Level and Object-Level Security
Microsoft Power BI is an interactive data visualization tool primarily designed with business intelligence in mind. Apart from being a visualization tool, it also has some built-in security features that we will discuss in this article.
2023-06-30
How to Reduce the Need for Bookmarks Using Parameters in Power BI
Learn how to implement parameters in Power BI.
2023-06-28
3,735 reads
First speakers announced for Summit 2023
Your first speakers in the lineup for PASS Data Community Summit 2023 have been announced! Check out the full details for this year's Pre-Cons and Learning Pathways, and find out why some of our speakers are particularly excited for what’s in store this year.
2023-06-28
Paging Data in T-SQL
This article will show you how to page through a set of results using the OFFSET and FETCH options of the ORDER BY clause.
2023-06-28
SQL Server Resumable Index Operations
The ability to pause and then resume index rebuilds has been added to SQL Server. This is a fantastic feature, and with the release of SQL Server 2019, we can now replicate it on the actual create index process. Learn how to use this feature in this short article.
2023-06-26
13,230 reads
Blogs
Microsoft Purview data governance best practices
By James Serra
Microsoft Purview can be the best data governance tool in the world, but it...
Crash-Consistent MongoDB Snapshot and Restore with Everpure Fusion
I’ve been working on a project that combines two things I spend a lot...
AI and Data Engineering on the Edge: The Good, the Bad, and the Overhyped
Running AI and data pipelines on the edge instead of the cloud has gone...
Forums
Replacing Maintenance tasks now using SSMS 22 - what to do with File operations
Unfortunately I'm using SSMS 22. It didn't come with maintenance plans by default. I...
Secure Cached Plans
Comments posted to this topic are about the item Secure Cached Plans
Complex Data Processing with dbt Python Models: The Fabric Modern Data Platform
Comments posted to this topic are about the item Complex Data Processing with dbt...
Question of the Day
Secure Cached Plans
The DMV, sys.dm_exec_cached_plans, contains rows for each cached plan on an instance. In Azure SQL Database, not every used has rights to every database, as there does exist an instance behind each database. How is security handled for this DMV in Azure?
See possible answers