Recently we started a big project which uses S#arp Architecture and for those who does not know what it is you can go to the site (http://www.sharparchitecture.net/) and have a read, but in a gist it is an open source architectural foundation that uses ASP.NET MVC framework with NHibernate.
Today I was trying to make a code generator for one of our projects to make our lives easier, basically I was trying to list all objects on our SQL Server database and Print a C# code output which I can then save as a .cs file, all went fine until I realized that Entities… Read More »
You might have SQL Mirroring enabled in your Enterprise but might not have alerting enabled or you don’t know how to enable it. If you want to enable that functionality just follow this 2 easy steps.
Before we start lets define what a Median is first, in laymans term the Median is the “middle number” in a sorted list of numbers.
Mirroring a database is not really a hard task to do, you just need this easy and simple 11 steps to start mirrored SQL Server. Doing it will not just improve you disaster recovery capabilities on your application but also you are leveraging the high availability database mirroring feature you find in SQL Server 2005… Read More »
After my post here, It seems that everything is working fine but I need performance out of it an my last resort is to Execute Stored Procedures in Parallel so I can run multiple instances in one run. To achieve that I need to create a CLR Stored Procedure so I can run Execute commands… Read More »
This article is about making the best use of the SQL Server Maintenance Plans, I am saying that because if you really want to do best practice maintenance on a SQL Server is that you should do it on a script level and trigger it by job schedule as doing this one you can have… Read More »
I’m not a DBA but I have a real life experience repairing a suspect databases twice, I guess I can say that I am unlucky at that time as I was presented in a tough situation where I am still in the process of learning how things work and we don’t have a DBA resource… Read More »
Automating Backups on SQL Server Express Version is not as it does not have a SQL Server Agent installed with the instance but dont worry as you can still do backups but manually using the free SQL Server Management Studio Express or automated by using a combination of scheduled task (Win2k3 below) / Task Scheduler… Read More »
If you want to audit whats happening on your SQL Server then look no further as SQL Server 2008 have a built in function for that, so you can log all Queries like Select, Insert, Updates and Deletes perfromed on a cetain table easily, before you will be needing third party tools to do this… Read More »