SQL Server and Oracle Create Table Comparison
In this article we look at a comparison of different things you can specify when creating tables in SQL Server and in Oracle.
How do you secure sensitive data in a modern Data Warehouse?
In 2019 Canadian Broadcasting Corporation (CBC) news reported a massive data breach at the Desjardins Group, which is a Canadian financial service cooperative and the largest federation of credit unions in North America. The report indicated, a "malicious" employee copied sensitive personal information collected by Desjardins from their data warehouse. The data breach compromised the […]
Data Types in PostgreSQL: Learning PostgreSQL with Grant
PostgreSQL has an unusually large number of data types. Grant Fritchey reviews each data type and discusses the good and bad points of each.
Summit 2022 Call for Speakers Closes Soon
Time is running out to submit your abstract for our hybrid PASS Data Community Summit 2022 conference! If you're an expert in a data-related topic that you think would be perfect for the Summit 2022 program, we want to hear from you. Whether you're planning to attend in-person or online, all session submissions and speakers will be considered for this year's event. Don't miss your chance to speak at the leading conference for data platform pros, submit your proposal before March 31.
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
Cloud Computing Basics - Achieving High Availability
Learn about high availability in the cloud at a conceptual level.
Easily Repeating Work
There are many ways to work more efficiently, but tracking and saving your work might be one of the best.
Choosing Snowflake vs SQL Server for a Data Warehouse
In this article we take a high level view of choosing to use Snowflake in the cloud versus SQL Server on-premises and some things to consider.
DevOps 101: Getting buy-in across your organization
Implementing DevOps isn’t just a matter of being great at writing code. The key to successful DevOps implementation is gaining buy in across your organization. Join Grant Fritchey live for his tips on how to achieve this.
Blogs
Questions and Answers from Running a Local LLM
By Steve Jones
I had a few random questions from my Running a Local LLM on Your...
Overview of Claude AI Models: Which One to Choose?
By Arun Sirpal
For those entering the AI space whether professionally or personally I wanted to give...
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
Forums
A question about how to store the address in the database
I have an app that has an address field on the customer and the...
SSIS package failing intermittently on last Excel Component
Good Afternoon, I have a Job which "fires" off an SSIS package (that is...
T-SQL in SQL Server 2025: JSON_ARRAYAGG
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Multiple Sequence Values
How do I easily get the next 12 sequence values from a sequence object?
See possible answers