-
Deploying A DACPAC to Azure SQL Server
One of the easiest ways to duplicate SQL Server database objects from one database to another–such as in a situation where you want to copy the structure of a production database down to a development database to help with testing and development–is to create a file called a DACPAC from the database you want to…
-
A Fun SQL Function — QUOTENAME()
I have a short post today because I’ve gotten a little behind on my editing and want to get something out today. This week, I learned about the most useful little string function available in SQL Server that I wish I had known about previously. The function is QUOTENAME()which isn’t the most intuitive name for…
-
Moving Data Between Azure SQL Databases–the Fast Way
I have done more database creation in the past couple weeks than I had done in the previous year combined, all because my team is working on making several different AI chat bots for our business users and we are being very agile about our development process. At first we had separate Azure SQL Databases…
View Older Posts
- March 2025
- February 2025
- January 2025
- November 2024
- October 2024
- September 2024
- July 2024
- June 2024
- May 2024
- April 2024
- March 2024
- February 2024
- January 2024
- December 2023
- November 2023
Posts by Tag
ACloudGuru AI Artificial Intelligence AWS AWS Certifications Azure Azure SQL Database Blog Change Management Change Tracking Cloud Cloud Development CloudFormation Coffee Break Conference Cryptography Database Tools Development EC2 Elastic Compute Cloud Encryption ETL Fernet Git Google Google Maps Local Microsoft SQL Server Oracle Organization Postgres PostgreSQL Productivity Python RDS Red-Gate SQL SQL Prompt SQL Server Management Studio SSMS Stress Management Study Version Control WordPress Work Management