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

By |February 17th, 2015|Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on SQL Server Error Message 6263 – Enable SQL Server for CLR Support|

Reverse string in SQL Server

By |February 17th, 2015|Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Reverse string in SQL Server|

Recursive triggers in SQL Server

By |February 14th, 2015|Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on 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

By |February 6th, 2015|Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on 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

By |February 1st, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Except vs NOT IN performance in SQL Server|

Disable Enable Indexes SQL Server

By |January 29th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Disable Enable Indexes SQL Server|

List all databases in SQL Server

By |January 27th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on List all databases in SQL Server|

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

By |January 25th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on SQL Server error 130 – Cannot perform an aggregate function on an expression containing an aggregate|

SQL Server tablesample example

By |January 23rd, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on SQL Server tablesample example|

T-SQL find tables without clustered index

By |January 20th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on T-SQL find tables without clustered index|

Disadvantages of triggers in SQL Server

By |January 18th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Disadvantages of triggers in SQL Server|

Change TSQL batch separator GO

By |January 15th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Change TSQL batch separator GO|

ASCII to Decimal and Decimal to ASCII in SQL Server

By |January 13th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on ASCII to Decimal and Decimal to ASCII in SQL Server|

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

By |January 10th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on SQL Server error code 544 – Cannot insert explicit value for identity column|

Primary key not null in SQL Server

By |January 7th, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Primary key not null in SQL Server|

Trace flags in SQL Server

Get SQL Server configuration information

By |January 1st, 2015|Database Administration, Database Development, SQL Server, SQL Server Accidental DBA Series, Transact-SQL|Comments Off on Get SQL Server configuration information|
Newsletter_Footer