Introduction Starting SQL Server 2008, SSMS allows you to Select Top 1000 rows and Edit Top 200 rows. However, in the previous version of SSMS 2005, the only option was to open the entire table. Let us see how to alter...
Category - SQL Server
Ashish MehtaHow to Enable and Refresh IntelliSense in SQL Server Management Studio (SSMS)
Introduction In SQL Server 2008, Microsoft had introduced IntelliSense feature in SQL Server Management Studio (SSMS). As a Developer or as a DBA you may face issues with IntelliSense feature not to be working or not...
How to Verify and Register SPN for SQL Server Authentication with Kerberos Connections
Introduction This article explains how to verify and register Service Principal Names (SPN) for SQL Server Authentication with Kerberos Connections. Kerberos Authentication is a widely accepted network authentication...
Drop Database in SQL Server by Killing Existing Connections
Introduction Let’s learn how to Drop Database in SQL Server when the users are connected to the SQL Server Database. You may find the need to close all the existing database connections in a database before...
Display Line Numbers in SQL Server Management Studio (SSMS)
As a developer you may have often encounter errors while debugging TSQL code. SQL Server will show you an error message referencing you to a particular line number where the syntax error has occurred. This tip explains...
Chetna BhallaHow to Move TempDB to New Drive in SQL Server
There are times when as a DBA you find the need to move TempDB Data and Log Files to a new Drive. This article explains all the steps you need to follow to move TempDB files.
2 Signs you need to migrate to SharePoint 2016 and how to nail the upgrade
Reasons to Migrate to SharePoint 2016? Debates on migrating SharePoint solutions to its 2016 version started even before the version was officially released. All the stir is basically about the assertive promotion of...
