Shared Points

items of some interest

Browse by Tags

Related Posts
  • Blog Post: PowerShell - sorting files by datestamp for SQL backup/restore

    # Do-SPSQLbackupRestore.ps1 # usage: # DO-SQLBackupRestore <Backup|Restore> [<SQL instance>] [<XMLfilename]> # [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | Out-Null [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SmoExtended"...
  • Blog Post: SQL - dammit it's in there somewhere!

    # I wanted to find ALL references to a particular string ( domain\user ) and I had no idea WHERE it might be. # so how do you ask SQL to go look everywhere and report back? # like this... DECLARE @searchValue varchar(100) SET @searchValue = ' domain\username ' SELECT 'select ''' + table_schema + ...