Skip to content

60 Second Dev

60 second software development tutorials and demos, and short blog posts.

  • Blog

60 Second Dev

60 second software development tutorials and demos, and short blog posts.

  • Blog

60 Second Dev

60 second software development tutorials and demos, and short blog posts.

Category: sql server

2021-08-112022-05-24sql server

GZip CLR Functions

Looks like SQL Server 2016 finally introduced a COMPRESS function. If you’re not quite […]

2021-08-112022-05-31sql server

Cursors in SQL Server

Here’s my preferred syntax for a simple one-way readonly cursor: It uses […]

2021-08-112022-05-31sql server

Cursor for update in SQL Server

When you’re working through a cursor, if you need to update each […]

2021-08-112022-05-31sql server

Case-sensitive column in SQL Server

To make a column case-sensitive instead of the default case-insensitive, just add […]

2021-08-112022-05-31sql server

Disable all constraints

Sometimes you just need to disable all constraints on a database. Maybe […]

2021-08-102022-06-03sql server

Basic XML Examples in SQL Server

Select values from an XML column id FooID FooText 1 34 some […]

2021-08-042022-06-11sql server

GUID nonclustered index

Need a globally unique key for a table, but don’t want to […]

2021-08-042022-06-12sql server

Base-64 conversion in SQL Server

2021-06-232022-01-14sql server

View Job History in SQL Server

create procedure util.ViewJobHistory( @ExecutionDate date = null ,@JobName sysname = null)asbegin declare […]

2021-06-232022-01-14sql server

SQL Server Flatten and Unflatten

Assuming you have a table type named SingleColumnText which contains (obviously) a […]

Posts navigation

Previous 1 2 3 … 5 Next
  • RSS Feed
  • GitHub
  • LinkedIn
  • Twitter
  • YouTube

.net asp.net async audio aws azure batch brotli browser c# cloud config cryptography css csv dependency injection email entity framework git guid gzip handlebars html images javascript jquery json jsonp linq linux mercurial mvc nodejs pdf records scss serialization sqlite sql server temporal tables tfs typescript windows wsl xml

If you learned something today

Buy Me a Coffee

© 2022 60 Second Dev. Proudly powered by Sydney