SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » Tools (RSS)

Browse by Tags

  • DTS Support in SQL Server 2005

    Had a call this morning from a SQL Server developer looking to run DTS packages on a SQL Server 2005 machine with Integration Services installed. The user's problem was that he could not edit or run the DTS package via Management Studio. There is a simple solution to this problem, which involves Installing...
    Posted to Rob's SQL Server Blog (Weblog) by robcarrol on Sat, Feb 2 2008
  • Data Data everywhere even when you think its gone

    The biggest problem I have faced in IT over the last decade has been loss of data. I have had the problem at work where servers have crashed and lost data, more often than not due to failure of disks. I have also personally felt the pain in a hard disk losing its partition information, and frequently...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Sun, Aug 12 2007
  • Add-ins for Management Studio

    This is one of the popular requests, unfortunately its not going to be in Katmai. A number of people have done it through Redgate being the major guys. However I came across Seans post about his snapshot Addin ( I would love to see the code Sean)
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jul 17 2007
  • The joy of template parameters

    This blog has been migrated to . Please update your feeds. This post can be found here.
    Posted to Andrew Calvett (Weblog) by ACALVETT on Sun, Jul 15 2007
  • How to access SQL Server when you've forget the password

    There is a little known feature of SQL Server 2005 is that when you start SQL Server in single user mode local administrators of the server have sysadmin access to the sql server. You may feel this a security concern, but if a user can get local admin of your server, and restart your service then having...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 22 2007
  • How many indexes do you have that aren't used?

    If you run this sql on a sql 2005 box then you will see which indexes aren't used in queries compared with the number of times they are updated. select object_name ( s . object_id ) , * from sys.dm_db_index_usage_stats s join sys.indexes i on i . index_id = s . index_id and s . object_id = i . object_id...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 16 2007
  • SQL Compare is public beta

    The latest version of SQL Compare is now in public beta. You can read more here . I'm a big fan of SQL compare although there are numerous annoyances I hope they have addressed. - var height=90;var width=720;
    Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, May 15 2007
  • SSIS - Viewing packages in Management Studio

    Its odd how you often find things out by accident. Yesterday I was copying a dts package into a folder on my server and for some reason the drop didn't drop. When I then switched to management studio and XP finally decided to drop the file it did it in the management studio work space. At first I...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, May 11 2007
  • Katmai - Group Policy for SQL Server

    If you've worked in a large AD shop you will have come across Group Policy. A means by which you can make sure each component in a domain has the same settings, behaves the same way, has the same security. This is essential when managing a large server estate. Unfortunately Group Policy doesn't...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, May 9 2007
  • Limit a sql script to only run with SQLCMD turned on

    I really like SQLCMDso much so that most of my deployment scripts use SQLCMD. Its got some great features such as :on error exit. Forcing your script to exit when an error occurs. or :r <filename> to read the contents of a file There is one downside and that is if you run a sqlcmd script in management...
    Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Apr 23 2007
Page 3 of 4 (38 items) < Previous 1 2 3 4 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems