sql-server tutorials and guides

Entity Framework 1to1 relationship via association table not working in EDMX

Sep 07, 2022

Entity Framework Not Generating Classes for Tables or Procedures

Oct 23, 2022

c# sql-server entity-framework ado.net-entity-data-model

SET IDENTITY_INSERT ON/OFF needed on application server, but ALTER permission seems dangerous. Suggestion?

Jan 19, 2022

sql-server database-design web-applications sql-server-2012

Entity Framework Deadlocks and Concurrency

Sep 19, 2022

.net sql-server vb.net entity-framework

Why WHEN MATCHED' cannot appear more than once in a 'UPDATE' clause of a MERGE statement?

Oct 14, 2022

sql sql-server merge

Update multiple second Id's to match the first Id's of a series

Jul 25, 2018

sql sql-server sql-server-2008 tsql

Left outer join with only first row

May 02, 2022

sql sql-server greatest-n-per-group

RODBC and Microsoft SQL Server: Truncating Long Character Strings

Oct 20, 2022

sql-server r truncate rhel rodbc

Is recursion good in SQL Server?

Nov 02, 2022

sql-server recursion

How can I change a field in a SQL server database that's set to "Read Only Cell"?

Oct 14, 2019

sql-server ssms

Error converting data type varchar

Jun 05, 2022

sql sql-server tsql

Best way to flatten/denormalize SQL lookup tables?

Oct 30, 2022

sql sql-server pivot lookup-tables

SQL Server and windows authentication in IIS7

May 08, 2022

asp.net sql-server iis-7 windows-authentication

TransactionScope and Connection Pooling

Aug 13, 2017

sql-server .net-3.5 connection-pooling transactionscope isolation-level

Selecting SUM of TOP 2 values within a table with multiple GROUP in SQL

Aug 15, 2018

sql sql-server set sql-server-2000

Can I "join" across datasources in SSRS?

Feb 21, 2022

sql-server oracle reporting-services join

Get Physical File Path of Any Database

Nov 20, 2016

sql-server sql-server-2005 tsql

How to create recurring calendar events?

Nov 02, 2022

c# sql-server asp.net-mvc-3 google-calendar-api reminders

Linking Server in SQL Server 2008 R2

Nov 18, 2022

sql-server sql-server-2008 linked-server

Interesting SQL puzzle

Oct 22, 2018

sql sql-server puzzle

New posts in sql-server