Archives for SQL Server, Denali - Page 2
Enabling ports in Windows Firewall (for SQL Server Access)
If you are having trouble connecting to a newly created default instance on SqlServer , try this msdn article (it DOES seem to contain every possible thing that could be…
Default instance SQL Server
Each SQL server can contain many INSTANCES ( a set of SQL Server Services). An instance is either the default, unnamed instance, or it is a named instance. When SQL…
SQL Server Passing parameters in VIEW
The short answer is that a VIEW is just a static representation of tabular data – and cannot accept a parameter. However, one can accomplish the same thing by doing…
SQL Server Consolidation–issues to consider
It is natural for an enterprise to end up with a large number of sql server databases – each hosted on its own silo server. This is an obvious waste…
Create database permission denied in database master
First , login as an admin user- then try executing this script. USE master; EXECUTE sp_addsrvrolemember @loginame = N'MyWindowsDomain\MyUserName', @rolename = N'dbcreator'; If this doesn’t do it, find this LOGIN…
Migrating TSQL to PLSQL or vice versa
From TSQL to PLSQL Apart from syntax differences, there are a host of logical differences - For TSQL procedures that use temp tables or locks have no counterpart in Oracle…
SQL Server–Server versus Database Roles for application developers
App developers typically require ownership of the database that they are working on. This translates to giving them dbo (DB Owner) rights on the database. A dbo can do almost…
SQL Server–Multiple Instances on same physical server
If you need instance separation – that is – you want to isolate two different databases completely – while hosting them on the same physical box, you can install SQL…
sql aggregates and group by
When you select an aggregate (such as count (*), ) you also need to do a group by on the results. Select ,count() as NumberOfBooks from AUTHOR a join BOOKS…
SQL Server Licensing – Processor versus Client Access Server licensing
Suppose you have a web app that connects to the SQL Server instance using a PREDEFINED SQL Server user (typically an ‘sa’ user). This is the ONLY user that actually…