Frappe and Laravel: Database Management and Migrations
In this second installment of our series comparing Frappe and Laravel, we probe into critical aspects of database management and migrations.
2025-02-05
Additional Articles
SSMS Export to Excel
You’re running an ad-hoc query in a Microsoft SQL Server database with SQL Server Management Studio (SSMS) and need to further analyze the result set in an Excel spreadsheet. How do you export the data?
2025-02-03
How to rename a SQL Server database
There may come a time when you want to or need to rename a database. In this tip we look at a couple different options.
2025-01-31
A Practical Guide to Using Azure Key Vault in Enterprise Deployments
Key vaults define security boundaries for stored secrets. It allows you to securely store service or application credentials like passwords and access keys as secrets. All secrets in your key vault are encrypted with a software key. When you use Key Vault, you no longer need to store security information in your applications. Not having to store security information in applications eliminates the need to make this information part of the code.
2025-01-29
2 reads
Add and Subtract Dates using DATEADD in SQL Server
Date manipulation is a common scenario when retrieving or storing data in a Microsoft SQL Server database. There are several date functions (DATENAME, DATEPART, DATEADD, DATEDIFF, etc.) that are available and in this tutorial, we look at how to use the DATEADD function in SQL queries, stored procedures, T-SQL scripts, etc. for OLTP databases as well as data warehouse and data science projects.
2025-01-27
Oracle Architecture Overview
In this document I will share an overview of Oracle’s architecture that isn’t complete, but it will give you a basic understanding of how the architecture works, especially if you are coming from other database platforms.
2025-01-24
How to Install SSIS in Visual Studio 2019
This tool has always been an integral part of the Visual Studio. However, the name of this tool as well as the method of its installation varies from version to version of Visual Studio (VS). In this article, we are going to illustrate how to install SSIS in Visual Studio 2019.
2025-01-22
Demystifying Continuous Integration vs. Continuous Delivery Part 3 – Real World Examples of CI CD
This article covers examples of how some larger companies have successfully implemented CI/CD practices to transform their development processes.
2025-01-20
The Ebb and Flow of AI
Everybody’s coasting and looking back. Let’s kick our heels up, get comfortable, and talk big picture industry stuff.
2025-01-17
Five changes to SQL Server I’d love to see
I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, you know, new beginnings.
2025-01-15
Blogs
Reflections on the Life of a DBA
The DBA life is fraught with pain. Those battles that we endure are mostly...
Moving On-Prem PostgreSQL to the Cloud: Picking the Right Path for Big Tables
Every PostgreSQL migration eventually hits the same fork in the road. The database is...
A Spread of Vacation
By Steve Jones
I’m off on vacation today. Which is a little weird as I just got...
Forums
Inquiry – Enforcing ApplicationIntent=ReadOnly via GPO
Hello, I would like to ask whether it is technically possible to redirect a...
Calculating Geometric Mean in Power BI
Comments posted to this topic are about the item Calculating Geometric Mean in Power...
TempDB Facts I
Comments posted to this topic are about the item TempDB Facts I
Question of the Day
TempDB Facts I
Can I set Accelerated Database Recovery on tempdb?
See possible answers