SQL Server Education (by the geeks, for the geeks)
Hi All Here is the another tip for SSMS. When you open the SSMS, by default it will open the Object Explorer. You can change that into your preferred startup option …
SQL Server: SSMS Tips – Startup Options Read MoreA couple of months back our infrastructure team had undertaken a project to upgrade server hardware and the OS as part of their objective to make systems more resilient. For the …
SQL Server: The curious case of SSIS package(s) failing with the message “The version number in the package is not valid. The version number cannot be greater than current version number” Read MoreToday morning, we had received a severity 17 alert from one of our remote SQL Server instances, indicating primary filegroup for the tempdb had gone full. The SQL instance is a …
SQL Server: How to query from default trace on DATA & LOG file autogrow events Read MoreEarlier today while writing a blog on how to query the SQL default trace for a specific information, I was reminded of a queer request from my project manager, which had …
SQL Server: How to query for DDL changes from the default trace when no DDL auditing has been configured on the database Read MoreHi Friends, Microsoft recommends simple recovery model for MSDB system database. I Agree. But let us understand that its a recommendation in normal circumstances. MSDB database has job history, backup restore …
SQL Server: MSDB in FULL RECOVERY Model in SQL Server Read MoreHi Friends, Reading Amit Bansal’s tips on SQL Server Management Studio, I also remembered the old days when we used to do such small tweaking to automate some of the tasks …
Keyboard Shortcuts in SQL Server Management Studio Read MoreHi Friends, Attending SQL Server sessions in India was never been so easy and accessible at- least not for free, but now anyone can attend these sessions for free and easily …
Super Hit SQL Server Sessions in Bangalore, Mumbai and Kolkata Read MoreHi Friends, So here is another trick in SQL Server Management Studio. Many of you might create a New Stored Procedure using the New Menu Item as shown below: your needs. …
SQL Server – Management Studio Tip: Change Default templates for Stored Procedures Read MoreHi All, Today i received a problem from one of the DBA, His problem was unique, he wanted to change the collation setting of tempdb to Japanese_BIN. At first this seems …
Change Collation setting for TemDB Read MoreHi Friends, Whenever I click on ‘New Query’ in SQL Server Management Studio, I get the New Query Window, but a customized one. See below: You can see that “Copyright …
SQL Server – Management Studio Tip: Get a customized New Query Window Read More