Tag: .net

Arguments for usage choice: RavenDB vs SQL Server – performance, reliability and simplicity

What points should be taken into consideration, while choosing data layer for a web application? Is there any preferable choice for using document database over relational ones, while developing small project over large and heavy loaded, or vice versa? What kind of database architecture is preferred for these approaches – if I have simple database […]

Debugging in SSIS

How do I debug .NET code written within a script task in a SSIS package? The development environment allows placing a breakpoint however does not take me to the code like it would in regular .NET programming while debugging. Also, I am at a loss to understand how to add the SSIS package variables to […]

Horrible performance when using SqlCommand Async methods

I’m having major SQL performance problems when using async calls. I have created a small case to demonstrate the problem. I have create a database on a SQL Server 2016 which resides in our LAN (so not a localDB). In that database, I have a table WorkingCopy with 2 columns: Id (nvarchar(255, PK)) Value (nvarchar(max)) […]

Sync Framework with SQL DB's: Getting Started

I have an app that uses SQL Enterprise to store all data in 4 different DB’s. I needed to build in the ability to work “offline” for my users. I accomplished this through Merge Replication to local SQL Express installs for everyone. This “Works” but feels like the sledge hammer approach. For instance, I am […]

System.Data.EntityException: The underlying provider failed on Commit

Using Entity Framework, I received a number of the following exceptions last night in one of my applications: System.Data.EntityException: The underlying provider failed on Commit. —> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, […]

Can a SQL Injection attack be executed through anything other than SqlCommand?

If I have an ASP.NET web application that has a SQL Server database, is it safe to assume that if a SQL Injection attack is going to be made it will pass through an instance of the SqlCommand class? Background: I am in a situation where I inherited a rather large web application that has […]

max date record in LINQ

I have this table named sample with these values in MS Sql Server: ID Date Description 1 2012/01/02 5:12:43 Desc1 2 2012/01/02 5:12:48 Desc2 3 2012/01/03 5:12:41 Desc3 4 2012/01/03 5:12:43 Desc4 Now I want to write LINQ query that result will be this: 4 2012/01/03 5:12:43 Desc4 I wrote this but it doesn’t work: […]

ASP.NET MVC & SQL Server Reporting Services

I am getting started with ASP.NET MVC. Is it easy or even possible to use the ReportViewer in MVC as you can with webforms? If not, what can be done?

Problems Registering Oracle.DataAccess as SQLCLR assembly in MS SQL Server 2012

EDIT 3.5 (Meant to put Item 3 below in the last update, but overlooked. Alas…) Looking at how the assembly registration fails for my problem and looking at what limited info I am able to infer from ProcExplorer traces leads me to make some conclusions on a few things. No solutions, just a few inferences […]

SQL Server database on Azure UNIQUE KEY constraint crash

After launching promo campaign of our software yesterday we’ve met some strange problems with our SQL Server database. This error occurs when users did signup for an account at our website. When it was low user traffic everything seemed to be ok and worked properly but once traffic increased to ~10 signups at a time […]

MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.