SQLServerCentral Article

The DBA Code of Ethics

What code governs how a DBA acts? What is the framework for DBA ethics? There have been numerous articles on what the DBA job entails, the daily tasks and responsibilities. This article looks at the larger picture of principles which a DBA can use..

SQLServerCentral Article

Getting Ready to Replicate

We've asked Andy to put together some articles that tackle replication from a beginner perspective, a tutorial type approach PLUS comments on what you should or should not do. This week he covers the steps needed to set up a server for replication. More images than usual so the page may take a little longer to load, but we think worthwhile so that you can see every step along the way. Let us know what you think.

SQLServerCentral Article

Review of SQL Compare v3

Regular columnist Robert Marda had some extra time so we got him to take a look at the latest upgrade to SQL Compare - for those of you aren't familiar with it, it is a tool that will let you compare two databases to see the differences, then optionally sync one to the other.

Blogs

Extended Events in Azure Data Studio

By

I know I can use extended events (xevents) in Azure SQL DB when in...

Azure Workbooks

By

I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...

SQL Prompt Tips–Using $surroundtext$ in a Snippet

By

A user on the SQL Community Slack was asking about what the $surroundtext$ variable....

Read the latest Blogs

Forums

data security for a data warehouse

By pietlinden

I'm working with someone whose client says "Yes, we have a data warehouse. But...

AI Tools

By plycons

Not quite sure where to post this or how quite to ask as its...

Review of DB Activity

By HeadScratcher

Hi Folks,   I have been tasked with reviewing all the activity on a...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers