just read this to create certificates for you dev box. just read this to implement your certificates to your box
Archiv für den Monat April 2012
Logging issue
The following table lists index operations and the type of logging available in each database recovery model for those operations. These recovery models are supported for both online and offline index operations. Index operation Full Bulk-logged Simple ALTER INDEX REORGANIZE Fully logged Fully logged Fully logged ALTER INDEX REBUILD Fully logged Minimally logged [...]
create database snapshot with multiple filegroups/files
I found this script to create a database snapshot with multiple filegroups/fils, very usefully! many thx to Ravikanth $computerName = "YOURDBINSTANCE" $dbName = "YOURDB" $snapshotName = "YOURSNAPSHOTNAME" #Load all SQL necesssary assemblies #this is a common section in all my SQL scripts [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMo") | Out-Null [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMoExtended") | Out-Null [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMoEnum") | Out-Null [Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.ConnectionInfo") | [...]
fast faster fedex
see this, i orderd memory(usa to germany) on Monday, now it is friday thx fedex
File activation failure. The physical file name The log can not be rebuilt because the database was not cleanly shut down
In certain situations you do not want to be a DBA Last week I was asked by a colleague to take care of a database. No one had bothered to really work/administrate with this database since 2008 but everyone is using this DB…. what I saw there was already a quite a desaster. The database was [...]
links links
Export data from Postgres to SQL Server using SSIS SQL Server Performance Monitoring and Tuning Tutorial
Disable/Enable all triggers and constraints in a database
USE yourDataBase; — SQL disable all triggers – disable all triggers sql server – t sql disable trigger EXEC sp_MSforeachtable @command1="ALTER TABLE ? DISABLE TRIGGER ALL" GO — SQL disable all constraints – disable all constraints sql server EXEC sp_MSforeachtable @command1="ALTER TABLE ? NOCHECK CONSTRAINT ALL" GO — How to check if a trigger is [...]