SQL Server and Oracle Transparent Data Encryption Differences and Similarities
In this article, we look at how to set up Transparent Data Encryption for SQL Server and Oracle along with the differences and similarities.
2022-09-21
Additional Articles
Guide to Build Graph Node and Edge Tables with Azure Data Studio
Learn how to build graph node and edge tables using Azure Data Studio in this step-by-step guide.
2022-09-19
The Lock Escalation Threshold – Part 1
This article isn’t about the act of lock escalation itself, which is already well documented and generally well understood. Some myths (like row locks escalating to page locks) persist, but challenging those yet again probably wouldn’t change much.
2022-09-19
Managing Static Data in Flyway Database Development
If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.
2022-09-16
SQL WHERE Tutorial
In this article, we look at several different examples of how to use the SQL WHERE clause to narrow down searches for data in a SQL Server table.
2022-09-16
How to Create a SQL Server Database, Tables, Foreign Keys and Data for an Application
Learn how to create SQL Server database tables, foreign keys, and create data to begin building a database to support application development.
2022-09-14
Monitoring: The ROI of Build vs. Buy
There and pros and cons to building a monitoring system versus purchasing one: in other words, the ROI of build vs. buy. In this blog post, Grant Fritchey discusses when you should build, and when you should buy.
2022-09-14
Data Visualizations for Excel Multi-Chart Sets with SQL Server Data
This article covers how to create multi-chart visualizations in Excel using data from SQL Server.
2022-09-09
Rollbacks, Undos and Undonts
Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.
2022-09-09
How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES
In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows
2022-09-07
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
BCA KCU KUNINGAN NO TELPON 087781685658
Cyber 2, Gedung Menara Karya,WHATSAPP 087781685658 Jl. H. R. Rasuna Said Ground Floor, RT.7/RW.2,...
We Are Eating Our Own Seed Corn
Comments posted to this topic are about the item We Are Eating Our Own...
BCA KCU BANDUNG
PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers