Before covering what to remember, let’s cover the basics. What is table partitioning in SQL Server? In SQL Server a partitioned table is one that is referred to as one table but is subdivided into multiple partitions in which data is partitioned horizontally. A partitioned table has the following properties:
Partition Scheme: This defines which file group the partitions’ data will be stored.
Partition Functions: This defines how the data is partitioned (think of it as a WHERE clause, which segregates data into separate partitions.) This ensures that a group of rows are mapped together into partitions.
Features Supported by the Editions of SQL Server
Microsoft has very nice documentation covering which features are available for each version and edition of SQL Server. I refer to these pages fairly often, usually on Mondays when I can’t remember if some particular feature is available in Standard Edition (SE) or if it is Enterprise Edition (EE) only.
If you zoom in on the Enterprise Edition features for any category you’ll notice a very rich set of amazing…
What can you do with SharePoint Workflows? A lot.
Standard workflow tasks you can complete in SharePoint include project approvals, document reviews, and signature requests. You can also create custom workflows for your organization.
Everyone in business seems to define workflow uniquely based on a specific industry or organizational structure. Microsoft explains:
“In the context of Microsoft SharePoint Products and Technologies, workflow is defined more narrowly as the automated movement of documents or items through a sequence of actions or tasks…
One nifty feature I enjoy with SharePoint Online/Office 365 is its Public Website feature, which allows users to easily construct public-facing websites atop SharePoint.
Sadly, Microsoft announced in December 2014 that it would no longer offer the feature moving forward. The rationale cited for the change is a “relative lack of usage” among existing Microsoft Office 365 users. Microsoft stated any of its customers currently using Public Website may continue to have access to that feature “for…