skip to content

Trace

Sitemap

This is a sitemap over all available pages ordered by namespaces.

ad
adf
admin
azure
blog
cookie
cosmos
crib
csharp
dax
dokuwiki
dos
edge
excel
fabric
git
github
internals
linux
npp
odbc
pbi
php
playground
powershell
projects
spark
sprockit
ssas
ssdt
ssis
ssms
ssrs
subversion
synapse
tsql
- xml
- 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
vs
wiki
windows
Blog
canyoujust
contact
My CV
DokuWiki
Function equivalents
About me
Microsoft Data Platform User Groups in the UK
Find me
Sitemap
Speaking
sprocket
Sprockit
sprockitviz