A few short scripts checking out the cause for TFS Integration Tools refuses to start despite an admin being able to create a TEST database. Read the rest of this entry »
Archive for the ‘SQL Server’ Category
Posted by Jeroen Pluimers on 2014/06/12
Posted by Jeroen Pluimers on 2014/04/08
Thanks to that link, I found the original article and images by C.L. Moffat!
–jeroen Read the rest of this entry »
Posted in Access, Database Development, DB2, Development, Firebird, InterBase, MySQL, OracleDB, PostgreSQL, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7 | Leave a Comment »
Posted by Jeroen Pluimers on 2014/03/31
With SQL Server, when your database is in “Recovery Pending” mode don’t just start blindingly search google, but sit down as you might be causing more damage doing so.
- Search Engine Q&A #4: Using EMERGENCY mode to access a RECOVERY PENDING or SUSPECT database.
- SQL Server EMERGENCY mode repair.
Then think about it before acting.
Though the simplest cause for “Recovery Pending” might be that a disk spin-up was slow, or a disk became full (and everything might just be dandy after the disk is available and there is enough room on it), make sure you read the above posts first before relying on the simple causes.
Posted in Development, Software Development, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014 | Tagged: EMERGENCY mode, Recovery Pending, SQL Server | Leave a Comment »
Posted by Jeroen Pluimers on 2014/03/26
When opening SQL Server Management studio with ssms command (+parameters) I need the Object Explorer to be filled and point to the right location – Stack Overflow
Posted by Jeroen Pluimers on 2014/03/25
As a SQL Server developer, most of us make extensive use of SQL Server Management Studio.
With lots of production database, I have a directory full of shorcuts that pre-fill server/database/… on the command-line.
One of the drawbacks these shortcuts have is that the Object Explorer stays empty, and does not sync with the currently active Server/Database.
While browsing to solve that, I found that the
Alt+F8 shortcut will focus the SERVER in the Object Explorer.