Monthly Archives: July 2010

Tips for using SQL Server 2008 bulk copy Tips for using SQL Server 2008 bulk copy … http://sqlmashup.posterous.com/alexander-chigrik-posts-tips-for-using-sql-se

[Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | Out-Null function Force-BuiltinAdministratorsIntoSysadmin { <# .synopsis Script to be used under user context within BUILTIN\Administrators when locked out of Sql Server, to grant sysadmin role to BUILTIN\Administrators. .description copyright = CC-BY-NC-SA author(s) = Robert Matthew Cook, date(s) = … Continue reading →

Windows OS Power Saving Feature Directly Affects CPU Performance Windows OS Power Saving Feature Directly Affects CPU Performance … http://sqlmashup.posterous.com/brad-m-mcgehee-bradmcgehee-posts-windows-os-p

Implicit Remoting with PowerShell Implicit Remoting with PowerShell … http://sqlmashup.posterous.com/aaron-nelson-sqlvariant-posts-about-implicit

Optimizing for Ad hoc Workloads via bobpusateri.com Optimizing for Ad hoc Workloads via bobpusateri.com … http://sqlmashup.posterous.com/bob-pusateri-sqlbob-posts-about-optimizing-fo

Not another TempDB post! Not another TempDB post! … http://sqlmashup.posterous.com/iain-kick-posts-nice-tempdb-summary-in-not-an

solidq.com solidq.com … http://sqlmashup.posterous.com/the-solidq-journal

Script SQL Objects with Powershell Script SQL Objects with Powershell … http://sqlmashup.posterous.com/jen-mccown-aka-sql-awesomesauce-posts-many-po

http://sqlblog.com/blogs/jamie_thomson/archive/2010/07/21/project-houston-ctp&#8230; http://sqlblog.com/blogs/jamie_thomson/archive/2010/07/21/project-houston-ctp&#8230; … http://sqlmashup.posterous.com/jamie-thomson-aka-jamiet-posts-about-ssis-jun

Log shipping: Four tips to maintain RTO and RPO with SQL Server Log shipping: Four tips to maintain RTO and RPO with SQL Server … http://sqlmashup.posterous.com/roman-rehak-post-about-log-shipping-four-tips