SQL Server and Databases resources

Resources: SQL Server performance: http://wp.me/p15Zft-8h SQL Server Video archive: https://technet.microsoft.com/en-us/dn912438 Database tasks: https://technet.microsoft.com/en-us/library/ms165730(v=sql.105).aspx T-SQL reference: https://technet.microsoft.com/en-us/library/ms189826(v=sql.90).aspx SQL performance and troubleshooting: http://sqlnexus.codeplex.com/ Microsoft companion (MOC): http://www.microsoft.com/en-us/learning/companion-moc.aspx Web sites: http://guimberteau.net http://sqlpro.developpez.com http://sqlmag.com Tips and tricks: PowerShell: import-module SQLPS Placement of tempdb in a dedicated disk (Raid 1) ,¬† same for log files¬† (RAID 1 or 10) andContinue reading “SQL Server and Databases resources”