Articles

SQLServerCentral Article

Django's ORM vs. Raw SQL: When to Use Which

When it comes to building websites, how you work with your database can make a huge difference in how well your site runs. That's especially true if you're using Django, a popular tool for making websites with Python. Django comes with something called an Object-Relational Mapping (ORM) layer, which is a fancy way of saying […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2024-01-26

5,281 reads

External Article

SQL WAITFOR Command to Delay SQL Code Execution

One of the most rarely used commands in SQL is the WAITFOR command. It is one option to invoke a delay in program execution in absentia. Because it is sparsely used, how and where it can be applied when needed is often forgotten. For example, we could use this to mimic a user response or input or perhaps to collect data at certain intervals during the day.

2024-01-26

External Article

Code Visibility: Browsing through Flyway Migration Files

If you can convert a SQL file to HTML, then you can inspect your Flyway migration files in a browser. This is especially useful if your SQL is color-coded with the same conventions as it was in your IDE. It is even better still if your browser can allow you to scan through many files, moving from file to file with a single click. This article will demonstrate how to do this with a few PowerShell scripts.

2024-01-24

External Article

Buy on-demand access for Summit 2023 today

Buy your on-demand ticket today to get access to hundreds of high-quality sessions across all 5 tracks at PASS Data Community Summit 2023. It’s a great way of learning at your leisure if you weren’t able to join us in person last year.

On-demand access is available for non-attendees to purchase for $1295. This will grant you access to all session recordings until November 17, 2024. Click here to buy.

2024-01-19

Blogs

Flyway Tips: More Object History

By

I wrote about Flyway Desktop Object History in a previous tip. This feature has...

Why Ai Agents need an eval framework

By

AgentDBA (the database agent I have been building) has more than 1000 automated tests,...

A New Word: Semaphorism

By

semaphorism – n. a conversational hint that you have something personal to say on...

Read the latest Blogs

Forums

Server-level Roles

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Server-level Roles

Pay for Performance

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Pay for Performance

Tracking Inserted, Updated, and Deleted Rows with SQL Server OUTPUT

By Imran2629

Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...

Visit the forum

Question of the Day

Server-level Roles

In SQL Server 2025, can I alter a fixed server role?

See possible answers