Sitemap

ad
- Searching Active Directory
adf
- Access Google Analytics with Azure Data Factory
- Automate integration tests in Azure Data Factory
- Azure Data Factory, the ADF UX and Git
- Calculating Azure Data Factory test coverage
- ADF Expressions
- Extract data from Google Analytics with Azure Data Factory
- Get Metadata recursively in Azure Data Factory
- More Get Metadata in ADF
- Google Analytics API pagination in Azure Data Factory
- Isolated functional tests for Azure Data Factory
- Parameterising the Execute Pipeline activity
- Argument {0} is null or empty. Parameter name: paraKey
- Set up automated testing for Azure Data Factory
- Testing Azure Data Factory in your CI/CD pipeline
- Unit testing Azure Data Factory pipelines
- What constitutes ADF pipeline failure?
- Why automate ADF pipeline testing?
admin
- SQL Server Backup and Restore
- Caching stored procedure results
- Default fault
- Enable remote connections to SQL Server
- Extract linked server passwords
- Identify long-running queries
- Moving tempdb's database files
- Ownership chaining
- Rebuild indexes
- Remote desktop connections
- Search module definitions
- Show running queries
- Show SQL Service Accounts
- Simple message logging
- SQL agent job history
- SQL Agent job session
- SQL Server configuration manager
- SQL Server services
- Summarise indexes
- Summarise space usage
- System profile
- Useful extended events objects
- Which wireless access point am I connected to?
azure
- Catch-22: Automating MSI access to an Azure SQL Database
- Azure CLI
- Azure Cloud Shell
Blog
- A tale of two smartphone apps
- Automate to replicate
- Breaking the rules
- Can you just...?
- Infrastructure as nearly-all-code
- Metadata-driven SQL code generation
- DevOps for SQL databases
- The Ice Cream Van of Abstraction
- The under-appreciated Start → Run
- Time capsule
cookie
- banner
- Cookies
cosmos
- crib
crib
- Cosmos DB cribsheet
- Cribsheets
- Databricks cribsheet
- Git cribsheet
- Linux cribsheet
- Power BI cribsheet
- PowerShell
- Python cribsheet
- Spark cribsheet
csharp
- async/await
- touch
dax
- DAX function reference
DokuWiki
- DokuWiki syntax highlighting
- Double-click code block selection
dos
- Clear printer queue
- Installer
- Symbolic links
edge
- Stop edge crashing when opening PDFs
excel
- Auto-group entries in Excel
fabric
- Unreliable logging in data factory pipelines
git
- crib
- Git hooks for Windows
github
- From Azure Pipelines to GitHub Actions
internals
- Inspecting database file contents
- Query processing phases
- SELECT binding order
linux
- .bashrc
- crib
- curl
- vim
npp
- Indentation
odbc
- 32-bit ODBC drivers on 64-bit systems
- Excel source data types
pbi
- Better version control for Power BI datasets
- Create Power BI deployment pipelines automatically
- crib
- Deploy TMDL semantic models to Power BI
- Extract tabular model from PBIX file
- Pro DevEx for Power BI
- Publish automatically to Power BI environments with Azure DevOps pipelines
- Reusable deployment pipelines for Power BI
- Working with multiple Power BI dataset environments
php
- Debugging PHP
PlayGround
powershell
- Allow local scripts
- PowerShell profile
- Script template
- Which version of PowerShell am I running?
projects
- DbScout
  - samples
    - mediawiki
spark
- Two-aggregate pivot
Sprockit
- dd
- v1.3
- v1.4
- v1.5
- Configuring processes in Sprockit
- Custom logging with Sprockit
- What's different about Sprockit?
- Get Sprockit
- Sprockit FAQs
- Maintaining indexes using Sprockit
- Introduction to Sprockit
- Sprockit ETL pipeline visualisation
- ETL process lineage tracking with Sprockit
- Restart and rewind
- sprockitviz
- Sprockit tutorial
- Sprockit utilities
ssas
- Merge conflicts in tabular models
ssdt
- SQL database project (SSDT) merge conflicts
ssis
- Adding row numbers to SSIS data flows
- Allow loop iterations to fail
- Catalog deployments
- Project & package parameters in the SSIS catalog
- Errors in script tasks and components
- Package execution log
- get_error_detail
- Loading Excel files with SSIS
- Loading external assemblies in SSIS script tasks
- Package configuration files
- Row diversion on error
- SSIS data types
- Timestamp expression
ssms
- Mapping keyboard shortcuts in SSMS
- Saving changes to tables
ssrs
- Code element in SSRS
- Report execution time
subversion
- Missing TortoiseSVN icons
synapse
- com.microsoft.cdm for Synapse Spark v3.4
tsql
- xml
  - JSON and Jira
  - RiO dropdown field bindings
- Add a column to a table
- Bitstring/bitmask encodings
- Calculating age in SQL
- Catching multiple errors
- CONVERT date formats
- Count NULLs
- Count rows in every table
- Creating system stored procedures
- Crontab
- Currency codes
- Cursors
- Detecting RPC timeouts
- Drop default constraint
- Dropping temporary tables
- Find foreign keys referencing a table
- Fun with column metadata
- Get column metadata
- How much code have I written?
- A note about the behaviour of the IDENTITY property
- Line termination literals
- List columns in a temporary table
- Local DB
- Locks
- Managing extended properties
- MERGE boilerplate
- Numbers table
- Ordered string split
- Print big
- REPLACE <pattern>
- Roll your own bitmasks
- Scale Azure SQL DB
- Searching Active Directory from TSQL
- Sentence case formatting
- String concatenation as an aggregate operator
- Table compare
- Table partitioning
tsqlt
- tSQLt call stack
- tSQLt table tests
vs
- Configure Visual Studio
wiki
windows
- hosts
- Missing top of screen?
- Recover offscreen windows
- shutdown
- Snipping tool
- Windows terminal
- Toolset
- Touch screen setup
canyoujust
contact
My CV
Function equivalents
Microsoft Data Platform User Groups in the UK
Find me
Sitemap
Speaking
sprocket
sprockitviz