Browse by Tags

Blobs block online indexing

If you are lucky enough to be running enterprise edition of SQL you may have looked or want to look into online index rebuilds. Unfortunately having blobs in your index blocks you from being able to do online rebuild of that index. Cruically what that means is that if your table is clustered then you...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jun 27 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
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
Maintenance plan warning for SP2

Due to a regression bug introduced in SP2 some of the maintenance plan tasks that can operate on multiple databases may not perform as expected. If a maintenance plan component uses TSQL of this nature USE [DBFred] GO DBCC CHECKDB.... GO USE [DBSimon] GO DBCC CHECKDB.... To handle errors in the process...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 8 2007
Native Command Substitution is not supported

In response to a recent support incident we raised we got a response about use of detours in SQL Server. A detour is a means by which you can change what SQL Server does. This is used by Litespeed to change native backup commands into Litespeed backup commands. Whilst I always thought this a neat idea...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 5 2006
RAID Explained

Thanks to Tom Moreau for pointing in to this great explanation of RAID :) - var height=90;var width=720;

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Oct 4 2006
Restoring your SQL Server - Chicken and the Egg

Have you tested your DR plan? Do you have one? Well if you do have one then unless you test it its worthless. There are many nuances that occur in a recovery process. The Storage Engine Team have posted about one suhc nuance. The customer was testing their DR process which included the complete restore...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Sep 27 2006
SQL News 18 June 2006 - Yer off yer head ya eejit, that's no a real dug

Its been almost a month since the Storage Engine Blog was started and as Kimberley Tripp has mentioned its a must read. I am still waiting for a post that I haven't found interesting. The posts continue on how to manage your database, repairing, recovery etc. Whats great about the posts so far is that...

Posted to SqlNews (Weblog) by simonsabin on Sun, Jun 18 2006

Page 1 of 1 (8 items)