Microsoft SQL announcements at PASS Data Community Summit 2024
Read a summary of the data platform announcements from Microsoft at the PASS Data Community Summit 2024 last week.
2024-11-18
939 reads
Articles
Explore Pandas in Python to Analyze and Manipulate Tabular Data
Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.
2024-11-18
The Right and Wrong of T-SQL DML TRIGGERs (SQL Spackle)
Triggers in T-SQL have many uses. There are right and wrong ways to write triggers. To learn the difference, read on...
2024-11-15 (first published: 2015-03-17)
8,839 reads
Making Temporal Databases Work, Part 3: Saving Data
In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.
2024-11-15
Ingesting Data From REST API endpoints: Data Engineering with Fabric
In this article on Fabric we will examine how to get data from a REST API.
2024-11-13
2,785 reads
Relationships with Microsoft Fabric GraphQL API
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
2024-11-13
A Tidy Database is a Fast Database: Why Index Management Matters
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
2024-11-11
3,384 reads
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
2024-11-11
Step by step guide to setup PostgreSQL on Docker
Learn how to get started with PostgreSQL using a container to practice database skills.
2024-11-08
1,494 reads
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform.
2024-11-08
Blogs
Azure SQL offerings
By James Serra
There are three Azure SQL products with so many different deployment options, service tiers,...
T-SQL Tuesday #183 Roundup
By Steve Jones
I hosted this month’s T-SQL Tuesday party with my invitation asking about tracking permissions....
A Little Brainstorming with an AI
By Steve Jones
I was asked to do some a little thinking and brainstorming recently. Rather than...
Forums
MEMORYBROKER_FOR_RESERVE experience
Hi, Does anyone have experience with MEMORYBROKER_FOR_RESERVE ? when suddenly there is somehow constantly...
Moving Database Files
I just learned that my database was created on my C:\ drive in the...
Migrate MSSQL to MYSQL - Different Servers
I am needing to migrate a MSSQL db to MySQL, on a different server...
Question of the Day
Mixed Backups
I have a complex database with a few filegroups and files. Can I run a backup command like this? (assume file/filegroup names are valid).
BACKUP DATABASE [complex]
FILE = N'thirdone'
, FILE = N'thirdtwo'
, FILEGROUP = N'second'
TO DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL16.SQL2022\MSSQL\Backup\complex.bak'
WITH NOFORMAT, NOINIT, NAME = N'complex-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
See possible answers