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?
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…
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…