Posts by Mohammed Mawla

SQL Server: High Availability and Disaster Recovery à la Carte!

n the business world, a good RDMS is one that can provide high availability (HA) options with minimal downtime and the cheapest licenses. Vendors usually if not always provide a set of HA features to satisfy different needs. Usually, some of these features are reserved for higher-end editions. The most important factors to consider when choosing an edition are…

Amazon Lures Microsoft Customers with SQL Server RDS

Until very recently, SQL Azure was the only solution offering SQL Server on cloud, Google Cloud SQL offering only MySQL, and Amazon offering MySQL and Oracle. Not anymore! The online retail and cloud solution giant is now offering SQL server as part of its RDS service and also added ASP.NET support for AWS Elastic Beanstalk.

T-SQL:Generate statements to add TEMPDB datafiles

TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or datafiles count in Multi-core instances. This is simply because TEMPDB is a global resource that’s heavily used and very critical asset in a busy instance; this makes any advice against TEMPDB fall in the “It depends” category.

HP Cloud starts to Rain!

So HP Cloud is finally yielding for some beta rain since their announcement late September. It started late September when I signed up for private beta testing. Two weeks ago, I got invited to join the beta and start testing the platform, here’s whats offered.

T-SQL: Retrieve all users and associated roles for ALL databases

A frequent inquiry concerning databases’ security is to retrieve the database role(s) associated with each user for auditing or troubleshooting purposes. Each database user (principal) can be retrieved from sys.database_principals and the associated database roles can be retrieved from sys.database_role_members The following code runs against ALL the databases using SP_MSForeachdb and all roles for one principal is concatenated in one row

Page 1 of 3123