Forgot the password of username SA? Resetting it is easy when another sysadmin login or a Windows admin account can get in. Here are your options.
SQL SERVER – Maximizing View of SQL Server Management Studio – Full Screen – New Screen
Two ways to get more room in SQL Server Management Studio: show results in a separate tab and switch SSMS to full screen, from my TechEd India 2009 demo.
SQL SERVER – SQL Server Management Studio New Features
The top 5 new features of SQL Server Management Studio 2008, the tool that replaced Enterprise Manager and Query Analyzer, with upgrades DBAs asked for.
SQL SERVER – 2008 – SSMS Feature – Multi-server Queries
SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.
No Join Predicate: Verify the Relationship Before Tuning
No join predicate prompts a relationship check. Compare all combinations with exact customer-order pairs before changing indexes or hiding duplicates.
SQL SERVER – Create Multiple Filegroup For Single Database
How to create multiple filegroup for a single database, both for a new database and an existing one, using T-SQL as well as SSMS.