database administration

SQLServerCentral Article

Resolving Access Denied Errors During SQL Server Database Attachment

  • Article

Learn how to resolve access denied errors when attaching databases in SQL Server. This guide explores file permission settings, focusing on the differences between Windows and SQL logins, and provides a step-by-step solution to prevent common attachment issues.

5 (1)

You rated this post out of 5. Change rating

2025-01-10

947 reads

SQLServerCentral Article

Creating a Hyperscale Database in Azure Using the Azure Portal

  • Article

One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.

5 (1)

You rated this post out of 5. Change rating

2023-12-22

1,302 reads

SQLServerCentral Article

Different Ways to Populate the List of Tables

  • Article

This article shows how you can query different types of tables, based on certain criteria that may be important to you. A good list of basics for any database administrator that will help you find tables in your database.

5 (1)

You rated this post out of 5. Change rating

2023-10-06

1,634 reads

SQLServerCentral Article

SQL Server Resumable Index Operations

  • Article

The ability to pause and then resume index rebuilds has been added to SQL Server. This is a fantastic feature, and with the release of SQL Server 2019, we can now replicate it on the actual create index process. Learn how to use this feature in this short article.

5 (3)

You rated this post out of 5. Change rating

2023-06-26

9,442 reads

Blogs

Cool AI sites

By

As I researched and wrote my OpenAI and LLMs blogs (see Introduction to OpenAI...

A Quick Test Data Manager Eval with My Database Backup

By

I wrote about getting the Redgate Test Data Manager set up in 10 minutes...

Take over Ownership in Microsoft Fabric

By

When you create an item in Microsoft Fabric (a notebook, a lakehouse, a warehouse,...

Read the latest Blogs

Forums

Why you should avoid Implicit Measures in your Power BI model

By Koen Verbeeck

Comments posted to this topic are about the item Why you should avoid Implicit...

Change all occurances of one field in DB

By water490

Hi everyone I am doing some clean up of my DB.  There is one...

locks in sql database 2019

By yfiguero

please help. Do they know if the use of try and catch for error...

Visit the forum

Question of the Day

Dates and Languages

The string, listopad, translates to a month name in different languages. If I were to run this code, what values are returned?

DECLARE @yourInputDate  NVARCHAR(32) = '28 listopad 2018';

SET LANGUAGE Polish;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Polish];

SET LANGUAGE Croatian;
SELECT CONVERT(DATE, @yourInputDate) AS [SL_Croatian];

SET LANGUAGE English;

See possible answers