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!

Error handling using TRY Catch in SQL Server

ANSI NULL SQL Server

T-SQL find tables without primary key

SQL query analyzer keyboard shortcuts

SQL Function to remove characters from string

SET DATEFIRST in SQL Server

How to change database compatibility level in SQL Server

Get SQL Server Agent job details

T-SQL find all identity columns

Error 40 could not open a connection to SQL Server

Function to get date from datetime in SQL Server

Find tables with identity columns in SQL Server

Frequently used DBCC commands in SQL Server

Script to find all SQL Servers on network

SQL Server error 18456 login failed for user SA

Function to Extract Month from Date in SQL Server

SQL Function to Extract Year from Date

Msg 7391 level 16 state 1 line 1 in SQL Server

Improve stored procedure performance in SQL Server

Newsletter_Footer