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
Articles
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
How to visualize Python charts in Power BI Part 2
This article continues looking at python code in Power BI to produce charts.
2022-09-12
6,067 reads
Understanding the System Function FILEPROPERTY()
Learn how to use the system function, FILEPROPERTY(), to get information about your database in T-SQL.
2022-09-09
4,317 reads
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
SQL Ledger: Protecting Data in Azure SQL
Learn how you can set up and use Ledger tables in an Azure SQL Database to verify the integrity of your database changes.
2022-09-07
9,828 reads
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
Introducing the MySQL SELECT statement
Use SELECT statements to query a MySQL database. In this article, Robert Sheldon explains how.
2022-09-07
The "Numbers" or "Tally" Table: What it is and how it replaces a loop
Many people have used a "Numbers" or "Tally" table without really knowing what it does. This is an introduction as to how a Tally table replaces a loop.
2022-09-05 (first published: 2008-05-07)
157,437 reads
Blogs
Audit – Security Compliance Frameworks (Part 1)
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
Restore SQL Server Database to an OrbStack Container
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
Day of Data Baton Rouge Slides and Code
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Forums
ALAMAT BCA KCU KUNINGAN Telp 08218200174
Via WhatsApp+62 821-8200-174 Cyber 2, Gedung Menara Karya, Jl. H. R. Rasuna Said Jl....
ALAMAT BCA KCU PURI INDAH Telp 08218200174
Via WhatsApp+62 821-8200-174 Gedung C3 Lt. 1-3 Komplek, Jl. Puri Indah Raya No.1-3 Blk...
SQL 2025 SSMS Nonsense
Yeah, I know this is a 2022 forum, but I don't see a 2025...
Question of the Day
SQL Server Certificates
Which of these is not true for certificates used for SQL Server connections?
See possible answers