PostgreSQL Date And Time Part 1
This article shows the basics of using the age, and current date/time functions in PostgreSQL.
2021-08-09
2,459 reads
Articles
Top Reasons to Attend PASS Data Community Summit
With over 160+ educational sessions, networking events, speaker Q&As with leading data platform experts, Learning Pathways, and much more, there are so many reasons to attend this year's free and on-demand PASS Data Community Summit. Check out our new video to get a taste of what's in store!
2021-08-09
Understanding Hybrid Buffer Pool in SQL Server 2019
In this article we look at the Hybrid Buffer Pool available in SQL Server 2019 and how to enable and disable this feature for SQL Server.
2021-08-09
SQL Features Explorer
Working as a DBA or developer, one needs to check from time to time about the availability of a particular feature on different SQL Server versions and editions. Hence to avoid the complexity of the search process we have developed a tool that helps DBAs and developers to verify the selected features' availability on all […]
2021-08-06
5,736 reads
Managing, Editing and Comparing SQL Code Analysis Settings
If you need to manage multiple code analysis settings files, per team or database, you'll want a good way to document and manage the files, and to compare two files to see what changed.
2021-08-06
SQL Server High Availability and Disaster Recovery Plan
Microsoft provides quite a few features for high availability and disaster recovery. In this article, Priya describes the HA/DR options.
2021-08-06
Merge Multiple Files in Azure Data Factory
A short tutorial on how to combine multiple files together in an Azure Data Factory Copy Data activity.
2021-08-04
27,826 reads
Typical uses of Oracle sequences
Oracle sequences supply unique numbers that can be used when populating tables. In this article, Jonathan Lewis explains the typical uses of Oracle sequences.
2021-08-04
Using Data Scanning to Identify and Classify Sensitive Columns
SQL Data Catalog's new data scanning feature uses regular expressions and data dictionaries to identify where sensitive and personal data is stored in your databases.
2021-08-04
Working with Azure IoT Central
Gathering data from sensors and Internet of Things (IoT) devices is becoming more and more common in many organizations. This introductory article shows how you can get started with IoT Central in Azure.
2021-08-02
1,854 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers