T-SQL View Definition
How to get a View Definition in SQL Server.
Posts by Category
- MSSQL 16
- Python 8
- Algorithns 8
- C# 8
- Metadata 3
- GIS 3
- SQLite 2
- GIT 2
- Power BI 2
- PHP 2
- Purview 2
- Agile 1
- Kimball 1
- Database 1
MSSQL
T-SQL TCP Configuration
How to set TCP Network Configurations in SQL Server.
T-SQL: Display Pipeline Progress
How to display the progress of a pipeline in MS SQL Server.
Testing Object Existence in SQL Server
How to support idempotency by testing if an object exists.
ColumnID vs Ordinal Position in Sql Server
How to get SQL Server properties that are not in the information schema.
Unit Testing in SQL Server
How to unit test database objects with T-SQL.
Get a Table Definition in SQL Server
How to use a user-defined table type to create a table that can store the output of a query.
Generate Stored Procedures in SQL Server
How to automate the creation of stored procedures from models with just a table or two.
Hashing Records in SQL Server
How to fingerprint table contents to dectect unique records.
Column Transformations in SQL Server
How to use copy and reformat transformations from one table to another.
Tsql Get Date Key From Date
When working in Business Intelligence or data engineering it is often necessary to use a date key instead of a date value. We can do this by converting date ...
Dynamic SQL with ASCII in SQL Server
Dynamic sql can feel like viewing a photographic negative. Using ASCII symbols can keep things manageable when working with double- or triple-negatives.
Record Transformation History with JSON in SQL Server
How to use JSON strings to detail the data transformations that have been applied to a record using T-SQL.
Reseed an Identity Column in SQL Server
How to use dynamic sql to reseed the identity column in a staging table to be one value higher that the top value in the target table when switching partitio...
Verify Parameterised Table Names in SQL Server
Prevent SQL injection by verifying input values against metadata in SQL Server.
Information Schema Columns in SQL Server
When lost in data space, it can be handy to find a column in a hurry from the information schema.
Python
GUI Widgets
How to use Tkinter widgets to create a GUI for a Python application.
GUI Introduction
How to use Tkinter to create a GUI for a Python application.
venv: Python virtual environment
How to setup and use venv to create virtual environments in Python.
Connect to an Azure SQL Database using Python
How to connect to an Azure SQL database using Active Directory with MFA.
Resume a Django project with Python
How to reactivate the virtual environment and restart the server using the Powershell terminal when returning to a Django project.
Using the VS Code PowerShell Terminal to Run Unit Tests with Python
How to solve the “ModuleNotFound” error when running Python’s from terminal unittest within a project folder structure, according to Zed Shaw.
Getting Started with Python
“All you need is a simple text editor, a shell, and Python” according to Zed Shaw.
Stack Postfix Expressions in Python
How to get Python to do some maths for us.
Algorithns
Algorithms 08: Graphs
How to analyse and implement graphs in Python.
Algorithms 07: Trees
How to analyse and implement binary search trees and traverse them in Python.
Algorithms 06: Sorting
How to analyse and implement quadratic and logarithmic sorting methods in Python.
Algorithms 05: Searching
How to understand and implement sequential search, binary search, or hashing in Python.
Algorithms 04: Recursion
How to analyse and implement recursion in Python.
Algorithms 03 Linked Lists
How to analyse and implement linked lists in Python.
Algorithms 02: Stacks and Queues
How to analyse and implement stacks and queues in Python.
Algorithms 01: Analysis
Understanding asymptotic analysis and big-O notation.
C#
C# 13: Forms: File Opening and Saving
How to open and saving files in C# forms.
C# 12: Forms: List, Check, and Radio Buttons
How to Use List, Check, and Radio Buttons in C# Forms.
C# 11: Forms and Controls
How to use forms and controls in C#.
C# 05: Methods
How to use methods in C#.
C# 04: Data Structures
How to use arrays, collections and structures in C#.
C# 03: Files Reading and Writing
How to read and write files with C#.
C# 02: Program Flow
How to use program flow with C#.
C# 01: Types and Variables
How to use data types and variables in C#.
Metadata
Describing Database Objects
How to write table and column descriptions to support data validation.
Map Oracle to Information Schema
How to map Oracle DBA tables to an Information Schema.
Map Oracle, SQL Server, and Postgres Data Types
Any data warehousing operation crossing source systems is probably going to need to map data types across the source systems if they are all to land in the s...
GIS
Geospatial Information Sytems
What is GIS?
Geodatabases
What is a Geodatabase in ArcGIS?
PostGIS maptiles
How to build maptiles in Postgres with PostGIS.
SQLite
SQLite Table Info
How to Get Table Information in SQLite.
Query Json Strings
How to store and query strings in json format in SQLite.
GIT
Rename a File
How to Rename a File Using the Git Command Line.
Getting Started with Git
How to use a feature branching workflow in Github.
Power BI
Power BI Datasets from Data Flows
How to edit a power query (m) to reference dataflow names rather than guids.
Power Query Data Flows
How to edit the auto-generated code to make a dataflow maintainable and deployable.
PHP
PHP 02: Data
How to work with data in PHP.
PHP 01: Introduction
Introduction to PHP.
Purview
Purview Permissions 2: Tenant-Level Permissions
How to apply tenant-level RBAC in Microsoft Purview.
Purview Permissions
How to apply RBAC in Microsoft Purview.
Agile
User Stories and Acceptance Criteria
How to write user stories and acceptance criteria that help bridge the gap between business analysts and developers.
Kimball
Slowly Changing Dimensions
How to apply Slowly Changing Dimensions with the Kimball method.
Database
Introduction to Databases
Understand key concepts in database systems.