Contents tagged with SQL Server
-
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.
-
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:
-
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.
-
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.
-
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:
-
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