Posts by Mohammed Mawla
This blog explores some of the habits on user forums and advises how to enhance the forum experience. Readers are encouraged to contribute and share their own opinions.
part 2 explores how transactions and batches can affect Merge replication identity range management. It shows a case where batch insert inside a transaction caused applications to fail and provides a resolution to the case.
This blog will shed some light on identity range management and how it works. Part 2 will explore how batch inserts can affect the identity range management.
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…
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.
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.
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.
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
In this post I’ll Briefly cover the changes to SQL Server licencing which happened in two areas, edition changes and licensing changes. Lets get started.
If you ever used SQL server Database Engine Tuning Advisor then you know you have few options as a source of analysis workload, here they are.