The SharePoint 2010 Auto Installer (AutoSPInstaller) has released a new version 2.5.

Automated SharePoint 2010 Powershell-based installation script.

AutoSPInstaller works with and now leverages enhancements in SharePoint 2010 Service Pack 1 (with or without the June 2011 CU)! It takes advantage of some of the cmdlet updates in SP1, while remaining backward-compatible with non-SP1 deployments.

Versions 2.5.x and up include several updates to the input file XML schema from version 2.0 so make sure you compare any of your existing XML files to the new AutoSPInstallerInput.XML. See below for highlights of changes in v 2.5.x.

Greg Robidoux has a very helpful post “SQL Server Find and Replace Values in All Tables and All Text Columns”, where he presents the following SQL:

SET NOCOUNT ON
DECLARE @stringToFind VARCHAR(100)
DECLARE @stringToReplace VARCHAR(100)
DECLARE @schema sysname
DECLARE @table sysname
DECLARE @count INT
DECLARE @sqlCommand VARCHAR(8000)
DECLARE @where VARCHAR(8000)
DECLARE @columnName sysname
DECLARE @object_id INT

SET @stringToFind = ‘Smith’
SET @stringToReplace = ‘Jones’

DECLARE TAB_CURSOR

CURSOR FOR SELECT B.NAME AS SCHEMANAME, A.NAME AS TABLENAME, A.OBJECT_ID
FROM sys.objects A
INNER JOIN sys.schemas B ON A.SCHEMA_ID = B.SCHEMA_ID
WHERE TYPE = ‘U’
ORDER BY 1

OPEN TAB_CURSOR FETCH NEXT
FROM TAB_CURSOR INTO @schema, @table, @object_id WHILE @@FETCH_STATUS = 0

BEGIN
DECLARE COL_CURSOR CURSOR FOR
SELECT A.NAME FROM sys.columns A
INNER JOIN sys.types B ON A.SYSTEM_TYPE_ID = B.SYSTEM_TYPE_ID
WHERE OBJECT_ID = @object_id AND IS_COMPUTED = 0
AND B.NAME IN (‘char’,’nchar’,’nvarchar’,’varchar’,’text’,’ntext’)

OPEN COL_CURSOR FETCH NEXT
FROM COL_CURSOR INTO @columnName WHILE @@FETCH_STATUS = 0

BEGIN
SET @sqlCommand = ‘UPDATE ‘ + @schema + ‘.’ + @table + ‘ SET [' + @columnName + '] =
REPLACE(convert(nvarchar(max),[' + @columnName + ']),”’ + @stringToFind + ”’,”’ +
@stringToReplace + ”’)’ SET @where = ‘ WHERE [' + @columnName + '] LIKE ”%’ +
@stringToFind + ‘%”’

EXEC( @sqlCommand + @where)

SET @count = @@ROWCOUNT IF @count > 0

BEGIN
PRINT @sqlCommand + @where
PRINT ‘Updated: ‘ + CONVERT(VARCHAR(10),@count)
PRINT ‘—————————————————-’

END

FETCH NEXT FROM COL_CURSOR INTO @columnName END

CLOSE COL_CURSOR DEALLOCATE COL_CURSOR

FETCH NEXT FROM TAB_CURSOR INTO @schema, @table, @object_id END

CLOSE TAB_CURSOR DEALLOCATE TAB_CURSOR

Here is an SQL that you can run to find the total used size of an SQL Server 2008 database instance:

   CREATE TABLE #t (name SYSNAME, rows CHAR(11), reserved VARCHAR(18),    data VARCHAR(18), index_size VARCHAR(18), unused VARCHAR(18))   exec sp_MSforeachdb '      use [+];       if (select DB_NAME())<> ''tempdb''          begin             EXEC sp_msforeachtable ''INSERT INTO #t EXEC sp_spaceused [?]''          end       ', '+'    SELECT SUM(CONVERT(INT, SUBSTRING(data, 1, LEN(data)-3))) as sizeKB FROM #t     DROP TABLE #t  

Bill Graziano at SQLTeam.com has a listing of all the SQL Server versions that come in very handy:

http://www.sqlteam.com/article/sql-server-versions

This is an update to a previous post (Shrink All Log Files Within A MS SQL Instance) that has been edited to work in SQL Server 2008.

<br />
declare @ssql nvarchar(4000)<br />
set @ssql= '<br />
    if ''?'' not in (''tempdb'',''master'',''model'',''msdb'')<br />
        begin<br />
            use [?]<br />
            declare @tsql nvarchar(4000) set @tsql = ''''<br />
            declare @recmodel nvarchar(10)<br />
            declare @iLogFile int<br />
            declare LogFiles cursor for<br />
            select fileid from sysfiles where  status &amp; 0x40 = 0x40<br />
            open LogFiles<br />
            fetch next from LogFiles into @iLogFile<br />
            while @@fetch_status = 0<br />
                begin<br />
                    select @recmodel = (SELECT recovery_model_desc FROM sys.databases WHERE name = ''?'' )<br />
                    if @recmodel = ''FULL''<br />
                        begin<br />
                            set @tsql = @tsql + ''use [?] ''<br />
                            set @tsql = @tsql + ''ALTER DATABASE [?] SET RECOVERY SIMPLE ''<br />
                            set @tsql = @tsql + ''DBCC SHRINKFILE(''+cast(@iLogFile as varchar(5))+'', 1) ''<br />
                            set @tsql = @tsql + ''ALTER DATABASE [?] SET RECOVERY FULL ''<br />
                        end<br />
                    else<br />
                        set @tsql = @tsql + ''DBCC SHRINKFILE(''+cast(@iLogFile as varchar(5))+'', 1) ''<br />
                    fetch next from LogFiles into @iLogFile<br />
            end<br />
            --set @tsql = @tsql + '' BACKUP LOG [?] WITH TRUNCATE_ONLY '' + @tsql<br />
            --print @tsql<br />
            exec(@tsql)<br />
            close LogFiles<br />
            DEALLOCATE LogFiles<br />
        end'<br />
exec sp_msforeachdb @ssql<br />