management (3,264)


PHP Session Security

PHP Session Security

Locked.This question and its answers are locked because the question is off-topic but has historical significance. It is not currently accepting new answers or interactions. What are some guidelines f…


sql server - Which tools do people use to create Data Dictionaries?

On the project that I am working on I have a couple of databases. Each table and each column in the database has a description set(as an extended property in SQL 2005). As a part of the documentatio…


c# - Setting Objects to Null/Nothing after use in.NET

Should you set all the objects to null(Nothing in VB.NET) once you have finished with them? I understand that in.NET it is essential to dispose of any instances of objects that implement the IDisposab…


SQL Client for Mac OS X that works with MS SQL Server

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, argument…



Backup SQL Schema Only?

I need to create a backup of a SQL Server 2005 Database that's only the structure...no records, just the schema. Is there any way to do this? EDIT: I'm trying to create a backup file to use with old…


How to enable Full-text Indexing in SQL Server 2005 Express?

I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate. I understand that the standard version of SQL Server Express does not have ful…


sql - Drop all tables whose names begin with a certain string

How can I drop all tables whose names begin with a given string? I think this can be done with some dynamic SQL and the INFORMATION_SCHEMA tables.…


SQL Server Management Studio alternatives to browse/edit tables and run queries

I was wondering if there are any alternatives to Microsoft's SQL Server Management Studio? Not there's anything wrong with SSMS, but sometimes it just seem too big an application where all I want todo…


sql - Inheritance in database?

Is there any way to use inheritance in database(Specifically in SQL Server 2005)? Suppose I have few field like CreatedOn, CreatedBy which I want to add on all of my entities. I looking for an alter…


svn - How do you deal with configuration files in source control?

Let's say you have a typical web app and with a file configuration.whatever. Every developer working on the project will have one version for their dev boxes, there will be a dev, prod and stage versi…




how server example sql studio memory for and best database