Microsoft's SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality. It originated from the Sybase SQL Server 4.x codebase and Transact-SQL dialect (T-SQL), but it has forked significantly since then. SQL Server is ...
-1
votes
1answer
91 views
Shared Data Source name error underscore characters added
The name of our shared data source in RS (report server) is "AF1 Live Database" (no underscore characters - just spaces between words) and is the same in report builder in VS. However, the following ...
-1
votes
3answers
207 views
What are the most active T-SQL forums? [closed]
Which are the most active forums for T-SQL help (or maybe even just SQL help)? Mostly on the querying aspect, not administrative.
3
votes
6answers
166 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 ...
40
votes
18answers
7k views
Stored Procedures a bad practice at one of worlds largest IT software consulting firms?
I'm working at a project in one of the world's top 3 IT consulting firms, and was told by a DBA that company best practice's state stored procedures are not a "best practice". This is so contrary to ...
-1
votes
2answers
304 views
What strategy should be employed to access Facebook data offline?
I'm working on a project similar to Klout which provides detail about how you influence other people and who influenced you. We'll be fetching data from few social networking sites (i.e linked in, ...
6
votes
7answers
633 views
Is it recommended to use SQL Server as database for massively scalable applications?
Let's say you are planning to create a website of the scale of Facebook (If I am going to cite a website's name then why not Facebook?!). Is it recommended to use SQL Server as your database for such ...
5
votes
3answers
83 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
139 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
485 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 ...
7
votes
7answers
374 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
3answers
109 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 ...
2
votes
2answers
346 views
How to gauge a person's ability to write SQL queries?
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 ...
2
votes
1answer
70 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
69 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. ...
4
votes
4answers
144 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 ...
