Documentation Starting with SQL Server 2016 (13.x), there is no limit on the size of memory-optimized tables, though the tables do need to fit in memory. Memory tables in SQL Server are pretty close analogs to Redis [https://redis.io/topics/lru-cache] [https://redislabs.com/try-redis-cloud-essentials-for-a-free-shirt/?utm_source=google&

Trying out some things and writing and compiling a type in Powershell PS C:\Users\siliconrob\Desktop> $MyCode = @" $MyCode = @" >> public class Calc >> { >> public int Mul(int a,int b) >> { >> return a*b; >> } >> } >

This is a helper post to understand that denormalized [https://www.geeksforgeeks.org/difference-between-normalization-and-denormalization/?ref=rp] data created with joins and in particular left joins or cross apply [https://www.mssqltips.com/sqlservertip/1958/sql-server-cross-apply-and-outer-apply/] can be rolled up with the proper use of GROUP BY [https://www.sqlservertutorial.net/

I completely agree with the sentiment here. The stand-up meeting is a good way to lose focus for a team especially if you are distributed and remote. If you can use Basecamp then I would suggest that, but if you are not use an automated standup bot in your slack

I wanted to generate an 8 character web compatible (base64 [https://en.wikipedia.org/wiki/Base64] encoded) id that is fairly easy to type or memorize from SQL, so came up with this inspired from this Postgres [https://blog.andyet.com/2016/02/23/generating-shortids-in-postgres/] approach SELECT randomId from openjson(

This project [https://github.com/oriches/faker-cs]although popular on nuget [https://www.nuget.org/packages/Faker.Net/] for downloads appeared to have been for the most unmaintained as the last update to the nuget package had not occurred in approximately in almost 2 years  and before the last update

Copied from StackOverflow [https://stackoverflow.com/questions/22948927/update-stored-procedure-on-multiple-databases] -- put the entire stored procedure code in a variable -- have it start with "PROC" so we can easily either create or alter the -- procedure based on whether it already exists or not DECLARE @sp_code NVARCHAR(

MS SQL Server I want to generate a table with 1,000,000 sequential ids because I am wasteful and scourge upon humanity Step 1 - Create temp table Step 2 - Use recursive Common Table Expression with UNION ALL Generate the range with the SELECT n+1 FROM t

Create a doskey [https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/doskey] macro file: ls=dir /q $1 ip=ipconfig $* np=notepad++.exe vs=devenv * Copy this file to a specified location e.g. c:\utilities * Open the a command prompt * Edit the Shortcut tab, under Target * Copy the following

Open three query windows like so select request_session_id, resource_type, request_mode, request_status from sys.dm_tran_locks where request_session_id in (64, 65) Use this query to determine the locks showing request_session_idresource_typerequest_moderequest_status64DATABASESGRANT65 DATABASESGRANTI'm using the AdventureWorks2017 database available

Used this code to trick a security scanner into trusting an input. The security scanner builds a trace of an input into a function and does not trust modification of the input without revalidation. If you have a connection string located in web.config [https://docs.microsoft.com/en-us/iis-administration/

​ Objective: Test provide meaning and are actionable ​ This means that all components that encompass at the level of the test { Unit [https://en.wikipedia.org/wiki/Unit_testing], Integration [https://en.wikipedia.org/wiki/Integration_testing], Application/Acceptance [https://en.wikipedia.org/wiki/Acceptance_testing] } provide detailed information within the

Have denomralized data with duplicate data within a table.  Use a Common Table Expression [https://www.essentialsql.com/introduction-common-table-expressions-ctes/] or With clause to construct to constructive a recursive temporary referenced resultset from the original larger query source to return an in place grouped and distinct set that can then be

Hashing algorithms [https://docs.microsoft.com/en-us/dotnet/api/system.security.cryptography.sha512?view=netframework-4.8] work with byte values and as such to develop a consistent hashing algorithm across disparate code bases you need to be consistent with your byte encodings [https://docs.microsoft.com/en-us/dotnet/api/system.

Normally I would do this with cURL [https://curl.haxx.se/]and jq [https://stedolan.github.io/jq/] Download random image or a pet from an API providing a url path to an image file * First part is get the current time specifically the second. * Divide the second by 2

Selecting random row and or random sample from SQL and previous format use like so using the ORDER BY with the random Unique Identifier for each row randomly arranges the rows and then SELECT TOP 10 PERCENT * FROM MyTable ORDER BY NEWID() Now use tablesample [https://docs.microsoft.com/en-us/

Saw this online and then thought about it more and it cuts to the representation of numbers in bytes in binary quite clearly. Given that you have two numeric variables how do you swap the values? let firstNumber = 1; let secondNumber = 2; Output > let firstNumber = 1 > let secondNumber

Wanted to get the size of files in a folder, in this particular case all the csv [https://en.wikipedia.org/wiki/Comma-separated_values] files, and came up with this after reviewing what others had done. * First find all the csv files in a particular location: find  *.csv [http://man7.

Messing with tags and needing to find the latest Windows + PowerShell git tag --sort=-authordate:iso8601 | Select -First 1 * First part reference the git tag [https://git-scm.com/docs/git-tag] * Pass a sort parameter in this case the authordate in ISO8601 [https://en.wikipedia.org/wiki/ISO_8601] (the one

Need to find a column across several databases on a particular server and there were a lot of databases so used this query to build a temp table that holds the found metadata for the particular SQL Server. Need to construct dynamic sql [https://www.sqlservertutorial.net/sql-server-stored-procedures/sql-server-dynamic-sql/] statement

Needed to replace a nullable [https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/] column in a database with a non nullable [https://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-alter-column/] column that.  In this case a boolean field needed to transition so came up with this to alter the structure it.  The following statement does

Code complexity has categories Technical: The domain of knowledge or in this case business or scientific rules and baselines that are needed to satisfy the conditions of the problem. * Example 1: Tax laws being codified into software * Example 2: Gravity calculation and or light calculations when performing astronomical simulation and

Tagging a release and I am documenting the steps and commands I use to do this git pull git describe --tags $(git rev-list --tags --max-count=1) git tag "next_tag" git push --tags git pull Pull down [https://git-scm.com/docs/git-pull] the latest and synchronize git rev-list

The Dapper [https://github.com/StackExchange/Dapper] project is a database tool that makes working with SQL [https://en.wikipedia.org/wiki/SQL] in .NET [https://dotnet.microsoft.com/] projects in a clean and understandable manner when you know SQL [https://en.wikipedia.org/wiki/SQL]. As an open source