-
How to easily transfer logins between servers
During server upgrades and migration projects, you will likely run into the task or issue where you need to transfer the server logins from the previous to the new server. For non-SQL authenticated users, this is simple. But if your source server happens to have more than a handful of SQL Authentication users or you…
-
I Finally Learned How to Pivot
This may seem crazy to some of you, but so far in my career I have been able to successfully avoid learning how to use the PIVOT feature of queries in SQL. Every example I ever came upon in code someone else wrote, I was able to get the gist of what was happening in…
-
The Fastest way to Add Azure Firewall Rules
To keep resources secure in the Azure cloud environment, there are usually multiple levels of security that must be cleared for someone to be able to access a resource. For Azure SQL Databases, for example, the user who is trying to access the database must have access granted for their user account on the database…
View Older Posts
- 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 Blog Change Management Change Tracking Cloud Cloud Development CloudFormation Coffee Break Conference Cryptography Database Tools Development EC2 Elastic Compute Cloud Encryption 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 Test Data Manager Unit Testing Version Control WordPress Work Management