SQL Server
-
Fix Orphaned Users When Moving SQL Server Databases
Firstly to report on whether there are any orphaned users present for a database, run the following query against the DB;
EXEC sp_change_users_login 'Report'
Then to fix any identified orphaned … more
-
SSIS and Working with Files
https://www.sqlservercentral.com/articles/best-option-for-working-with-files-in-ssis-1 more
-
SQL Server TSQL Get Last Identity Seed After Insert
Use SCOPE_IDENTITY() if you are inserting a single row and want to retrieve the ID that was generated.
CREATE TABLE #a(identity_column INT IDENTITY(1,1), x CHAR(1));
INSERT #a(x) VALUES('a'); … more
-
Command Line equivalent of Generate Scripts Wizard in SQL Server Management Studio (SSMS)
https://github.com/microsoft/mssql-scripter more
-
Visual Studio 2022 Extensions Now Available for Reporting Services and Analysis Services
https://devblogs.microsoft.com/visualstudio/analysis-services-and-reporting-services-extensions-for-visual-studio-2022-are-here/?ocid=AID3031635&utm_issue=August2022 more
-
Steps for Installing SQL Server AlwaysOn Availability Groups
Prerequisites
Windows
Do not install AlwaysOn on a domain controller
The operating system must be Windows 2012 or later
Install all available Windows hotfixes on every server (replica)
Windows … more
-
Restore an existing availability group database participating in SQL Server Always On Availability Groups
https://www.sqlshack.com/restore-an-existing-availability-group-database-participating-in-sql-server-always-on-availability-groups/
https://mlichtenberg.wordpress.com/2016/02/02/how-to-restore-a- … more
-
Using the SQL Server Service Broker for Asynchronous Processing
https://www.sqlshack.com/using-the-sql-server-service-broker-for-asynchronous-processing/ more
-
Connection to SQL Server using SSL encryption
SSL connection encryption can be initiated either from the client, which can be an IIS website or Desktop application, or can be enforced at the server side. Either way, a certificate needs to be … more
-
Linked Tables from SQL Server to Microsoft Access
1) use file DSN (can be deleted after linked tables are created).
2) If using a trusted connection without a password being saved in Microsoft Access system tables, use the following template: … more