Archives for SQL Server, Denali
SQL Visual Query Construction tools
In order of preference (my preference , based on product maturity, knowledge base, user forums etc.): Toad for SQL Server – Pro Edition - $650 /user DB Visualizer Pro –…
Mirroring, Replication and Always On Clusters
Mirroring versus Replication SQL Server provides database-level redundancy through: backup/restore log shipping database mirroring (in SQL Server 2005 and later) Always on Clustering (SQL 2012 onwards) Mirroring means master-master replication…
SQL Server Geo Replication
Achieve database redundancy across or within AWS regions, or from on-premise to AWS, with Asynchronous SQL Server Geo-Replication. Create secondary Standby databases for Disaster Recovery (DR). Create Read Replicas to…
db_owner security risks
A typical web-tier should only need DB_USER level access to a backend SQL Server database. The DB_USER contains DB_Writer, DB_Reader – and optionally, DB_EXECUTE privileges. Sometimes, web tiers will be…
Creating an Oracle RAC like structure with SQL Server Technology
It is no secret that Oracle’ RAC platform has been a best seller in the enterprise database category. Among other things, Lowers overall cost of ownership by providing a single…
When to consider SQL Server Enterprise
The crux of the matter lies in Scalability – and security (encryption of data at rest). Here are a few things that you will get with SQL Enterprise that you…
Oracle RAC equivalent for SQL Server?
There are two main reasons for using an Oracle RAC. A shared, 'multi-tenant' environment which scales seamlessly to increasing load. And a high-availability cluser which provides a redundant node (or…
Oracle RAC equivalent for SQL Server?
There are two main reasons for using an Oracle RAC. A shared, 'multi-tenant' environment which scales seamlessly to increasing load. And a high-availability cluser which provides a redundant node (or…
Oracle RAC equivalent for SQL Server?
What RAC features are you interested in? If you are interested in having a large SHARED memory pool that can host multiple tenants (multiple apps), then SQL Server Enterprise can…