Browse by Tags

All Tags » SQL Server (RSS)
Sorry, but there are no more tags available to filter with.
Tuesday, October 05, 2010 12:31 PM

Automate Backup of SQL Express Databases

It's a fact that no integration services and SQL agent available in SQL Express products, but it's a must to backup SQL Express databases in a timely basis. There is a very useful article describing how to do it with TSQL and Windows Schedule Tasks. Backup...
Posted by Colt | 7 comment(s)
Filed under:
Wednesday, September 01, 2010 7:14 PM

List all tables and their row counts

Just find few useful tips/tool when I try to compare the schema and content of two SQL databases: DBComparer (free) Find out DB lock: select distinct object_name(a.rsc_objid), a.req_spid, b.loginame from master.dbo.syslockinfo a (nolock) join master.dbo...
Posted by Colt | 3 comment(s)
Filed under:
Monday, August 23, 2010 12:53 PM

Grant SPROC Permission to an Application Account

With the principle of least privilege of application / database account, web app normally uses a DB account with limited permission to specific database objects in Connection String. Manually typing of "GRANT EXECUTE ON <Object> to <User>...
Posted by Colt | with no comments
Filed under:
Friday, April 23, 2010 6:04 PM

SQL Server Capacity Planner

Apart from the capacity planner tool for System Center and SharePoint Server, I was looking for a tool which can help me to estimate the capacity of SQL Server. I found an article on Microsoft.com for SQL Server 2000 sizing but unfortunately the links...
Posted by Colt | 38 comment(s)
Filed under:
Saturday, December 26, 2009 6:30 PM

Saving changes is not permitted in SQL 2008 Management Studio

I worked with SQL 2008 in a recent project, but I got the following message whenever I try to make change to a table structure in SQL management studio: Saving changes is not permitted. The changes you have made require the following tables to be dropped...
Posted by Colt | 23 comment(s)
Filed under:
Friday, July 20, 2007 1:26 PM

Unique and non unique index in SQL server

A developer asked me a question yesterday about what's the difference of unique and non unique index in a DB table. I then google and redirect him to this short and clean article: http://www.w3schools.com/sql/sql_create.asp It's good to recall: Updating...
Posted by Colt | 1 comment(s)
Filed under:
More Posts