Click here to Skip to main content
15,885,244 members

Technical Blogs


RSS feed icon

Articles submitted by members via their Technical Blog feed. Want to have the blog entries from your Technical Blog automatically posted as articles on CodeProject? It's easy!

1. SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
SQL Server: A Query Slow in SSMS, Fast in Application, WHY?
(The Code Project Open License (CPOL))
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 9 Jan 2013
Rating: 5.00/5 ( (2 votes))
2. SQL Server: Three Common DDL Change Log Methods
Three common DDL change log methods for SQL Server.
(The Code Project Open License (CPOL))
Database Development » SQL Server »
aasim abdullah Updated: 30 Dec 2012
Rating: 4.67/5 ( (3 votes))
3. SQL Server: Placing Alert for Compatibility Level Change in SQL 2005
In SQL Server 2005, there is no way to find out WHO AND WHEN someone changed the compatibility level of a database. Here is a trick for this functionality.
(The Code Project Open License (CPOL))
Database Development » SQL Server »
aasim abdullah Updated: 22 Oct 2012
Rating: ( (No votes))
4. SQL Server: Disable Logon Trigger Using DAC to Resolve Login Problem
Using logon trigger, users from valid IP addresses can be restricted, but what if you forgot to add in safe list. You will be unable to login though you have sysadmin rights. Use DAC to disable logon trigger.
(The Code Project Open License (CPOL))
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 17 Sep 2012
Rating: 5.00/5 ( (1 vote))
5. SQL Server: Smarter Way of Query Load Testing at Testing Server
Smarter Way of Query Load Testing at Testing Server
(The Code Project Open License (CPOL))
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 17 Sep 2012
Rating: ( (No votes))
6. SQL Server: Script to Generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space
SQL Server: Script to generate HTML Report/mail for Databases Current Size, Growth Rate and Available Disk Space
(The Code Project Open License (CPOL))
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 17 Sep 2012
Rating: ( (No votes))
7. SQL Server: Applying Filter on sp_MSforeachDB
How to apply filter on sp_MSforeachDB
(The Code Project Open License (CPOL))
Database Development » SQL Server » SQL Server 2008
aasim abdullah Updated: 16 Sep 2012
Rating: 4.00/5 ( (2 votes))
8. SQL Server: Controlling SQL Server Log Information
How to control SQL Server Log Information
(The Code Project Open License (CPOL))
Database Development » SQL Server » SQL Server 2012
aasim abdullah Updated: 15 Sep 2012
Rating: ( (No votes))
9. SQL Server: How Local Variables Can Reduce Query Performance
How local variables can reduce query performance in SQL Server
(The Code Project Open License (CPOL))
Database Development » SQL Server »
aasim abdullah Updated: 15 Sep 2012
Rating: 1.20/5 ( (3 votes))
10. SQL Server: Simple way to swap column values
A simple way to swap column values.
(The Code Project Open License (CPOL))
Database Development » SQL Server »
aasim abdullah Updated: 12 Sep 2012
Rating: 3.50/5 ( (2 votes))
11. SQL Server: Why we should avoid the NOLOCK table hint in DELETE/UPDATE queries
Why we should avoid the NOLOCK table Hint in DELETE/UPDATE queries.
(The Code Project Open License (CPOL))
aasim abdullah Updated: 12 Sep 2012
Rating: 1.00/5 ( (1 vote))
12. SQL Server: Query to find upcoming birthdays for the current week
To find out whose birthday is coming in a given number of days is very simple.
(The Code Project Open License (CPOL))
aasim abdullah Updated: 12 Sep 2012
Rating: 1.00/5 ( (1 vote))