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 »
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 »
This is the first time it occured to me looking at a message on the SQL Object Explorer which says “See Object Explorer Details for objects in this folder”. My first reaction is WTF I am in Object Explorer Explorer already. For you to know what I am talking about here is the screenshot.
Have you ever wondered what are the top 3 IIS based Wiki Applications, well here is my list not sure if it will be you top 3 but this is mine. So what are my criteria? It should be free, you can easily modify it (opensource), the backend database should be SQL Server and it… Read More »
Have you ever thought of restricting access to the Database by Application Name or Host Name, that’s on top of the user credentials. For example you don’t want users to use SQL Query Analyser but instead they should use MS Access instead or another 3rd party application, or you want only a certain Workstation can… Read More »
I was tasked to create a query for an accounting journal entry from a transaction table with only amounts indicated, so if it’s a journal entry there should be a credit and debit but most of the other values will be similar, so I thought of extracting 2 rows from a single row through SQL… Read More »
Have you ever wondered how to perform the same query on different servers without going to each of the SQL Servers? Well I was presented this scenario just a while ago because I wanted to know what versions of SQL we are running and first thing I thought of is using the command
Here are some useful information for those who knows TSQL and wants to learn PL/SQL. Lets start with the data types
This week I have a lot of good challenges in SQL as we are building an SSIS package to unify data from different systems like Solomon, Raisers Edge, Goldmine, etc. A part of that SSIS Package is to cleanse the data and the toughest to cleanse is the addresses (which means putting the correct data… Read More »