SQL Server
-
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
-
Securing a Microsoft Access Database
https://www.techrepublic.com/blog/10-things/10-tips-for-securing-a-microsoft-access-database/ more
-
Access Front End to SQL Server Back End
https://social.msdn.microsoft.com/Forums/en-US/85757ab1-250e-460a-9e51-5a17516c5524/how-to-create-an-odbc-connection-for-runtime-access-to-sql-server-database-tables?forum=accessdev
https://support. … more