Search Within SQL Server Database Objects with Red-Gate SQL Search

SQL Search by Red-Gate is a great tool for searching within database objects. It is invaluable on brown field projects where you work with existing databases. My recent experience was … Continue Reading →

Working With SQL Server HierarchyId Data Type In .NET Application

Recently I was working with some hierarchical data stored in SQL Server. The data was related to products where each product is a package which includes other packages which in … Continue Reading →

Generate SQL Server Database From Entity Data Model

In an earlier post we looked at how to generate an Entity Data Model using Visual Studio 2010. The data model we created was not generated from a database. This … Continue Reading →

Creating Entity Data Model Without A Database With Entity Framework 4

This article shows you how to generate an Entity Data Model for Entity Framework 4 using Visual Studio 2010. Entity Data Model is widely known by its acronym EDM. A … Continue Reading →

Connect To SQL Server 2008 From NetBeans IDE On A Mac

In this post I will show you how to establish a connection to Microsoft SQL Server  from NetBeans IDE. I use a Mac so the screenshots here are from Mac … Continue Reading →

Easiest Way to Generate Connection String And Verify Database Connectivity

There are two things which I as a consultant / developer come across many times. One is verifying connectivity to a database which is often a cause of production issues … Continue Reading →

Select Max Value With LINQ To SQL

Today I was asked a question by a developer on my team. The question is “How do you select MAX value for a column in a table with LINQ To … Continue Reading →

SSMS Tools For SQL Server 2008

SSMS Tools Pack is a must have add-in for SQL Server Management Studio. It comes packed with a great set of features which as the author says on his site … Continue Reading →

Get Free Disk Space Using T-SQL

To get free disk space for all physical drives on a machine we can use xp_fixeddrives extended stored procedure. An interesting this about this procedure is that it is not … Continue Reading →

Create T-SQL CASE Statements With LINQ To SQL

I was recently helping Nosh with a LINQ To SQL query where he wanted the resulting T-SQL query to have CASE statements. Having CASE statements in T-SQL queries is a … Continue Reading →

Page 1 of 3123