There is more than one way to work with SQL Server stored procedures from within a .NET Application. However, when using parameters, in order to avoid exposing your code to "SQL Injection" vulnerabilities, there is a certain way based on which you should write your code.
2023-08-21
One of the slowest parts of any application is data retrieval and in this article, we look at how to cache SQL Server data for a web application.
2023-05-22
Introduction NoSqlOnSql is a strict syntactical superset of SQL; it adds NoSQL document-oriented capabilities to the SQL language. For this, it uses uses JSON-like documents, integrating them into the normal flow of SQL statements. NoSqlOnSql is based on augmenting a SQL database to support NoSQL features without any kernel changes. In this sense it is […]
2020-11-02
4,910 reads
The React library allows teams to work faster and with more consistency. In this article, Camilo Reyes explains how to get started using React components in a C# application
2019-09-16
This is the wrap up of this series on a system for developers to restore production database in test. It gets pretty detailed on the web setup side.
2019-05-16
2,936 reads
Even when creating games, your code has access to environment variables and document files. In this article, Lance Talbert shows how to access files to convince the player that maybe the game knows more than it should.
2019-03-28
IT transformation projects often fail due to poor planning, poor communication and more. In this article, Mohammad Rizvi explains how to be successful and give your customer a great experience.
2019-01-08
2,602 reads
Validating the user input of a web form is important for security and data quality. In this article, Dino Esposito explains how to validate a form and add undo capability with Bootstrap 4.
2019-01-07
2,392 reads
A basic introduction for developers (or anyone) to using the metadata for a SQL Server database to build a DataSet in ADO.Net that represent objects in any SQL Server database.
2018-09-27
1,905 reads
Developing JavaScript for web pages can be perplexing. You will get errors that seem to make no sense, You will be given nuggets of advice about how and when you can use JavaScript to manipulate the DOM or make Ajax requests. It is far better to understand the reason for these rules; the single-threaded nature of JavaScript, and how it loads the page and manages the event loop. How can you achieve parallel processing and what is the best way? Igor makes it all clear and obvious.
2016-11-04
3,714 reads
By DesertDBA
I haven’t posted in a while (well, not here at least since I’ve been...
By Steve Jones
One of the things that I like about the SQL Server docs (MS Learn...
By Brian Kelley
For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...
I have change tracking configured in several databases, in QA and production environments, and...
is there a no code way to limit an ssis extract from excel to...
Hello Need help in pivoting this data set, the Pivot takes MIN/MAX on a...
In SQL Server 2025, what does this return?
CREATE TABLE Numbers ( n INT) GO INSERT dbo.Numbers ( n ) VALUES (1), (2), (3) GO SELECT PRODUCT(n) FROM dbo.NumbersSee possible answers