SQL Server

Currently Browsing Category 'SQL Server'

SQL Queries and LinqPad

by Joe on Apr 22nd in IDE, LINQ, SQL Server, tools, utilities

Just a quick post today. I was recently brought on to do some custom SQL queries in a Database that I was unfamiliar with. I had a short time to work, and the queries¬†involved traversing several objects. I¬†could have spent time in SQL Server, figuring out relationships, documenting foreign keys, and generating UML diagrams to […]

SQL Server 2008 – Change multiple Table Schemas at once

by Joe on Apr 6th in SQL Server, SQL Server 2005, SQL Server 2008, Table Schema

Need to change all the table schemas at one time? In my case, the default schema in the early run through DB design was the username (i.e. username.tablename) Obviously, this has caused problems down the road. Here’s a fairly simple fix that will work in SQL Server 2005 or SQL Server 2008:exec sp_MSforeachtable “ALTER SCHEMA […]

Configure Sql Server 2008 for remote connections

by Joe on Mar 5th in Remote Access, SQL Server, SQL Server 2008, TCP

For help with SQL Server 2008 remote connections, check this link out:How to configure SQL Server 2005 to allow remote connections on Windows Server 2008 (Longhorn) / Windows Vista It looks like it would only be for SQL Server 2005 remote connections, but the second tip worked like a charm for me. The part about […]

Database Installation

by Joe on Jul 1st in Database install, Publish Database, Server Explorer, Setup and Deployment, SQL Server, Visual Studio 2008, VS 2008

Visual Studio 2008 has this nifty tool for scripting databases. If you have an existing data connection in your Server Explorer, you can right-click on a database, select “Publish to Provider”, and voila, you have your entire database scripted to a file. Now, you may think “Hey, I can run this on another server, and […]

Running a database installation msi

by Joe on Jun 28th in CodeProject, Setup and Deployment, SQL Server, Stan Prodan, VS 2008

It’s remarkably unintuitive how to install a database through Visual Studio 2008. Nevertheless, it CAN be done! Solutions such as RedGate’s SQL Packager are great, but expensive. I needed a quick, free solution. As luck would have it, one of my favorite resources, CodeProject, had just the thing. Thanks to Stan Prodan for his article […]

Powered By Wordpress Designed By Ridgey