Twitter Updates

    follow me on Twitter

    Monday, December 17, 2007

    SQLUG.BE - next session on SQL Server 2008

    Our next SQLUG.BE evening will take place on Thursday, January 17th, 2008. The session will be given by Gunther Beersaerts who will be talking about the new features of Sql Server 2008.


    Abstract:
    In this session we will provide an overview of the next release of SQL Server, SQL Server 2008, codenamed "Katmai". The session will cover the core value-proposition, major themes and scenarios, and the specific engine improvements, including the new Management Framework, datatypes (spatial,…), new Reporting Engine, FileStream, etc. We also cover the new development processes being used to build this release, the release timeline and the disclosure calendar.


    Level: 200 – 300
    Depending on the audience, we'll remain high-level (management / decision maker audience) or go more deeper (DBA, Developer or technical BI audience).


    Speaker:
    Gunther Beersaerts is a Senior Technical Specialist at Microsoft Belgium & Luxembourg.

    Agenda:
    18:00 - 18:30 Welcome
    18:30 - 21:00 Session with pause
    21:00 - 22:00 Drink


    Full details and free registration can be found here.

    Chopsticks, Technet Evening on HA and the 1 Euro SAN


    Microsoft Belux recently launched MSDN Chopsticks and Technet Chopsticks. These community focused websites are some kind of a Youtube with technical content. The sites already contain quite a few interesting videos. The videos are webcasts, funcasts, demos, and complete sessions.

    My Technet Evening on high availability in SQL Server 2005 was recorded and is now available online, including the demo with the 1 Euro SAN.

    Wednesday, December 05, 2007

    AITScripts - Nice bunch of Scripts

    Nice bunch of DBA related scripts ... written by the folks of the Database Operations team at Microsoft.


    Download here.

    SQLBackupAll – Performs Full database backup for non-excluded databases by SQL native or Litespeed backup commands. The job has parameters to specify the desired backup location and compress (SQL Litespeed backup) or nocompress (SQL native backup) , whether to backup or not to backup read only database etc.

    SQLBackupDiffAll - Performs Differential database backup for non-excluded databases by SQL native or Litespeed backup commands. This job is disabled by default. This can be enabled based on the customer’s needs for the recovery requirements.

    SQLBackupTranAll – Performs Transaction Log backup for non-excluded databases by SQL native or Litespeed backup commands. The job has parameters to specify the desired backup location and compress (SQL Litespeed backup) or nocompress (SQL native backup)

    SQLBackupChecker – Checks for backups that have not occurred in more than the specified number of hours in the job. There is a parameter to specify the desired number of hours to specify for the alert.

    SQLDBCCAll - Performs database consistency checks on all system and user databases.

    SQLIndexDefragAll – Performs Index defrag maintenance for non-excluded SQL 2000 databases. This job is disabled by default. It can be enabled based on the customer’s needs. This job helps to run the index defrag for all the databases in the SQL instance or any particular database or any particular table in a database.

    SQLUpdateStatistics - Runs Update Statistics maintenance for non-excluded databases.
    This job is disabled by default. This job is disabled by default. It can be enabled based on the customer’s needs. This job helps to run the update statistics for all the databases in the SQL instance or any particular database or any particular table in a database.

    SQLCleanupMsdbBackupHistory – Cleans up the backup history information from msdb database.

    SQLCycleErrorLog - Cycle the SQL Error log periodically so the size is manageable for viewing through SQL tools.