How to work with Registered Servers in SQL Server Management Studio

In SQL Server management studio their is powerful option to easily connect your server or execute query on that server To open register server window Menu -> view -> register servers Or Ctl + Alt + G We can run same query on all server using this feature Ref Link https://docs.microsoft.com/en-us/sql/ssms/register-servers/register-servers?view=sql-server-2017

SQL Server Management Studio (SSMS) Shortcuts

SQL Server Management Studio is a powerful software that can help to design and development of database as well help in maintenance and administrative works too. Change Selected Database Ctrl + U: Once you are in the Sql Editor, pressing Ctrl + U selects the database dropdown in the Sql Editor toolbar. You can then …

SQL Server Management Studio (SSMS) Shortcuts Read More »

Still some developer use improper data type when designing database.

Storage in very important part in RDBMS that’s why Microsoft provide various data type to solve this problem. OLTP and OLAP database behave same when they processing a query. It will effect overall performance and storage. Finally it will require more infrastructure cost. Varchar vs Nvarchar: Choice for Unicode / multilingual  data If you want …

Still some developer use improper data type when designing database. Read More »

SQL Server services

SQL Server 7 Common Name Service Display Name Service Name Executable Name Distributed Transaction Coordinator (DTC) Distributed Transaction Coordinator MSDTC msdtc.exe SQL Server MSSQLServer MSSQLServer sqlservr.exe SQL Server Agent SQLServerAgent SQLServerAgent sqlagent.exe SQL Server Analysis Services MSSQLServerOLAPService MSSQLServerOLAPService msmdsrv.exe SQL Server 2000 Common Name Service Display Name Service Name Executable Name Distributed Transaction Coordinator (DTC) …

SQL Server services Read More »