Open VPN Software
https://openvpn.net/community-downloads/
Author
Deploy SSIS Package to SQL Server from .dtsx package file
Open up SSMS -> Connect Integration Services… (Administration mode) Expand the “Stored Packages” folder -> MSDB folder -> right click and select “Import Package” Package location: File System Package path: C:\Deployment\MyPackage.dtsx Package name: MyPackage Protection level: Keep protection level of the original package Note: If package already exist in the MSDB, will get a prompt... » read more
Install SSL Certificate on Azure Web App
To secure your site, extract the files from STAR.mydomain.com_cert.zip and STAR.mydomain.com_key.zip on your computer and upload them to your server. Here is a list of the most common server types and how to install SSL on them. If you created a CSR and private key in-browser during SSL activation, you will find key.zip in your downloads folder. How to install an... » read more
Custom Database Maintenance Scripts for Backup, Integrity Check, and Index
https://ola.hallengren.com/
An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found: msoledbsql.msi
Error: Error Description: An installation package for the product Microsoft OLE DB Driver for SQL server cannot be found, Try installing again using a valid copy of the installation package ‘msoledbsql.msi’ Fix: Uninstall all OLE and ODBC drivers and re run the setup. References: https://stackoverflow.com/questions/71857345/error-when-installing-microsoft-sql-server-2019-cannot-find-the-microsoft-ole-d
How to Think Like the SQL Server Engine – Brent Ozar Unlimited®
How to Think Like the SQL Server Engine – Brent Ozar Unlimited® You’re a developer or a DBA, and you’re comfortable writing queries to get the data you need. You’re much less comfortable trying to design the right indexes for your database server. In my totally free How to Think Like the Engine class, you’ll... » read more
Brent Ozar Training
Homepage | Brent Ozar Unlimited Brent Ozar Unlimited Level 2 Bundle | Brent Ozar Unlimited The BrentOzar.com Annual Black Friday Sale – Brent Ozar Unlimited® You’ve used sp_Blitz and the First Responder Kit to learn a lot about your databases. You read the blog regularly, subscribed to the free newsletter, watched some of my YouTube videos, maybe... » read more
Changing Database Column Order
Issue: Changing the order of database table columns. Resolution: Have to re-create the table in order to change the order of the database column. Right click on table -> Designers -> Re-arrange table column -> Save Note: Make sure the “Prevent saving changes that require table re-creation” is unchecked. Change this my going to SQL... » read more
Microsoft Bing AI
www.bing.com/chat
How to send a dynamic email from Sendgrid with dotnetcore
https://www.vivienfabing.com/dotnetcore/2019/04/14/how-to-send-a-dynamic-email-from-sendgrid-with-dotnet-core.html