
Image from Pexels
Tagged articles - SQL Server
Found 18 articles tagged with SQL Server
19
Dec
2020
Setting up SQL Server IDistributedCache with migration in ASP.NET Core
.NET219 titlesEmbedding SQL Server caching in a project with EFCore migration
0
Caching data using Microsoft SQL Server may not be the most popular way of caching data because of the performance comparing to caching data to Redis, but it is maybe the most convenient way to keep your state of the application outside the process itself. Beside, if you are already using SQL Server database, you can just move the caching infrastructure to a separate schema inside the same database and keep using it until requirements are met for cache storage of better performance (like Redis for example).
This makes infrastructure not so complex and less dependent, again until the requirements for something faster are met.
...read more
24
Nov
2020
Running multiple queries at the same time in EF Core
.NET219 titlesOvercoming the limitation of EF Core query execution
0
Since the time of ADO in .NET one of the limitations was that one connection can execute single command at the time. Same limitation Entity Framework inherited and you can execute single command at the time per instance of your DbContext.
Typical dependency injection lifetime of DbContext is scoped, which means you can execute one command at the time as the DbContext is instantiated per HTTP request in ASP.NET Core application.
...read more
06
Sep
2020
Seeding data in EF Core using SQL scripts
.NET219 titlesAnother way of seeding data in EF Core
0
Not so while ago I wrote an article on Seeding data with Entity Framework Core using migrations. This approach relies on EF Core migrations to ensure seeding of specific data is done only once using __EFMigrationsHistory table to track structural migrations as well as data seeding migrations.
In large number of cases this approach works just fine and you do not need to do any adjustments or add any additional tables, just use migrations mechanism out of the box...read more
23
May
2020
Identifying opened connections for the specific application in SQL Server
SQL/T-SQL9 titlesConnection listing queries in SQL Server
0
Object relational mappers or ORMs are a great tool which can significantly reduce application development time, but if they are not use wisely they can cause bottlenecks and performance issues.
Same goes for dependency injection containers. The lifetime of the components, especially the ones that can cause recurse locks like SQL Server connections must be as short as possible and they should be released as soon as work is done.
...read more
05
May
2020
Using Polly for retrial policies with Autofac
.NET219 titlesConfguring and using Polly with with pretty much anything
0
Some time ago I wrote an article which explains how to Increase service resilience using Polly and retry pattern in ASP.NET Core. This is a great way how to easily implement retrials when using .NET Core dependency injection, but in case of using Autofac with .NET Framework 4.x you do not have many out of the box solutions. However, Polly as a library is not specifically built for .NET Core and using it with other dependecy injection packages such as Autofac is fairly easy...read more
04
Jan
2019
SqlBulkCopy object collection to database table with C#
.NET219 titlesPerforming SqlBulkCopy with collection of objects as a source data
0
Over the time various techniques to manipulate database data have evolved in .NET. Entity Framework is certainly the most advanced one, but for small ad hock applications where you have few inserts to deal with, ADO is still the fastest way to write data to the database...read more
18
May
2018
Seeding data in Entity Framework Core from Visual Studio
.NET219 titlesInsert sample data from Visual Studio IDE with EF core
0
Unlike Entity Framework 6, EF Core and whole .NET Core relies on dependency injection. For example, configuration is expected to be injected from the calling assembly instead of being available at any time.
This is one of the reasons Migrations in Code First approach do not work out of the box for EF Core...read more
03
May
2018
Reading JSON data in T-SQL on SQL Server
SQL/T-SQL9 titlesExtracting values from JSON string on SQL Server using T-SQL
0
JSON is the most commonly used data fromat nowdays. It is lighter than XML, more readable and it's sindax complies with most OOP C-Like lnguages such as Java, JavaScript and C#.
There is not really many downsides of using JSON, so that is one of the rasons everyone is using it in one way or another.
...read more
28
Apr
2016
Create XML/HTML with T-SQL
SQL/T-SQL9 titlesGenerating XML/HTML output in SQL Server
0
Sending email from SQL is not a difficult to achieve, but generating rich HTML content might be. SQL Server itself is not built as a text processor, first approach would be to build HTML by simple concatenating the string elements.
This approach will work, but over time it will become more and more difficult to maintain especially if you need to add layout elements over time.
...read more
03
Jan
2016
SqlBulkCopy with model classes in C#
.NET219 titlesUse SqlBulkCopy with model (POCO) classes in C#
0
So far (based on my experience) the fastest way to insert big number of records from application to database is to use SqlBulkCopy. The downsize of this is that SqlBulkCopy uses DataTable instace as an input parameter which is not so convenient when dealing with models which are strongly typed and a lot more easy to use than iterating through the DataTable.
Since SqlBulkCopy accepts DataTable for insert you can not use models directly to insert your data...read more
24
Nov
2015
IP address to octets split in TSQL
SQL/T-SQL9 titlesSplit IP addresse into octets in SQL Server
0
In case you need to handle IP addresses in SQL, they are not much useful as string values. To do anything with them rather then just storing and retrieving (checking the ranges for example) you need to split IP address to segments (octets).
The following is modified method I run into online.
...read more
20
Jul
2015
Getting first and last second of the current year, month and day
SQL/T-SQL9 titlesUsing minimum and maximum date time in SQL query
0
Probably the most common error developers make in queries is dealing with date ranges and most of the time it is because of missing the minimum and maximum time of the specific date.
Month
...read more
13
Apr
2015
Dealing with duplicate rows in SQL Server
SQL/T-SQL9 titlesFinding and cleaning up duplicate rows in SQL Server tables
0
In case your data in tables needs to have unique constraint based on more than one value in the row, the proper solution for that would be a composite key.
...read more
12
Mar
2015
Reducing the number of Stored Procedures for the Application
SQL/T-SQL9 titlesApproach to reduce number of stored procedure for the application
0
Nowadays, in the years of ORM, barely anyone thinks about stored procedures, but they are still there and accessing and reading data with ADO and SqlDataReader ist still the fastest way.
Stored procedures are validated, parsed and compiled in SQL server, so these steps are not required to be performed versus plaint text query (which is what entity framework generates for accessing data).
...read more
01
Mar
2015
Super lightweight Data Access Layer returning models from ADO
.NET219 titlesReturn strongly typed objects directly from stored procedure calls
0
Entity framework is an awesome tool for working with database in .net, but sometime you have to get back to old fashion ADO for the performances. The bad thing is that as soon as you get back to ADO, you have to deal with SqlDataReader, DataTable and DataSet classes...read more
.NET
26
Mar
2021
Generic type controller methods in ASP.NET Core
Using generic type controller methods in ASP.NET Core with Swagger
17
Jan
2021
Mocking view mapped DbSets with XUnit in EF Core
Writing unit tests for view bounded entities in EF Core
19
Dec
2020
Setting up SQL Server IDistributedCache with migration in ASP.NET Core
Embedding SQL Server caching in a project with EFCore migration
11
Dec
2020
Representing available string values for parameters as list in Swagger ASP.NET Core
Valid values as list in Swagger UI in ASP.NET Core
24
Nov
2020
Running multiple queries at the same time in EF Core
Overcoming the limitation of EF Core query execution
17
Nov
2020
Accessing multiple databases from the same DbContext in EF Core
Multiple database access from the same DbContext in Entity Framework Core 5
JavaScript
28
Oct
2018
HTML5 localStorage with expiry with vanilla JavaScript
Using HTML5 localStorage with expiry
8
May
2018
Monitoring DOM changes with JavaScript
Handling DOM changes with plain JavaScript
9
May
2017
Non blocking CSS load on the page
Load external CSS files in an async manner
16
Mar
2017
Serialize html form to JSON without using JQuery
Transform user input from HTML form fields to JSON
17
Jan
2016
Copy text value to clipboard using jQuery
Simple sample of using jQuery to copy value to clipboard
11
Jan
2016
Resize image on the client side with JQuery
Reducing the upload sie by resizing image on the client side
SQL/T-SQL
23
May
2020
Identifying opened connections for the specific application in SQL Server
Connection listing queries in SQL Server
3
May
2018
Reading JSON data in T-SQL on SQL Server
Extracting values from JSON string on SQL Server using T-SQL
28
Apr
2016
Create XML/HTML with T-SQL
Generating XML/HTML output in SQL Server
24
Nov
2015
IP address to octets split in TSQL
Split IP addresse into octets in SQL Server
20
Jul
2015
Getting first and last second of the current year, month and day
Using minimum and maximum date time in SQL query
13
Apr
2015
Dealing with duplicate rows in SQL Server
Finding and cleaning up duplicate rows in SQL Server tables
Umbraco CMS
2
Mar
2018
Minify HTML output of your pages
Minification of HTML output using ASP.NET IHttpModule
18
Apr
2015
Generate sitemap.xml on the fly in Umbraco CMS
Simple sitemap.xml Umbraco handler
2
Mar
2015
Accessing UmbracoHelper in HttpHandler request
Working with UmbracoHelper and IPublishedContent in HttpHandler
14
Sep
2014
Same page language switching in Umbraco
Land on the same page in different language in Umbraco using Relations
4
Sep
2014
Getting cropped image the smart way
The way to get cropped image URL with option to load original image too
27
Aug
2014
Fastest way to return JSON result from a controller
Resturn JSON in MVC controller action