Technical Article

DBA_EverywhereRun

Runs a SQL statement against each database based on a LIKE pattern for the name of the database.Features:* IsLike and IsNotLike parameters let you specify both a matching pattern and an exclusion pattern for the database name.* Script_Only mode generates the script of what the stored proc executes.  Especially useful for DDL statements.* List_Only mode […]

2002-11-14

384 reads

Blogs

Fixing a giant or running a SQL Server project deployment with Temporal tables

By

(2022-Jan-27) When Hogarth, a nine-year-old boy, a character from “The Iron Giant” movie, met a...

Azure Cosmos DB introduction

By

Azure Cosmos DB is the next-generation database that offers the highest performance, availability, and...

Display dates between two input dates using SQL DATEDIFF function in SQL Server

By

SQL Server has a very useful function called DATEDIFF. This function is used to...

Read the latest Blogs

Forums

Create View in stored procedure

By newcomer

Hello, I'm new here and currently learn SQL Server. For my program I try...

Optimize Query

By ktflash

--####################################### --Given Rawdata --####################################### create table #Base (C1 char(1),C2 char(3)) insert into #Base values...

Static data masking is not showing in 18.0 above

By sqlfriend

I read this article trying to understand the feature of data masking in SQL...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers