Group items tagged

In this post, you will learn how to display real time updates from the SQL Server by using SignalR and SQL Dependency in ASP.NET MVC.

Running the hoster component on sql servers at work is probably overkill, but the publishing wizard rocks.

The Database Publishing Wizard makes it easy to generate T-SQL to export your schemas, procedures, and data from a database, or to upload it directly to supporting hosters... The Database Publishing Services are a set of ASP.NET web services hosters can deploy to make it simple for customers to deploy SQL Server databases.

Scripted PowerShell Automated Deployment Engine simplifies the process of standing up a new SQL Server instance; applying standard OS pre-configurations, installing SQL Server, and then applying post-configurations and creating standard objects.

The SQL Server Database Publishing Wizard provides a way to publish databases to T-SQL scripts

Microsoft Has Released Tools To Address SQL Injection Attacks

A 5 part blogpost about the performance of a select statement done with ADO.Net using inline sql, and stored procedures (even some dynamic sql) and then nHibernate to get the same results. But this one has an alternate ending.

SQL Server Precision And Scale Problems

Troubleshooting Blocking 101 on SQL Server

customize the LINQ to SQL code generation

SQL Server Writing Better SQL

Copy data from one table to another existing table in sql server

Copy data from one table to another existing table in sql server

You can use any of below methods to change SQL Server Password. You can also download any third party tool for the same

Try out and demo SQL Queries

Learn SQL (Standard query language) with easy and simple programming example. Read many articles and tutorial with free downloading notes facility. Increase your programming skill programmingstutorial.com

Learn about Data type. What is data type how is useful for every programming language. Get complete information about basic data type in C, C++, Java, SQL and other programming language.

Interview With Louis Davidson Author of Pro SQL Server 2008 Relational Database Design and Implementation

This is a collection of SQL hacks, right now we there are 8 sections and between 70 and 80 hacks.

The Visual LINQ query builder is a Visual Studio 2008 addin. It's a designer that helps you create Linq to Sql queries in your application.

Microsoft DreamSpark gives millions of students in the United States, the United Kingdom, Canada, China, Germany, France, Finland, Spain, Sweden, Switzerland and Belgium (and other countries coming soon) software for free ... Visual Studio 2005/2008 Professional Edition, Expression Studio (includes Web, Blend, Media, and Design), SQL Server 2005 Express, SQL Server 2005 Developer Edition, Virtual PC, Windows Standard Server, XNA SDK, and a 12-month trial subscription to the XNA Creators Club.

Doctrine is an object relational mapper (ORM) for PHP 5.2.3+ that sits on top of a powerful database abstraction layer (DBAL). One of its key features is the option to write database queries in a proprietary object oriented SQL dialect called Doctrine Query Language (DQL), inspired by Hibernates HQL. This provides developers with a powerful alternative to SQL that maintains flexibility without requiring unnecessary code duplication.