Just Code
Using this syntax highlighter, always using the Navy-style.
All my Open Source Projects:
BDC - Most simple way to connect to Azure Data Lake Storage Gen2 — Jun 7, 2020 6:17:22 PM
Spark - Reading from Excel files, converting to parquet — Dec 19, 2019 1:37:56 PM
Spark - Microsoft SQL Server MSSQL using Windows Authentification to Parquet — Sep 17, 2019 8:32:04 AM
Nant - Property as a dictionary — Feb 5, 2016 8:15:31 AM
Batch - Automatically set JAVA_HOME to current installed version of java — Feb 4, 2016 3:32:04 PM
TSQL - Improved Parallel DML between 2008 and 2014 breaking code — Jan 12, 2016 7:40:48 AM
TSQL - Query processor could not produce a query plan because of the hints defined in this query — Nov 24, 2015 1:47:22 PM
C# - Fill DataTable using NBuilder.Net — Sep 30, 2015 8:20:16 AM
Nant - Find File By Pattern — Sep 30, 2015 6:27:03 AM
Windows 10 - Disable thumbs.db creation — Apr 9, 2015 11:13:50 AM
TSQL - Aliases for column names from Stored Procedure results — Apr 3, 2015 8:46:13 PM
TSQL - Deadlock while setting database to MULTI_USER mode — Mar 25, 2015 12:38:00 PM
PostgreSQL - Get Execution Plan as query result — Mar 6, 2015 3:00:29 PM
PostgreSQL - Partition Exclusion with now/current_timestamp/current_date — Mar 4, 2015 2:34:51 PM
PostgreSQL - Automatic Partition creation script — Mar 4, 2015 2:22:27 PM
Oracle - Only update fields where the value have actually changed. — Nov 4, 2014 2:19:17 PM
Oracle 12c - Convert scientific formatted varchar string to Number type — Oct 14, 2014 8:19:49 AM
pgAdmin - Macro to create INSERT statement for selected table — Feb 18, 2014 1:39:40 PM
SSMS - Add custom templates to Template Browser, or edit the existing templates — Feb 11, 2014 2:59:48 PM
TSQL - Data Generation toolkit, Generate large amount of data for tables easily — Feb 4, 2014 4:01:11 PM
PostgreSQL - Playing with postgresql, day 1 — Jan 24, 2014 3:16:24 PM
TSQL - How to move all database files to new location, script to move files. — Jan 23, 2014 9:41:14 AM
TSQL C# - Improving the performance of INSERT when doing many inserts to the same table by batching — Jan 21, 2014 1:01:30 PM
Postgres from MSSQL - Notes from converting database from MSSQL to PostgreSQL — Jan 20, 2014 12:54:19 PM
SQLCMD - TSQL script to run all .sql scripts in a folder — Jan 9, 2014 9:03:57 AM
TSQL - See all the locks that are taken / Acquired during a query — Jan 3, 2014 3:27:53 PM
C# - Snippet, Expected exception snippet — Dec 19, 2013 3:21:49 PM
C# - Assert that Type have no settable properties — Dec 4, 2013 12:30:16 PM
TSQL - Find which deprecated features being used by querying sys.dm_os_performance_counters — Sep 9, 2013 11:19:57 AM
C# - Find SQL server instance port number — Aug 27, 2013 1:41:33 PM
Java - Truncate the time part of a java.util.Date, removing the hours minutes and seconds etc — Jul 11, 2013 2:25:35 PM
Java - Generic Entity Comparer to check Equality of all fields — Jun 18, 2013 10:04:49 AM
TSQL - Rebuild all indexes that does not have fillfactor = X — Apr 9, 2013 2:06:04 PM
SSMS - Adding your own addin to SSMS — Mar 25, 2013 3:52:10 PM
WPF - Create a viewmodel from XAML with parameters in the vm constructor — Mar 8, 2013 3:51:53 PM
TSQL - Get name of tables in the database that have some rows — Feb 18, 2013 1:08:18 PM
TSQL - Show all the rows in all tables that are being locked right now — Feb 13, 2013 3:56:47 PM
WCF - Trace and log all incomming SOAP messages with Envelope and all — Feb 12, 2013 9:46:21 AM
WPF - Recursive DataTemplates to display graphs/trees or Recursive objects — Feb 5, 2013 9:58:37 AM
TSQL - Transaction Safe Sequence generation in SQL Server 2008 and older — Jan 21, 2013 10:35:34 AM
C# - Playing with delegate invocation list, Combine, Remove — Jan 7, 2013 1:33:27 PM
C# Snippet - Concatenate list of strings to one colon-separated string — Dec 25, 2012 10:17:28 PM
WPF - Drawing positioned boxes/shapes based on a list in MVVM — Dec 21, 2012 11:24:55 AM
DOS PROMPT - Command line to Use 7zip to compress all folders to individual archives — Nov 17, 2012 10:37:51 PM
T-SQL - An attempt to extract filter-, join- and output columns from query plan XML — Nov 5, 2012 9:42:19 AM
Postgres 9.2 - Installation on Ubuntu, including PLV8 Language, from source, resources used — Oct 29, 2012 3:36:59 PM
Postgre SQL - PLV8 functions to query complex json datatype — Oct 26, 2012 2:25:55 PM
TSQL - Execute ALL stored procedures to see if they work or not — Oct 8, 2012 2:18:03 PM
F# - Couchbase - Serialize from JSON to Generic Object and from Generic object to JSON — Oct 2, 2012 12:23:41 PM
DOS CMD Prompt - Merge multiple text files into one big file — Sep 11, 2012 8:29:44 AM
WPF - Key.Up, Key.Down commands sent from Textbox to a MVVM Command binding — Sep 5, 2012 7:26:01 AM
TSQL - Snippet example of sp_executeSql to use parameters in dynamic query — Aug 29, 2012 12:37:39 PM
TSQL - Peek into what Queries/Statements are in the query plan cache, and their execution plan if available. — Aug 29, 2012 12:09:38 PM
C# - Work around for “The remote certificate is invalid according to the validation procedure" — Jul 13, 2012 11:15:46 AM
C# - Convert any CSV file to XML file — Jul 4, 2012 3:01:49 PM
WPF MVVM - Bind command of buttons for items in a ListBox to the correct viewmodel — Jun 16, 2012 11:46:00 AM
C# - Gzip Uncompress and Compress Example using System.IO.Compression.GZipStream — May 11, 2012 8:44:31 AM
TSQL - Generate WikiMarkup for all Indexes (all key columns and included columns) — May 8, 2012 2:57:45 PM
TSQL - Find orphan jobs that does not have a target database on the server anymore — Apr 26, 2012 11:39:35 AM
C# - Asynchronous Data Access base class to retrieve data from the database without blocking the caller — Mar 26, 2012 9:46:47 PM
C# - Using Lambda instead of a separate event handler to handle events — Mar 22, 2012 11:20:49 AM
TSQL - Delete ALL data from ALL tables, with respect to foreign keys — Mar 20, 2012 12:38:17 PM
C# - Asyncronously execute an Action for a period of time and report the amount of executions when done — Mar 20, 2012 9:56:05 AM
TSQL - Generate series of numbers on the fly using this CTE, useful for data generation scripts — Mar 9, 2012 9:46:59 AM
F# - Sudoku Solver using search trees Step Seven: Increasing performance using parallel tasks — Feb 18, 2012 4:51:58 PM
F# - Sudoku Solver using search trees Step Six: Solving Sudoku — Feb 12, 2012 11:45:24 AM
C# - DbCommand factory to completely remove the dependency to any specific DB Client — Feb 9, 2012 5:14:10 PM
Git Extensions - Disable check for SSL CA Cert verification — Feb 7, 2012 12:09:06 PM
F# - Sudoku Solver using search trees Step Five: Defining the data structure for the complete problem — Feb 5, 2012 9:21:58 PM
F# - Sudoku Solver using search trees Step Four: Adding more Unit Tests — Jan 29, 2012 9:39:33 PM
F# - Sudoku Solver using search trees Step Three: Adding Unit Tests — Jan 29, 2012 8:52:50 PM
F# - Sudoku Solver using search trees Step two: The algorithm — Jan 29, 2012 12:03:28 AM
F# - Sudoku Solver using search trees Step one: Defining the data structure — Jan 28, 2012 11:56:30 PM
F# - Compare two lists, Compare two Sequences, Compare two Sets — Jan 28, 2012 10:47:19 AM
C# - Get multiple result sets from one SqlCommand query or stored procedure — Jan 25, 2012 12:34:26 PM
WPF - A simple GUI for creating SQL Connection Strings — Jan 24, 2012 2:22:46 PM
WPF - Make window size adjust automatically to its content — Jan 24, 2012 1:44:20 PM
TSQL - Service Broker error when sending message to the queue — Jan 17, 2012 9:43:45 AM
C# - Add/Send text to notepad process using user32.dll SendMessage from your application — Jan 13, 2012 9:31:37 AM
Tortoise SVN - Run Svn commands from command line — Jan 12, 2012 10:43:16 AM
F# - Generic function to query a database with dynamic return object type — Dec 30, 2011 1:24:51 PM
F# - Passing functions as a parameter to another function — Dec 30, 2011 9:46:07 AM
F# - Returning Nullable objects from a function — Dec 29, 2011 11:09:45 PM
F# - Basic Try catch pattern — Dec 29, 2011 10:48:29 PM
Powershell - Use SQLCMD to run all scripts in a folder on one target database — Dec 20, 2011 1:24:15 PM
SSMS - Regex to handle stuff copied from Excel to SSMS — Dec 14, 2011 11:49:59 AM
Tsql - Stored procedure to generate HTML table output from any query — Dec 9, 2011 10:53:22 AM
Tsql - Procedure to compare data in two tables to find missing/additional/modified rows — Dec 8, 2011 10:01:49 AM
TSQL - LEN and SUBSTRING may seem bugged but they are not, they are only very strange — Dec 6, 2011 9:34:02 AM
F# - Find the latest appearance of of a new item in a list — Dec 1, 2011 10:39:58 PM
TSQL - Storage Overhead of the SQL_Variant Data type — Nov 28, 2011 3:25:16 PM
Powershell - How to Override ToString, or any method on an object — Nov 16, 2011 1:43:03 PM
Powershell - Create new object of a custom Class using a Constructor — Nov 16, 2011 1:35:59 PM
SSMS/Visual Studio - Find Replace - Use Regex to create one task for each row in the editor — Nov 14, 2011 3:40:59 PM
Powershell - Example of using hashmaps as dynamic objects — Nov 11, 2011 9:36:51 AM
Powershell - Create Serialized XML result from database query — Nov 11, 2011 9:09:48 AM
T-SQL - Comments written on a course 2010-09-27 — Nov 4, 2011 9:58:34 AM
C# - Creating a Process, reading its console output into a textbox on a form — Nov 2, 2011 2:38:57 PM
Powershell - ONE- LINER - Add a line of code to each filtered file of a directory — Oct 31, 2011 2:03:52 PM
Powershell - Concat all .SQL Files into one big file, with GO statement in between — Oct 27, 2011 10:36:19 AM
Powershell - Replace function with ignore case — Oct 14, 2011 7:02:51 AM
Tool of the day - StExbar — Oct 7, 2011 8:20:52 AM
TSQL - Remove/Delete all SQL Server Agent jobs on your development server — Oct 4, 2011 2:35:42 PM
TSQL - Trace for deadlocks and stop the trace when deadlock occured using EVENT NOTIFICATION and SERVICE BROKER — Sep 30, 2011 9:00:40 AM
TSQL - READ COMMITTED SNAPSHOT Demo — Sep 30, 2011 8:04:13 AM
BATCH - Create a copy of a file with a date & time in the filename — Sep 22, 2011 11:29:56 AM
TSQL - Looking at locking; can you lock a row using select statement? — Sep 21, 2011 8:23:59 PM
SQLCMD - Pass in scripting variables to the script — Sep 7, 2011 8:40:22 AM
Could not start the Snapshot Agent to generate a new snapshot — Sep 5, 2011 1:54:03 PM
TSQL - Find keys and constraints that was automatically named by SMSS — Aug 24, 2011 9:37:19 AM
SQLCMD BATCH FILE - Export large XML files from SQL server using SQLCMD — Jul 7, 2011 10:59:11 AM
TSQL - Check if temp table exists, then drop it — Jul 6, 2011 6:26:02 AM
TSQL - Grant permissions on a schema for a user — Jul 5, 2011 9:16:03 AM
TSQL - Hierarchical table dependency graph based on foreign keys — Jun 23, 2011 12:47:26 PM
TSQL - Find tables that is missing some kind of contraint — Jun 21, 2011 2:37:18 PM
WPF - Cut & Copy & paste buttons in a toolbar. NO CODE — Jun 16, 2011 2:38:44 PM
SQLCMD - Run a script file with windows authentication — Jun 14, 2011 7:09:40 AM
TSQL - Set database to read only using single user mode — Jun 13, 2011 11:56:21 AM
SQL Wiki - Automatic wiki markup generator for stored procedures — Jun 1, 2011 2:00:47 PM
SQL - Extract all user created Stored procedure text from syscomments — May 31, 2011 12:11:48 PM
SQL Wiki - Automatic documentation stubb generation — May 31, 2011 7:41:58 AM
SQL - Find all constraints for a table — May 13, 2011 8:37:54 AM
SQL - Insert to a child table using values from the OUTPUT clause — Apr 28, 2011 5:47:00 PM
Entity Framework 4 - Customizing the generated data model script — Feb 18, 2011 7:34:28 AM
SQL - Performance comparison NVARCHAR(4000) vs NVARCHAR(max) — Feb 16, 2011 8:21:27 AM
C# - Read from Excel and insert to DB — Feb 11, 2011 9:55:14 AM
Talent is wasted unless practiced — Jan 10, 2011 6:29:29 PM
iPhone - Snippet to load image and add to view — Dec 17, 2010 1:29:16 PM
XCOPY - Create backup of all source code files (*.asp) from a directory and recursive child dirs — Dec 10, 2010 9:27:52 AM
T-SQL - Kurs 2 — Dec 10, 2010 8:13:28 AM
.Net - Where is machine.config? — Nov 25, 2010 4:13:10 PM
Asp.Net - Quick n Dirty download SQL result as excel file to user — Nov 16, 2010 9:38:15 AM
T SQL - stupid Password generator — Oct 15, 2010 11:56:45 AM
T SQL - Basic Inheritance — Oct 12, 2010 7:51:49 PM
Silverlight - Get Full info about WCF Exceptions — Oct 9, 2010 10:53:54 AM
Xaml Tip - Find-replace regex to remove the name attribute — Jun 18, 2010 7:17:41 AM
T SQL - Move a table to some other Schema — Jun 18, 2010 7:01:19 AM
SQL - Simple script to get referenced table and their column names — Jun 10, 2010 6:33:34 PM
Silverlight - Bind to SelectedItems of a DataGrid — May 27, 2010 8:16:43 AM
Windows 7 - How to create a directory symbolic link to a network share — May 26, 2010 9:15:13 AM
Silverlight - Delayed loading of details when selecting an item in some list — May 24, 2010 8:36:48 AM
Silverlight - MVVM Hooking up the ViewModel in the view — May 21, 2010 6:35:49 AM
Silverlight - Binded value need to be updated when text is changed, not only when focus is lost. — May 21, 2010 6:27:08 AM
T4 - Generate POCO from all tables in a database — Apr 21, 2010 1:55:05 PM
TSQL - Cool scripts to get statistics about your Databases — Apr 15, 2010 4:38:37 PM
Silverlight - Out Of Browser, automatic installation of updates — Apr 8, 2010 9:25:43 AM
Silverlight - Deploying Silverlight applications, remember the MIME types — Apr 8, 2010 8:56:32 AM
T SQL - Just some handsome code to configure a shedule — Apr 8, 2010 8:13:54 AM
Asp.Net - Change the identity/user that runs the Asp.Net process — Mar 30, 2010 2:02:21 PM
RIA services - Crazy bug with DateTime dates, crazy solution — Mar 19, 2010 12:25:32 PM
Silverlight - Let the consumers of your UserControl provide DataTemplate for parts — Mar 16, 2010 9:05:08 AM
Remote desktop - No more available sessions? — Mar 5, 2010 2:59:28 PM
.Net - Unit Testing Internal Classes — Mar 3, 2010 8:41:22 AM
C# - Dataset from XSD schema with multiple datatables in hierachy. Data from only one stored procedure. — Feb 22, 2010 8:13:34 AM
Asmx Webservices - Test forms not vissible from remote machine? — Feb 16, 2010 1:14:42 PM
C# - Class for logging — Feb 15, 2010 2:43:45 PM
C# - Create Tree structured TreeNodes data from sql rows. Use with TreeView in winforms — Feb 14, 2010 12:10:16 PM
Vb.Net - Regex Whitelist exclusion, string cleanup — Feb 14, 2010 12:02:23 PM
C# - Create XML From any SQL Query — Feb 14, 2010 11:58:52 AM
C# Asp.Net - Checkbox validation using custom validator — Feb 14, 2010 11:56:00 AM
C# EPiServer - Get Filtered PageDataCollection from codebehind — Feb 14, 2010 11:54:20 AM
C# Asp.Net - Get Id from gridview, use it to get a file from database and upload it to the user — Feb 14, 2010 11:53:09 AM
TSQL - Concat values from a column into a single string — Feb 14, 2010 11:51:26 AM
C# - Get config from non default config section — Feb 14, 2010 11:49:42 AM
C# - DataTable to RecordSet — Feb 14, 2010 11:48:46 AM
TSQL - How to get row numbers for selected rows — Feb 14, 2010 11:47:05 AM
C# Asp.Net - See html output before sending it to the client — Feb 14, 2010 11:46:05 AM
TSQL - Reset identity column value for a table — Feb 14, 2010 11:45:07 AM
C# - Tiny regex sample to get value from matched group — Feb 14, 2010 11:43:59 AM
C# - Print all fields, in a class, and their values. Excelent ToString() — Feb 14, 2010 11:42:54 AM
WPF - Update GUI from another thread — Feb 14, 2010 11:41:25 AM
Automatic build version counter for visual studio projects — Feb 14, 2010 11:40:05 AM
C# - Convert File to another Encoding. — Feb 12, 2010 2:15:16 PM
Show Hexadecimal representation of a file, neat for checking encoding of the file — Feb 12, 2010 9:49:46 AM
Dataset.WriteXml write result into a string — Feb 9, 2010 2:03:02 PM
C# - Convert List to DataTable — Feb 4, 2010 11:02:55 PM
Tsql - Use result from stored procedure in tsql script, capture it in a temporary table or variable — Feb 4, 2010 8:27:56 AM
ASMX - Odd errors after changing namespace on your code behind files — Feb 2, 2010 9:19:46 AM
Asp.Net - Register your web user controls once and for all in web.config — Jan 26, 2010 8:45:31 PM
C# - Basic SQLCommand- and SQLConnection-factory classes — Jan 25, 2010 9:00:55 AM
C# - Plugin architecture sample — Jan 25, 2010 8:31:57 AM
XmlSerialize - Serializing IEnumerable<T> with attributes at the top element — Jan 21, 2010 8:16:49 AM
EPiServer RSS Page provider — Jan 19, 2010 8:41:31 PM
EPiServer Virtual role — Jan 19, 2010 12:07:45 AM
EPiServer anteckningar från kursen — Jan 18, 2010 8:53:35 PM
EPiServer Dynamic Content rendered with usercontrol — Jan 18, 2010 7:20:19 PM
EPiServer Custom property — Jan 18, 2010 6:51:32 PM
EPiServer minimal scheduled job — Jan 17, 2010 10:42:02 PM
EPiServer Plugin web usercontrol, with access control who should be able to see it — Jan 17, 2010 10:34:34 PM
EPiServer - Adding and modifying pages from code behind — Jan 17, 2010 9:36:18 PM
EPiServer - Create an empty page to use when you only want to use it to store some data — Jan 17, 2010 9:35:10 PM
EPiServer add events to datafactory — Jan 17, 2010 9:19:44 PM
Redirect To current page with querystring and all — Jan 17, 2010 7:23:09 PM
TSQL Insert file into database from script — Jan 13, 2010 10:31:47 AM
C# get web page from code, POST and GET versions. Trying to get user agent to work... — Dec 17, 2009 9:22:54 AM
Log Changes made in database tables, not that hard as i thought — Dec 16, 2009 5:14:15 PM
T SQL, how long is that varchar? — Dec 16, 2009 5:14:09 PM
Clever, or not? date conversion to Date (use when date stored as integer) — Dec 10, 2009 8:29:36 AM
Organize your servers and services, Hierarchical management of arbitrary nodes — Dec 8, 2009 3:07:57 PM
ASP.Net - Simple - Generate image dynamically in codebehind — Dec 7, 2009 1:13:33 PM
TSQL Minutes from midnight — Dec 6, 2009 9:38:53 PM
Be carefull with check constraints on columns that can be null — Dec 2, 2009 4:52:21 PM
SQL Split function for very large input string — Nov 23, 2009 11:42:24 AM
Configure a list of emails in app/web.config — Nov 20, 2009 7:55:16 AM
Can i has Task Management System? — Nov 2, 2009 1:15:47 PM
TSQL - Från kursen — Nov 2, 2009 1:15:22 PM
Upgrade from vb6 to vb.net wizzard, to many damned Upgrade warnings? No problem — Oct 23, 2009 12:20:06 PM
T-SQL: The difference between @@identity, scope_identity(), and ident_current() — Oct 22, 2009 9:24:30 AM
Linq To XML Inline Loop to add elements — Oct 19, 2009 2:47:23 PM
Silverilght - Changing Template on selected Item in a listbox — Oct 6, 2009 6:38:09 AM
How to get NUnit to read the correct Web.config when working with Web or WCF projects — Sep 30, 2009 11:16:48 AM
TSQL - Use this as check constraint on a field to prevent having overlapping dates in a table — Sep 10, 2009 7:46:40 AM
F# Mandelbrot, stolen from someone — Sep 9, 2009 9:16:30 AM
F# Sieve of erastothenes, two versions: List and Seq. Interesting performance differences — Sep 9, 2009 9:12:28 AM
Regex to remove annoying google-url from google sites — Sep 9, 2009 9:08:01 AM
Save DataSet to comma separated file — Sep 7, 2009 7:27:51 AM
VBA Move mail to another folder — Sep 7, 2009 7:17:02 AM
Återställa backup på databas som används av massa andra users — Sep 7, 2009 7:13:42 AM
VBA Script create a link to current selected item and copy to clip board — Sep 7, 2009 6:43:49 AM
Extension on IList<T> on specific interfaces — Sep 7, 2009 6:41:56 AM
Static functions are thread safe if they do not modify any other variables than those they create themself — Aug 28, 2009 2:16:58 PM
C# Create Random Password with select set of available characters — Aug 27, 2009 5:34:46 PM
Notify when screensaver starts running — Aug 27, 2009 1:47:45 PM
C# Width/Depth first tree search soduko solver — Aug 27, 2009 9:21:12 AM
Erlang - Gissa talet — Aug 27, 2009 8:25:23 AM
T SQL - How to get row numbers from select query — Aug 27, 2009 8:23:58 AM
T SQL - Select contents of a column into a comma separated string — Aug 27, 2009 8:18:26 AM
Sieve of Eratosthenes — Aug 27, 2009 8:11:44 AM
Regex för att plocka ut en grupp ur en sträng — Aug 27, 2009 8:10:47 AM
Uppdatera GUI från en annan tråd i WPF — Aug 27, 2009 8:09:44 AM
Timer för att räkna arbetstid — Aug 27, 2009 6:25:45 AM
Tagga fil med prefix — Aug 26, 2009 4:34:16 PM