Log in | Register

SQL Server Accidental DBA - SQLServerGeeks.com SQL Server Accidental DBA - SQLServerGeeks.com

Accidental DBA series by Ahmad Osama

Accidental DBA series

1_SQL Server Accidental DBAHi SQL folks, my name is Ahmad Osama. I work as a Sr. DBA in a leading Product-based company. I use SQL Server extensively and have learned a few things the tough way. In this SQL Server Accidental DBA series, I intend to share my experience with you by writing about some of my daily experiences. Hope you enjoy! Happy Learning!

SQL Server Error Message 6263 – Enable SQL Server for CLR Support

Reverse string in SQL Server

Recursive triggers in SQL Server

Function to parse alphanumeric characters from string in SQL Server

Find working days between two dates in SQL Server

Could not find a table or object named ”. check sysobjects – SQL Server Error 2501

T SQL code formatter

Except vs NOT IN performance in SQL Server

Disable Enable Indexes SQL Server

List all databases in SQL Server

SQL Server error 130 – Cannot perform an aggregate function on an expression containing an aggregate

SQL Server tablesample example

T-SQL find tables without clustered index

Disadvantages of triggers in SQL Server

Change TSQL batch separator GO

ASCII to Decimal and Decimal to ASCII in SQL Server

SQL Server error code 544 – Cannot insert explicit value for identity column

Primary key not null in SQL Server

Trace flags in SQL Server

Get SQL Server configuration information