Group items tagged

"Tired of querying in antiquated SQL? Well, you don't have to! LINQPad lets you interactively query databases in a modern query language: LINQ. Kiss goodbye to SQL Management Studio! LINQPad supports everything in C# 3.0 and Framework 3.5, and more: * LINQ to Objects * LINQ to SQL and Entity Framework * LINQ to XML * WCF Data Services & SQL Azure * LINQ to SQLite and MySQL Enterprise Server * Mindscape LightSpeed ORM * (Even old-fashioned SQL!)"

Did you know that by default LINQ to SQL defines your connection string in more than one place if you define your LINQ to SQL classes out from a web app, such as a data access layer class library?

How to configure SQL 2005 Database Mail sp_send_dbmail

How to configure SQL 2005 Database Mail sp_send_dbmail

Changing the default SQL Server backup folder

Changing the default SQL Server backup folder

It's hard to find SQL Server 2008 Express files that are not R2 so here's the original DB

"SQL Server Session State Problems"

Sitecore logging to SQL.

"To change the DB_Owner to some another "Database Principal"; simply Drill Down to your Database in Sql Server Management Studio and further more Drill Down to your_DB_Name > Schemas > db_owner > right click > select properties. You would find the name of the "Database Principal" that you want to delete. Change this to some another "Database Principal"; for Example, to "dbo"."

Samples of every connection string type for every driver

" When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Database Management Studio will not allow you to save the changes."

I set AutoGenerated in the LINQ Designer to true which made use of my default values.

Wikipedia for SQL Server