The Ji Village News

Category: SQLServer

  • Thinking of Ken Henderson during PASS conference

    Sql Server 2008 is here, and Microsoft is busy working on the next release. But let me tell you, there are still tons of Sql Server 2000 out there. So far this year, I spent well over 2/3 of my time working on Sql Server 2000 projects. Clients know they need to move to the…

  • Check out DTS Package Search

    One of my buddies wrote a program that can help you find the DTS packages that reference a server, database, table, stored procedure, column, etc. I’ve worked with DTS enough times to know that this is really a very handy tool to help your day-to-day job and DTS package promotion from one environment to another.…

  • Move SQL Server backup file and restore it with Perl

    #There are two key parts for this script. The first part copies the latest backup and paste it in the local g drive. The second part do the restore from this backup file. It’s a LightSpeed backup and restore. Linchi Shea’s SQLDBA helper Perl files are needed. This is mainly for my own safekeeping. [sourcecode…

  • Find out total database file sizes on a Sql Server instance

    Sometimes you want to know how much space Sql Server databases on an instance are taking from a system. This should be the sum of all data files and log files. Note this is different from how much space actual data is taking. Here is one way to do it. Note it uses sysaltfiles, a…

  • Find out distributor and publisher info in SQL Server replication

    The script below is available in MSDN. I used it a few months ago but it took me some time to find it again, so I decided to put it here for my own reference. Purpose: find out information on distributor and publisher databases, articles, and publications in SQL Server replication. [code language=”sql”] –********** Execute…