SQL Server is a relational database management system from Microsoft.

learn more… | top users | synonyms (1)

1
vote
2answers
327 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 ...
14
votes
5answers
6k 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
1k 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 ...
4
votes
3answers
4k 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 ...
5
votes
3answers
9k 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
573 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
2answers
470 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 ...
0
votes
2answers
3k 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
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 ...
0
votes
2answers
126 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 ...
2
votes
3answers
12k 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
1k 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 ...
6
votes
4answers
3k 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
1k 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 ...
2
votes
1answer
368 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 ...
2
votes
2answers
1k 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) http://www.microsoft.com/sqlserver/en/us/...
1
vote
2answers
616 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
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
398 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 ...
1
vote
2answers
917 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 ...
5
votes
2answers
146 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
266 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 ...
6
votes
5answers
668 views

Visual Studio 2010 SP1 Performance [closed]

I've noticed since installing Visual Studio 2010 SP1 that I'm having huge performance issues. It will randomly freeze up on me quite a bit. I had no performance issues with Visual Studio 2010 before ...
2
votes
6answers
259 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 ...
3
votes
6answers
379 views

Find material for improvement of my SQL ability [closed]

I need lots of training in SQL coding in MS SQL server The following part that is needed to be improved is: script T SQL Procedure Function Problem: Where can I get material to improve my ...
13
votes
13answers
1k views

Do SQL Devs create SQL queries using SQL Query Designers?

I was just curious if SQL Devs write their code freehand or do they make use of the visual query designer to generate queries? In the majority of the cases, the query designer can create most of non-...
2
votes
1answer
118 views

How to find a scaling expert?

The web application is in ASP.NET and Sql Server and is growing much faster than anticipated. Where can I find an expert who has previously had experience of going from a small website to solution ...
3
votes
3answers
257 views

How to query a very long list of properties fast

I have a structure for storing item properties on SQL Server: ItemId PropertyId Value 1 1 a 1 2 b 2 1 a 2 2 5 Currently there are over 130000 ...
8
votes
10answers
3k views

Do Microsoft Certifications matter? [duplicate]

Possible Duplicate: Are certifications worth it? I'm curious what experience others have had, both from the perspective of an employer and an employee on Microsoft Certifications. I'm kind of ...