Home » Posts tagged 'SQL Server Management Studio'
Tag Archives: SQL Server Management Studio
Step-by-Step SQL Server Migration Using SSMS: Best Practices & Use Cases
Introduction Migrating databases can be a complex task, especially when dealing with large-scale systems or transitioning to cloud environments. The SQL Server Migration component in SQL Server Management Studio (SSMS) offers a streamlined approach to transferring databases between SQL Server instances or to Azure-based platforms. This built-in feature simplifies the process by providing tools for assessment, scripting, … Continue reading
Query Store – Useful Tool for DBAs
SQL Server is a robust and flexible database management system that offers a variety of features and capabilities to help organizations effectively manage their data. One of the key features of SQL Server is its ability to provide insights into query performance, enabling database administrators and developers to identify and resolve performance issues. The Query … Continue reading
Introduction to Microsoft SQL Server Management Studio (SSMS)
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please join us on Facebook & YouTube.] Microsoft SQL Server Management Studio IDE (Integrated Development Environment) is a powerful GUI tool with a long list of features and options. SSMS is very useful and user friendly for all users like DBA, Developers, Testers, or … Continue reading
Error while loading Excel data into database
Issue: I am trying to load data from Excel 97 – 2003 sheet into a database table. I have written a simple SSIS package to do that, but unfortunately, it fails with error: – Microsoft (R) SQL Server Execute Package Utility Version 11.0.6020.0 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 2:02:37 … Continue reading
Restrict user to login from single Host
Restricting user to login from single host may be sometimes required from security point and other business requirements. We can achieve it through SERVER LEVEL LOGON TRIGGER. ALTER TRIGGER TR_CHECK_LOGIN_TEST_HOST ON ALL SERVER FOR LOGON AS BEGIN DECLARE @HOSTNAME VARCHAR(48) DECLARE @PROGNAME VARCHAR(100) SELECT @HOSTNAME = HOST_NAME FROM SYS.DM_EXEC_SESSIONS WHERE SESSION_ID = @@SPID IF ORIGINAL_LOGIN() … Continue reading