I had the chance to attend a course about what used to be called Parallel Data Warehouse (PDW). PDW was introduced few years ago with the offering of SQL Server 2008 R2 Parallel Data Warehouse , something very few people…Read More >
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.Read More >
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.Read More >
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.Read More >
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…Read More >
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.Read More >
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.Read More >
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.Read More >
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 rowRead More >
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.Read More >
© Copyright 2020 Pythian Group Inc. ® ALL RIGHTS RESERVED.
PYTHIAN®, LOVE YOUR DATA®, and ADMINISCOPE® are trademarks and registered trademarks owned by Pythian in North America and certain other countries, and are valuable assets of our company. Other brands, product and company names on this website may be trademarks or registered trademarks of Pythian or of third parties. Use of trademarks without permission is strictly prohibited.