Home

Polls

Who administers your corporate database infrastructure?
 
How to configure database mail
Written by Administrator   
Wednesday, 18 March 2009 08:26

SQL Server 2005 provides the new database mail feature which allows a dba to configure e-mail on sql server without need of exchange server and account. Before actually configuring database mail dba needs to enable database mail stored procedures.

Comments (0)

Read more...
 
T-SQL Tutorial for beginners
Written by Administrator   
Friday, 13 February 2009 10:55

This article is supposed to help the people who faced sql server the first time. If you are already experienced in writing simple t-sql queries you will probably find this article useless and boring. But if you have only a vague understanding about what sql actually is then this article is written exactly for you.

Comments (0)

Read more...
 
How to apply sp3 to a clustered MS SQL Server 2005 instance
Written by Administrator   
Tuesday, 24 February 2009 14:19

This is step by step manual how to update SQL 2005 cluster to service pack 3. Microsoft SQL Server service pack are all cluster aware (which means they automaticaly detect clustered instances and update clustered features of the sql server) but anyway you need to know all the details when you are installing service pack to a sql cluster.

Comments (0)

Read more...
 
SQL GROUP BY
Written by Administrator   
Wednesday, 18 February 2009 09:30

In this article I will describe the purpose and best practices of group by clause of select statement. Any reporting select query requires group by clause to aggregate some results by particular parameters. That is critical for overall system performance to follow some best practices of group by queries.

Comments (0)

Read more...
 
How to execute multiple scripts on multiple sql servers
Written by Administrator   
Friday, 13 February 2009 13:53

Very often DBA needs to deploy a bunch of transact-sql scripts to multiple servers. There is a way to open each server in SQL Server Management Studio and than run each t-sql script on each sql server sequentially. Few things in DBA job may be more annoying than this especially if there are 50+ scripts and more than 10 servers.

Comments (1)

Read more...
 
<< Start < Prev 1 2 3 4 5 6 7 8 Next > End >>

Page 3 of 8
SPONSORED LINKS:

Who's Online

We have 8 guests online
Content View Hits : 292362
DB-staff Remote DBA Services, Powered by DB-Staff 2008