Oracle

Calling all Oracle Database users

  • Article

We’re excited to announce that Redgate is doubling its efforts on Oracle and committed to aligning its DevOps solution across both SQL Server and Oracle. Please take a few minutes to complete this short survey to stay up-to-date on our Oracle developments.

2019-03-11

2,174 reads

Steps to Migrate Oracle Database to Azure SQL Database

  • Article

In the world of paradigm shifts, many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business for the future. On other hand, a technology or platform may reach the end of its life for other business reasons, like ease of use, increased cost, etc.

2018-08-07

3,088 reads

Unique Records In Oracle

  • Article

Defining unique records in an Oracle table is necessary for employee data, and manufacturing part numbers and user names, to name a couple of examples. David Fitzjarrell looks at the various ways uniqueness can be defined, and which method may not be acceptable to third-party applications.

2016-02-26

386 reads

Blogs

Query Store stores dates as UTC

By

One of the powerful aspects of Query Store is the ability to directly query...

SpeedPASS Printing

By

Based on the great post and script from Wayne Sheffield I decided to try...

Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store

By

An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting...

Read the latest Blogs

Forums

Multiple tables created in CDC

By DBA_007

Hello Team, I have enabled CDC for a particular database in SqlServer and enabled...

2 core machine with 4 Tempdb files

By AlphaTangoWhiskey

Just curious if there is a performance hit by having 4 tempdb files with...

User datareader access problem

By jay-h

I went to give a user (via AD account) datareader access to a number...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers