GitHub

series-generate-function-series-data-c810103.md

The <min_value> parameter for the numeric versions of this function does not need to be aligned to numeric zero with respect to the <increment_by> value. You can specify a source increment of 2 and a ...
Hacker

This Dev Hacked EF Core Just to Make SQL LIKE Work in .NET 8 — And It Actually Does

M.Sc. C.S. University of Belgrade, Serbia; MCSA – Microsoft Certified Solutions Associate (C#, ASP.NET MVC); CodeProject MVP (x2 years); C#-Corner MVP (x3 years ...
GitHub

v_generate_user_grant_revoke_ddl.sql

Steps to revoking grants before dropping a user: 1. Find all grants by granted by user to drop and regrant them as another user (superuser preferably). select regexp_replace(ddl,grantor,'<superuser>') ...
Redmond Magazine

SQL Server 2022 Release Candidate 0 Now Available

Microsoft last week announced the release of SQL Server 2022 Release Candidate (RC) 0. The RC 0 designation is old Microsoft phraseology. It used to mean that the software bits were feature complete ...
Visual Studio Magazine

Deleting all Data from a SQL Server Database (Part 2)

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database. In part one of this article, I described a ...