Vendors/3rd-party Products

SQLServerCentral Article

The Enterprise Roadmap to Reducing Costs (While Increasing Value)

  • Article

Every enterprise is now facing the same challenge: to do more with less in a demanding economic environment. They're expected to release value to customers sooner while at the same time controlling the costs of their infrastructures, retaining skilled staff, and reducing risk. What role does the database play in balancing this challenge? Read on to find out.

2022-12-09

366 reads

External Article

Data Masking in Principle

  • Article

This is the first of two articles to describe the principles and practicalities of masking data in databases. It explains why an organization sometimes needs masked data, the various forms of masked data we can use, the sort of data that needs to be masked, and the potential pitfalls.

2022-12-07

External Article

Using SQL Backup in Development Work

  • Article

For a development team, SQL Backup provides a simple way to restore development or test databases, if required, while minimizing the tedium of the task of taking, managing, and restoring the backups. We can generate the required backup commands in the GUI and then use them to construct a SQL script that backs up all the required databases. We can even use the backup commands in a beforeMigrate SQL callback, in Flyway, to make sure the current version is safely backed up before we run migration.

2022-11-23

External Article

Finding the Version of a Flyway-managed Database Using SQL

  • Article

Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime, using just SQL. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. No more desultory quests, when dealing with support issues, or when bug fixing, to find which database version was running when the bug happened.

2022-10-14

Blogs

Tales From The Field Weekly Wrap Up for the Week of 01-31-2023

By

 Hello Dear Reader!  After a weekend with a lot of activities, it was a...

Creating a Flyway Desktop Shadow Database in PostgreSQL

By

In order to generate migrations, we need to configure Flyway to use a shadow...

Daily Coping 6 Feb 2023

By

Today’s coping tip is to get back in contact with an old friend. This...

Read the latest Blogs

Forums

Future of SQL Server DBA Role

By Feivel

I would like to know what certifications or paths to choose in order to...

Extended Events shows each SQL command in one long line

By SQL Guy 1

Hi all, I created Extended Events session to capture sql_batch_completed for duration>5 sec sending...

Group by issue

By pedroccamara

Hello everyone!! I have this SQL statement: SELECT dateadd(year,(2023 - year(DH.DOC_DATE)),DH.DOC_DATE) AS 'Date', DD.STORE_CODE...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers