MSSQLTips.com
While at the Verify 2006 Conference, I got to catch up with Jeremy Kadlec (one of our local NOVASQL User Group leaders) and found out about some of the new things that Edgewood Solutions are doing. The Edgewood team, who are experts in Microsoft SQL Server, are now publishing a daily Microsoft SQL Server tip on their website
Some recent tips that grabbed my attention:
- Deleting Data: TRUNCATE vs DELETE
- The NORECOMPUTE option of UPDATE STATISTICS
- Improve Performance with SQL 2005 Covering Index Enhancements
- Cross Walk - SQL Server Query Plans
Our team (Thycotic) has strong SQL Server expertise but mostly on the development side – consuming these tips is an exciting opportunity to get inside the minds of the gurus who can administer, tweak and tune SQL Server to do amazing things. Add these tips to your daily tech diet – we plan to!
Jonathan Cogley is the CEO and founder of Thycotic Software, a .NET consulting company and ISV in Washington DC. Thycotic Secret Server is a secure web-based solution to both "Where is my Hotmail password?" and "Who has the password for our domain name?". Secret Server is the leader in secret management and sharing within companies and teams.