PracticalSQLDba

Stellar Toolkit for MS SQL - Software Review

As a SQL database administrator, I am responsible for maintaining our organization's SQL Server and databases. But despite implementing best database maintenance practices, including backups and performing DBCC CHECKDB...

2021-03-11 (first published: )

653 reads

Blogs

Executing One Line in VSCode–#SQLNewBlogger

By

I wrote about arrays in PowerShell last week, but I realized one of the...

Friday Flyway Tips–Comparison Options

By

Recently a customer asked how they could get index changes to be captured in...

A New Word: Guiltwrights

By

giltwrights  – n. the imaginary committee of elders that keeps a running log of...

Read the latest Blogs

Forums

Lake Database Performance Optimization

By kobinarashid

I recently created a synapse link for Dataverse. The resultant Lake Database in Synapse...

Selecting from a view, base table has a DENY on a column

By pveilleux

This is something I've never seen before and I can't think of the right...

JSON data with Pivoted

By Tava

Hi All, I need some assistance and not sure how to achieve the expected...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers