�ݺ�ߣshows by User: HamidJFard

�ݺ�ߣshows by User: HamidJFard / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: HamidJFard / Thu, 21 Apr 2016 14:01:58 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: HamidJFard Sql server backup internals /slideshow/sql-server-backup-internals/61194471 sqlserverbackupinternals-160421140158
Once the ‘Backup Database’ command executed, SQL Server automatically does few ‘Checkpoint’ to reduce the recovery time and also it makes sure that at point of command execution there is no dirty pages in the buffer pool. After that SQL Server creates at least three workers as ‘Controller’, ‘Stream Reader’ and ‘Stream Writer’ to read and buffer the data asynchronously into the buffer area (Out of buffer pool) and write the buffers into the backup device.]]>
Once the ‘Backup Database’ command executed, SQL Server automatically does few ‘Checkpoint’ to reduce the recovery time and also it makes sure that at point of command execution there is no dirty pages in the buffer pool. After that SQL Server creates at least three workers as ‘Controller’, ‘Stream Reader’ and ‘Stream Writer’ to read and buffer the data asynchronously into the buffer area (Out of buffer pool) and write the buffers into the backup device.]]> Thu, 21 Apr 2016 14:01:58 GMT /slideshow/sql-server-backup-internals/61194471 HamidJFard@slideshare.net(HamidJFard) Sql server backup internals HamidJFard Once the ‘Backup Database’ command executed, SQL Server automatically does few ‘Checkpoint’ to reduce the recovery time and also it makes sure that at point of command execution there is no dirty pages in the buffer pool. After that SQL Server creates at least three workers as ‘Controller’, ‘Stream Reader’ and ‘Stream Writer’ to read and buffer the data asynchronously into the buffer area (Out of buffer pool) and write the buffers into the backup device. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverbackupinternals-160421140158-thumbnail.jpg?width=120&height=120&fit=bounds" /> Once the ‘Backup Database’ command executed, SQL Server automatically does few ‘Checkpoint’ to reduce the recovery time and also it makes sure that at point of command execution there is no dirty pages in the buffer pool. After that SQL Server creates at least three workers as ‘Controller’, ‘Stream Reader’ and ‘Stream Writer’ to read and buffer the data asynchronously into the buffer area (Out of buffer pool) and write the buffers into the backup device.

Sql server backup internals from Hamid J. Fard

]]> 899 9 https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverbackupinternals-160421140158-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server High Availability Solutions (Pros & Cons) /slideshow/sql-server-high-avaiability-solutions-pros-cons/59064266 sqlserverha-160304102101
Proper SQL Server High Availability Solution Is Highly Depends on the Business Objective and IT Operation Objectives. It Happens Sometimes that We Might Have Few Solutions on the Table to Implement.]]>
Proper SQL Server High Availability Solution Is Highly Depends on the Business Objective and IT Operation Objectives. It Happens Sometimes that We Might Have Few Solutions on the Table to Implement.]]> Fri, 04 Mar 2016 10:21:01 GMT /slideshow/sql-server-high-avaiability-solutions-pros-cons/59064266 HamidJFard@slideshare.net(HamidJFard) SQL Server High Availability Solutions (Pros & Cons) HamidJFard Proper SQL Server High Availability Solution Is Highly Depends on the Business Objective and IT Operation Objectives. It Happens Sometimes that We Might Have Few Solutions on the Table to Implement. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverha-160304102101-thumbnail.jpg?width=120&height=120&fit=bounds" /> Proper SQL Server High Availability Solution Is Highly Depends on the Business Objective and IT Operation Objectives. It Happens Sometimes that We Might Have Few Solutions on the Table to Implement.

SQL Server High Availability Solutions (Pros & Cons) from Hamid J. Fard

]]> 10440 16 https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverha-160304102101-thumbnail.jpg?width=120&height=120&fit=bounds document Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server Memory Pressure /slideshow/sql-server-memory-pressure/58512826 sqlserverlocalmemorypressure-160221043022
SQL Server Internal and External Memory Pressure within the Plan Cache Stores.]]>
SQL Server Internal and External Memory Pressure within the Plan Cache Stores.]]> Sun, 21 Feb 2016 04:30:21 GMT /slideshow/sql-server-memory-pressure/58512826 HamidJFard@slideshare.net(HamidJFard) SQL Server Memory Pressure HamidJFard SQL Server Internal and External Memory Pressure within the Plan Cache Stores. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverlocalmemorypressure-160221043022-thumbnail.jpg?width=120&height=120&fit=bounds" /> SQL Server Internal and External Memory Pressure within the Plan Cache Stores.

SQL Server Memory Pressure from Hamid J. Fard

]]> 1206 4 https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverlocalmemorypressure-160221043022-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server In-Memory Internals and Performance Tips /slideshow/sql-server-inmemory-internals-and-performance-tips/58222851 sql-server-xtp-engine-internals-160213134009
SQL Server In-Memory (Hekaton) Engine Internals, Performance Tips, Hardware and Software Requirements to run XTP. Boost performance up to x30 in the OLTP database environment. ]]>
SQL Server In-Memory (Hekaton) Engine Internals, Performance Tips, Hardware and Software Requirements to run XTP. Boost performance up to x30 in the OLTP database environment. ]]> Sat, 13 Feb 2016 13:40:09 GMT /slideshow/sql-server-inmemory-internals-and-performance-tips/58222851 HamidJFard@slideshare.net(HamidJFard) SQL Server In-Memory Internals and Performance Tips HamidJFard SQL Server In-Memory (Hekaton) Engine Internals, Performance Tips, Hardware and Software Requirements to run XTP. Boost performance up to x30 in the OLTP database environment. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sql-server-xtp-engine-internals-160213134009-thumbnail.jpg?width=120&height=120&fit=bounds" /> SQL Server In-Memory (Hekaton) Engine Internals, Performance Tips, Hardware and Software Requirements to run XTP. Boost performance up to x30 in the OLTP database environment.

SQL Server In-Memory Internals and Performance Tips from Hamid J. Fard

]]> 773 7 https://cdn.slidesharecdn.com/ss_thumbnails/sql-server-xtp-engine-internals-160213134009-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Fard Solutions Sdn Bhd /slideshow/fard-solutions-sdn-bhd/58179813 slide-160212054741
Introduction of Fard Solutions Sdn Bhd Company and SQL Server consultation, training and managed services.]]>
Introduction of Fard Solutions Sdn Bhd Company and SQL Server consultation, training and managed services.]]> Fri, 12 Feb 2016 05:47:41 GMT /slideshow/fard-solutions-sdn-bhd/58179813 HamidJFard@slideshare.net(HamidJFard) Fard Solutions Sdn Bhd HamidJFard Introduction of Fard Solutions Sdn Bhd Company and SQL Server consultation, training and managed services. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/slide-160212054741-thumbnail.jpg?width=120&height=120&fit=bounds" /> Introduction of Fard Solutions Sdn Bhd Company and SQL Server consultation, training and managed services.

Fard Solutions Sdn Bhd from Hamid J. Fard

]]> 417 7 https://cdn.slidesharecdn.com/ss_thumbnails/slide-160212054741-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Sql server enterprise edition awareness /slideshow/sql-server-enterprise-edition-awareness/57949001 sqlserverenterpriseeditionawareness-160206095459
Why do we need to purchase SQL Server Enterprise Edition? SQL Server Enterprise Edition has few great internal features that can help any organization to run safest and fastest database environment.]]>
Why do we need to purchase SQL Server Enterprise Edition? SQL Server Enterprise Edition has few great internal features that can help any organization to run safest and fastest database environment.]]> Sat, 06 Feb 2016 09:54:59 GMT /slideshow/sql-server-enterprise-edition-awareness/57949001 HamidJFard@slideshare.net(HamidJFard) Sql server enterprise edition awareness HamidJFard Why do we need to purchase SQL Server Enterprise Edition? SQL Server Enterprise Edition has few great internal features that can help any organization to run safest and fastest database environment. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverenterpriseeditionawareness-160206095459-thumbnail.jpg?width=120&height=120&fit=bounds" /> Why do we need to purchase SQL Server Enterprise Edition? SQL Server Enterprise Edition has few great internal features that can help any organization to run safest and fastest database environment.

Sql server enterprise edition awareness from Hamid J. Fard

]]> 467 6 https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverenterpriseeditionawareness-160206095459-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Data Platform Overview /slideshow/data-platform-overview/57945058 24788b00-1ba7-49a6-9433-d70ea8ce3c6a-160206045347
]]>
]]> Sat, 06 Feb 2016 04:53:47 GMT /slideshow/data-platform-overview/57945058 HamidJFard@slideshare.net(HamidJFard) Data Platform Overview HamidJFard <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/24788b00-1ba7-49a6-9433-d70ea8ce3c6a-160206045347-thumbnail.jpg?width=120&height=120&fit=bounds" />

Data Platform Overview from Hamid J. Fard

]]> 880 4 https://cdn.slidesharecdn.com/ss_thumbnails/24788b00-1ba7-49a6-9433-d70ea8ce3c6a-160206045347-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server 2016 Everything built-in FULL deck /HamidJFard/sql-server-2016-everything-builtin-full-deck f9a59b52-e53a-49fc-9b10-9ba6e30c3a0a-160206045206
]]>
]]> Sat, 06 Feb 2016 04:52:06 GMT /HamidJFard/sql-server-2016-everything-builtin-full-deck HamidJFard@slideshare.net(HamidJFard) SQL Server 2016 Everything built-in FULL deck HamidJFard <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/f9a59b52-e53a-49fc-9b10-9ba6e30c3a0a-160206045206-thumbnail.jpg?width=120&height=120&fit=bounds" />

SQL Server 2016 Everything built-in FULL deck from Hamid J. Fard

]]> 1774 4 https://cdn.slidesharecdn.com/ss_thumbnails/f9a59b52-e53a-49fc-9b10-9ba6e30c3a0a-160206045206-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server - Inside Optimizer Engine /slideshow/sql-server-inside-optimizer-engine/55071132 corporates-151113090021-lva1-app6891
It describes the optimizer engine and the limitations with filtered indexes in SQL Server.]]>
It describes the optimizer engine and the limitations with filtered indexes in SQL Server.]]> Fri, 13 Nov 2015 09:00:21 GMT /slideshow/sql-server-inside-optimizer-engine/55071132 HamidJFard@slideshare.net(HamidJFard) SQL Server - Inside Optimizer Engine HamidJFard It describes the optimizer engine and the limitations with filtered indexes in SQL Server. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/corporates-151113090021-lva1-app6891-thumbnail.jpg?width=120&height=120&fit=bounds" /> It describes the optimizer engine and the limitations with filtered indexes in SQL Server.

SQL Server - Inside Optimizer Engine from Hamid J. Fard

]]> 374 5 https://cdn.slidesharecdn.com/ss_thumbnails/corporates-151113090021-lva1-app6891-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server Database Backup and Restore Plan /slideshow/sql-server-database-backup-and-restore-plan/55071095 sqleventdbbackupandrestore-151113085828-lva1-app6892
It describes how DBA needs to design and implement backup and restore plans in SQL Server based on agreed RTO and RPO.]]>
It describes how DBA needs to design and implement backup and restore plans in SQL Server based on agreed RTO and RPO.]]> Fri, 13 Nov 2015 08:58:28 GMT /slideshow/sql-server-database-backup-and-restore-plan/55071095 HamidJFard@slideshare.net(HamidJFard) SQL Server Database Backup and Restore Plan HamidJFard It describes how DBA needs to design and implement backup and restore plans in SQL Server based on agreed RTO and RPO. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqleventdbbackupandrestore-151113085828-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds" /> It describes how DBA needs to design and implement backup and restore plans in SQL Server based on agreed RTO and RPO.

SQL Server Database Backup and Restore Plan from Hamid J. Fard

]]> 1817 10 https://cdn.slidesharecdn.com/ss_thumbnails/sqleventdbbackupandrestore-151113085828-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server Security And Encryption /slideshow/sql-server-security-and-encryption/55071017 sqleventsecurityencryption-151113085426-lva1-app6891
It describes the few basic Security and Encryption features in SQL Server Database Engine.]]>
It describes the few basic Security and Encryption features in SQL Server Database Engine.]]> Fri, 13 Nov 2015 08:54:26 GMT /slideshow/sql-server-security-and-encryption/55071017 HamidJFard@slideshare.net(HamidJFard) SQL Server Security And Encryption HamidJFard It describes the few basic Security and Encryption features in SQL Server Database Engine. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqleventsecurityencryption-151113085426-lva1-app6891-thumbnail.jpg?width=120&height=120&fit=bounds" /> It describes the few basic Security and Encryption features in SQL Server Database Engine.

SQL Server Security And Encryption from Hamid J. Fard

]]> 595 5 https://cdn.slidesharecdn.com/ss_thumbnails/sqleventsecurityencryption-151113085426-lva1-app6891-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Server Index and Partition Strategy /slideshow/sql-server-index-and-partition-strategy/55070857 indexingpartitiontable-151113084732-lva1-app6892
It describes the benefit and overhead of indexes and how it works on partitioned table.]]>
It describes the benefit and overhead of indexes and how it works on partitioned table.]]> Fri, 13 Nov 2015 08:47:32 GMT /slideshow/sql-server-index-and-partition-strategy/55070857 HamidJFard@slideshare.net(HamidJFard) SQL Server Index and Partition Strategy HamidJFard It describes the benefit and overhead of indexes and how it works on partitioned table. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/indexingpartitiontable-151113084732-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds" /> It describes the benefit and overhead of indexes and how it works on partitioned table.

SQL Server Index and Partition Strategy from Hamid J. Fard

]]> 742 4 https://cdn.slidesharecdn.com/ss_thumbnails/indexingpartitiontable-151113084732-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 SQL Saturday #438 /slideshow/sql-saturday-438/52845034 7d3a6825-8783-4ca6-91ee-7160c99b0e7c-150916121448-lva1-app6892
]]>
]]> Wed, 16 Sep 2015 12:14:48 GMT /slideshow/sql-saturday-438/52845034 HamidJFard@slideshare.net(HamidJFard) SQL Saturday #438 HamidJFard <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/7d3a6825-8783-4ca6-91ee-7160c99b0e7c-150916121448-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds" />

SQL Saturday #438 from Hamid J. Fard

]]> 210 4 https://cdn.slidesharecdn.com/ss_thumbnails/7d3a6825-8783-4ca6-91ee-7160c99b0e7c-150916121448-lva1-app6892-thumbnail.jpg?width=120&height=120&fit=bounds presentation 000000 http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://cdn.slidesharecdn.com/profile-photo-HamidJFard-48x48.jpg?cb=1524542919 I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master, Microsoft Certified Solutions Master and CIW Database Design Specialist. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server. Key areas of work has been on: Microsoft SQL Server Administration Microsoft SQL Server Business Intelligence and Data Warehousing Microsoft SQL Server Consolidation Microsoft SQL Server Development Microsoft SQL Server High Availability and Disaster Re. http://www.hfard.com https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverbackupinternals-160421140158-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/sql-server-backup-internals/61194471 Sql server backup inte... https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverha-160304102101-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/sql-server-high-avaiability-solutions-pros-cons/59064266 SQL Server High Availa... https://cdn.slidesharecdn.com/ss_thumbnails/sqlserverlocalmemorypressure-160221043022-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/sql-server-memory-pressure/58512826 SQL Server Memory Pres...