Contents tagged with sql server
-
SQL Server Blocking
https://docs.microsoft.com/en-us/troubleshoot/sql/performance/understand-resolve-blocking
https://blog.sqlauthority.com/2020/04/20/sql-server-blocking-tree-identifying-blocking-chain-using-sql- … more
-
SQL Server Disaster Recovery (DR) and High Availability (HA) Licensing Benefits
https://cloudblogs.microsoft.com/sqlserver/2019/10/30/new-high-availability-and-disaster-recovery-benefits-for-sql-server/
https://www.quexcel.com/knowledge-base/knowledge-base/new-sql-server-high- … more
-
SQL Server Connection String for Integrated Security (Windows Authentication)
connectionString="data source=SERVER\INSTANCE;Initial Catalog=MyDB;Integrated Security=SSPI;If using an App Pool account, use the following example formats:IIS APPPOOL\DefaultAppPoolIIS APPPOOL\ … more
-
Prevent Object Create in Master Database in SQL Server
USE masterGOSET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TRIGGER DDL_PreventObjectCreationInMasterDBON DATABASEFOR CREATE_TABLE, CREATE_VIEW, CREATE_PROCEDURE,CREATE_FUNCTIONASBEGIN-- SET … more
-
SQL Server Always On Availability Groups Step By Step
https://www.sqlrx.com/steps-for-installing-sql-server-alwayson-availability-groups/
https://argonsys.com/microsoft-cloud/library/step-by-step-creating-a-sql-server-alwayson-availability-group/ … more
-
SQL Server Ports: How to Find
https://www.sqlshack.com/overview-of-sql-server-ports/
-
Connection Strings for SQL Server and Other Databases
https://www.connectionstrings.com/ more
-
Logging SQL Server Logins
Source:
https://www.sqlservercentral.com/blogs/has-this-login-been-used-recently
--DROP TABLE #LogInfo
DECLARE @searchstring1 nvarchar(500) = ''
DECLARE @searchstring2 nvarchar(500) = '' … more
-
SQL Server Express LocalDB
You can connect with SSMS or visual studio with server name:
(localdb)\MSSQLLocalDB
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-express-localdb?view=sql- … more
-
SQL Server Ports
Using netstat is handy to research to see if a port is in use, but for this issue it is more direct to see what SQL Server thinks is going on, and fortunately there are some views that have the info … more