Μάιος 2012 - Δημοσιεύσεις
In this post I would like to demonstrate with hands-on examples how to use automation (jobs,alerts,operators,notifications) in SQL Server to automate SQL Server administration tasks. The importance of automating tasks is profound.The following tasks could
Διαβάστε περισσότερα
In this email I will demonstrate in detail how to set up Database Mail.I am sure that this feature is well documented elsewhere in the web but I decided to give it a go. Database Mail is a very useful feature.Both the Maintenance Plan Wizard and Maintenance
Διαβάστε περισσότερα
In this post I would like to explain with some hands-on examples how to create a partitioned table in SQL Server and then manage the partitions. I know there are samples of how to do that in BOL,MSDN and elsewhere but I thought that it would be a good
Διαβάστε περισσότερα
In this rather short post I would like to explain the concept of collation in SQL Server. This is a concept that stills confuses SQL Server DBAs and developers. I know that is a well documented feature (in books & the web) but I will give it a shot.
Διαβάστε περισσότερα