Category Archives: Database Administration

Upgrade SQL Server 2016 to Service Pack 1 faced with Exit code (Decimal): -2068380094

I wanted to upgrade the SQL Server 2016 installed on my laptop to service pack 1 last night. But the setup failed with this error:   Final result:                  The patch installer has failed to update the shared features. To determine … Continue reading

Posted in Database Administration, SQL General Information | Tagged , , , ,

Event ID 129 Reset to device, \Device\RaidPort0, was issued on Database Server

Two months ago, one of my clients called me that his DB Server is not responsive. Their Server is a HP DL580 with this specs: CPU: 4 x 12 cores Memory: 256 GB Storage:  2 x Raid 10 (8 x … Continue reading

Posted in Database Administration, SQL General Information | Tagged , , , , ,

[Fixed] SSMS – Create script duplicates the statements for Grant or Deny Column Permissions…

I was reported a bug in Microsoft SQL Server (all versions) that related to generate script for database permissions on August 20, 2013. Steps to Reproduce Open SSMS >> Connect to Server >> In Object Explorer expand a Sample Database … Continue reading

Posted in Database Administration, SQL General Information

SQL SERVER BACKUP Database Permission

When speaking about Permission term in SQL SERVER , It has two parts: Server Permissions Database Permissions And from another point of view, the SQL SERVER ROLE also has two parts: Server-Level Roles Database-Level Roles In fact the Security Model of SQL SERVER is a hierarchical … Continue reading

Posted in Best Practices, Database Administration, SQL General Information, T-SQL Tips & Tricks

BULK INSERT multiple Files in SQL SERVER Express

This post comes from this MSDN Forum question. Because of use SQL SERVER Express, we cannot use Integration Services(SSIS). Therefore, we  have two choices: BULK INSERT OPENROWSET(BULK…) In each statement you can insert only one column with above choices. Erland Sommarskog was … Continue reading

Posted in Database Administration, SQL General Information, T-SQL Tips & Tricks

INFORMATION_SCHEMA.ROUTINE_COLUMNS

This query shows the Code behind  of INFORMATION_SCHEMA.ROUTINE_COLUMNS.

Posted in Database Administration, Information Schema | Leave a comment

INFORMATION_SCHEMA.COLUMN_PRIVILEGES

The next script is the Code behind of the INFORMATION_SCHEMA.COLUMN_PRIVILEGES view.

Posted in Database Administration, Information Schema | Leave a comment

COLUMN_DOMAIN_USAGE

Information Schema Views Code behind (INFORMATION_SCHEMA.COLUMN_DOMAIN_USAGE)!!!

Posted in Database Administration, Information Schema | Leave a comment

REFERENTIAL_CONSTRAINTS

Information Schema Views Code behind (INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS)!!!

Posted in Database Administration, Information Schema | Leave a comment

CHECK_CONSTRAINTS

Information Schema Views Code behind (INFORMATION_SCHEMA.CHECK_CONSTRAINTS)!!!

Posted in Database Administration, Information Schema | Leave a comment