SQL Server is a relational database management system from Microsoft.

learn more… | top users | synonyms (1)

2
votes
4answers
192 views

.NET app - Should we use SQL Server and duplicate some reference data from an external Oracle DB? Or use Oracle and have a DB link?

We're looking to migrate some existing Excel/Access processes into a new system which will provide the users with a Silverlight frontend to run and view the reports instead of using MS Access. The ...
2
votes
5answers
3k views

SQL Strings vs. Conditional SQL Statements

Is there an advantage to piecemealing sql strings together vs conditional sql statements in SQL Server itself? I have only about 10 months of SQL experience, so I could be speaking out of pure ...
2
votes
5answers
1k views

I feel unprepared to start my first job out of college… how can I improve? [closed]

I just graduated from university with a degree in Computer Science/Engineering and was fortunate enough to land a job working in the pharmaceutical industry as a developer. My title is System ...
3
votes
5answers
377 views

New application development - Use existing database or create a new one?

A Client has a huge Windows Application running on a Database. This client wants you to develop an "Express" version of this application, including only, let's say, 20% of its features. This Express ...
3
votes
6answers
813 views

How to include database changes during application publish

I am maintaining a WinForms application, which talks to a SQL Server database. Sometimes I have to change database schema (for example to alter a sql procedure or add new one). For this purpose I have ...
5
votes
3answers
661 views

Overloaded high transaction SQL Server database Solutions

The current sql server database is overloaded and many transactions are failing. The powers that be have a proposed solution to build a separate database to handle/store transactions and then ...
1
vote
4answers
877 views

At least one database view per database table-Is this good or bad design and why?

We are building a Windows Mobile based application to interface with a customer's existing web application. We are reading and writing data to the customer's SQL server 2008 database. The customer ...
5
votes
5answers
728 views

Is realtime validation of username good or bad?

I have a simple form for the user to sign up to my site; with email, username and password fields. We are now trying to implement an ajax validation so the user doesn't have to post the form to find ...
2
votes
1answer
438 views

How to deal with transactions when creating a database connection for each query

In line with this post here I am going to change my website to create a connection per query to take advantage of .NET's connection pooling. With this in mind, I don't know how I should deal with ...
14
votes
2answers
10k views

Creating database connections - Do it once or for each query?

At the moment I create a database connection when my web page is first loaded. I then process the page and run any queries against that conection. Is this the best way to do it or should I be creating ...
2
votes
3answers
577 views

Designing a large database with multiple sources

I have been tasked with redesigning, or at worst optimising the structure of a database for a data warehouse. Currently, the database has 4 other source databases (which is due to expand to X ...
9
votes
7answers
3k views

What is the preferred tool/approach to putting a SQL Server database under source control?

I've evaluated RedGate SQL Source Control tool (http://www.red-gate.com/products/sql-development/sql-source-control/), and I believe that Team Foundation Server 2010 offers a way to do this as well ...
2
votes
1answer
253 views

How to swap out a DB from MySQL to SQL Server in a multiple large projects?

Is there a sane way / best practices way to swap out a DB from MySQL to SQL Server in a multiple large projects? Some of the projects are ASP projects, some of them are windows services, some are ...
0
votes
1answer
117 views

migration and interoperability

A large system has already been done in visual fox pro. They want to add more requirements to a module and make some changes to the system.At the same time they are thinking about migration to .net. ...
5
votes
4answers
239 views

Putting audit functionality into the database

Our database does not have any audit functionality. It does not records who inserts the record or who who changes it It does not keep a history of the changes made Nothing can be restored if ...
0
votes
2answers
201 views

What can I do to help users create self-service reports?

I work using Reporting Services 2008 and I'm constantly creating ad-hoc reports. We'd like to use PowerPivot on Sharepoint but we're stuck on Sharepoint 2007. Using easy reporting software like ...
5
votes
1answer
1k views

Designing a scalable and robust retry mechanism

Backstory I have an Messaging Server Application that is responsible for brokering/proxying calls made from an Application Tier to numerous external services. The purpose of this application is to ...
6
votes
4answers
19k views

Best practice to query data from MS SQL Server in C Sharp?

What is the best way to query data from a MS SQL Server in C Sharp? I know that it is not good practice to have an SQL query in the code. Is the best way to create a stored procedure and call it ...
2
votes
2answers
974 views

How to gauge a person's ability to write SQL queries? [closed]

If I am a Java certified programer, by seeing that certificate people can say I have good knowledge on Java in a snap. Is there any similar certification to know if a person can write good SQL ...
3
votes
1answer
144 views

Is there another name for Sql Azure's programming language?

According to this page on MSDN the sql language used on Sql Azure is called transact-sql (the same as on sql server). But is this the only way to refer to programming on Sql Azure? The Sql Azure ...
1
vote
2answers
268 views

Are there any advantages of using separate RDBMS for reports?

My production database is SQL Server 2008 R2 Express. It has limited features and I am testing it in a production environment. To better handle reporting queries in a highly concurrent environment, I ...
12
votes
5answers
4k views

Version Control with SQL Server

I'm starting a new project and using SVN (with Tortoise) as my Version Control System. I was wondering if it was possible to also maintain a SQL Server Database using the same system. I'd want to ...
2
votes
1answer
724 views

What should we include in SSAS cube design documentation?

What should we include in a SSAS cube design documentation? This is the initial phase of the document. I have included: data models, facts, dimensions, surrogate keys, hierarchies and levels ...
6
votes
2answers
4k views

Can SQL Server and Mongo be used together?

We have a large news-oriented site that has high web traffic. The architecture is your often seen DB - Repo Layer - Services Layer - Asp.Net MVC. The problem that we've been seeing is around read ...
3
votes
3answers
6k views

Which is better : Storing/retrieving images on/from SQL server or in a directory on server

I am working on a project in Asp.net MVC and need to work with images. There is an SQL database with a Product table. Every product in the table will have it's own image. I have two ways to do this : ...
5
votes
4answers
327 views

Multiuser System With Encrypted Database

I am currently developing a hosted solution in ASP.NET using MVC3 and Entity Framework. This product will then be made available to a number of clients as a hosted solution. As the data stored by ...
3
votes
3answers
2k views

How to reach to the advanced level in SQL? [closed]

I think I have a good grasp of SQL and the most features it has, but sometimes when I've done some more advanced Reporting Services a fellow developer has helped me with some stuff and when I open ...
0
votes
2answers
1k views

Server OS/Software Requirements For asp.NET Framework 4.0

The Background: Me and my colleague are opening a new website design & development company. We have designed and implemented a website on Microsoft Visual Studio 2010 using Web forms in .NET ...
0
votes
2answers
119 views

Local and cloud editions?

I have a .NET web server application I'm building that I plan to host at a .NET cloud hosting platform, like AppHarbor with SQL server. It will be used by multiple small groups of people to record and ...
1
vote
3answers
6k views

Sequel vs S-Q-L [duplicate]

Possible Duplicate: What's the history of the non-official pronunciation of SQL? I hear it every so often, "In sequel server...", and for some reason I cringe every time. Maybe it's ...
0
votes
4answers
827 views

Comparing Visual Foxpro with .NET

I used Foxpro 2.6 a decade ago. In my present company, few new projects are being developed in Visual Foxpro 9.0 and few projects are on .NET platform. From time-to-time I notice how Visual Foxpro is ...
0
votes
2answers
2k views

Using Visual Foxpro DBF with ASP.NET as opposed to SQL Server

I work in a small software company where my boss is a great fan of Visual Foxpro. We are working on an ASP.NET project but my boss is insisting to use Visual Foxpro DBF instead of SQL Server. I want ...
6
votes
4answers
1k views

Should “tags” be an nvarchar field in a table, or should it be another table altogether?

I am building a photography website and I want to allow the user to put tags on their photos for easy searching. But I'm not sure if I want the tags to be an nvarchar field in each picture and then ...
1
vote
2answers
856 views

Which database to prefer while developing a WPF medical inventory system?

I have a project to develop an inventory system for a medical shop. Till date, I confronted simple requirements which were fulfilled with XML as the backend db. My interaction knowledge with XML is ...
3
votes
2answers
401 views

Pros/Cons for a Data Structure covering multiple databases?

I'm about to extend a system containing two separate systems. Or domains, if we see the system as a domain level. Today One domain is used internally. The other is public, which means it is more ...
7
votes
3answers
318 views

Using a standard localised data cryptography pattern with an ASP.NET MVC3 application

I have been given the task to rejuvenate an existing Human Resources application from Access into ASP.NET. This is a strictly internal application, and I have no problems developing it within our ...
6
votes
3answers
2k views

Are there any special advantages of SQL Server with Visual Studio?

I have seen the forum dba.StackExchange, but this question involves Visual Studio as well, therefore I wanted to post this question here. One of my old application was built on VS-2008 and MySQL ...
4
votes
3answers
2k views

What are the open source options for a Bug tracker on IIS 7 & SQL Server 2008? [closed]

What are the open source options for a Bug tracker on IIS 7 & SQL Server 2008? Currently we're running a Windows Server 2008 with IIS 7, Coldfusion 8 & SQL Server 2008. What are the best ...
1
vote
2answers
490 views

what is storing data in constant space?

"bloom filter allows us to store data in constant space" Can someone explain what exactly does that sentence means?
2
votes
2answers
928 views

Sql Server: Compact and LocalDB Denali

Does anyone knows the differences between these ones? http://www.microsoft.com/sqlserver/en/us/editions/express.aspx (Look for CTP3 LocalDB in the page) ...
2
votes
6answers
1k views

what is the benefit of using key/value stores with respect to database sharding?

What has key/value stores got to do with making database sharding easier? Because if I do not use a key/value store, I can easily shard my database too right? (Like say, I can easily say users with ...
6
votes
5answers
378 views

Anti Identity Column

I recently came across some code which generates an identity value for a key: DECLARE @ID INT; SELECT @ID = MAX(ID) + 1 FROM Person; INSERT INTO [Person] ([ID], [FirstName], [LastName]) VALUES ...
7
votes
4answers
300 views

How best to handle database refactoring within a team?

We are currently usign a roll-forward approach to DB changes, akin to Migrations, where each developer creates and checks in a script that promotes the latest version of the DB to a new state. ...
2
votes
1answer
286 views

Amazon Cloud (EC2) w/SQL Server. Pay for SQL instance, or use an AMI w/SQL Server Express?

I have been considering using the Amazon cloud (EC2) for a small workflow application. In terms of power and storage, a SQL Server Express database will more than meet my needs. I have been cautioned ...
1
vote
2answers
640 views

If you're a .NET developer, does getting the Microsoft Certified Master SQL Server 2008 cert make sense? [duplicate]

So I've been working at a job for the past year as a .NET developer/DBA. The job is my first DBA job. Traditionally, I'm a .NET developer and have about 5 years experience in it. Does it make sense ...
4
votes
8answers
4k views

Alternative for Access+SQL Server for enterprise projects [closed]

We're a small software company, developing projects for manufacturing facilities about analysis, traceability, reporting etc. We're using Access for front end, SQL Server for back end. We've quite big ...
8
votes
3answers
427 views

How do you handle constantly changing database dimensions?

For the last two months or so I have been looking for solutions or practices to handle release management within databases. I'm looking for what people view as the best process for handling this. We ...
5
votes
2answers
140 views

Centralised Integration framework

We are looking to centralise our Integration in our company and I'm wondering what sort of solutions other have for this and what the best way to approach it would be. At the moment we have different ...
0
votes
1answer
163 views

Comparing features in a asp.net web application using different database methodologies [closed]

I have a webstore which sells components (it is a academic project) which looks like this. I have developed the same web application using following database methodologies: MS Sql Server with Stored ...
2
votes
6answers
231 views

BizSpark and SQL Server already present. Can and should we move to OSS?

I am starting a new role running engineering in a young startup. The stuff they have is in SQL Server / Windows. I get the feeling we should think about moving to an OSS architecture, main reasons ...