SQLServerCentral Editorial

Sharing the Work You Do 

During one my yearly review, I got one particularly interesting piece of feedback. “You need to share the work you are doing and share with the company.” This is basically a matter of letting people know about the stuff we are putting out on Simple-Talk.com. It is something that is regularly done here, but to […]

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 […]

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.

Blogs

How to Find Where Your Databases Reside In The File System

By

How to Find Where Your Databases Reside In The File System SQL Script: Copy ...

Understanding and Using xp_sqlagent_enum_jobs in SQL Server

By

Understanding and Using xp_sqlagent_enum_jobs in SQL Server What is xp_sqlagent_enum_jobs? xp_sqlagent_enum_jobs is an undocumented, extended stored procedure...

Darling Data SQL Server Stored Procs in Azure SQL Database

By

Erik Darling, founder of Darling Data, has created these fantastic stored procedures to query...

Read the latest Blogs

Forums

Get rid off master key

By Charmer

Hello everyone, I'm currently working with Visual Studio 2022 and SQL Server 2019 Enterprise...

dtexecui.exe not found

By Charmer

Hi All, I have VS 2022 installed along with SQL server data tools enabled....

How to replace a specific part of string contains value in side whole string

By Zond Sita

Good Morning, CREATE TABLE MyTable (ID int, DATA NVARCHAR(MAX)) INSERT INTO MyTable values (1,...

Visit the forum

Question of the Day

Dacpac Data

Can a .dacpac file created with sqlpackage.exe /extract include data?

See possible answers