際際滷shows by User: SQLDBApros / http://www.slideshare.net/images/logo.gif 際際滷shows by User: SQLDBApros / Tue, 11 Feb 2014 10:36:23 GMT 際際滷Share feed for 際際滷shows by User: SQLDBApros 10 SQL Server Metrics to Monitor /slideshow/10-sql-server-metrics-to-monitor/31085742 10sqlservermetricstomonitor-140211103624-phpapp01
At some point someone will ask you for metrics about your SQL Servers. Why do you want to track the installation date? If you already collect the above information and the date SQL Server was installed, you can show more information about your SQL environment, leverage it to show trends and even present it to management as an argument for hiring more DBAs. You may want also opt to use one of the SERVERPROPERTY values. SERVERPROPERTY also has a parameter that will allow you to return the edition, which may be useful for reporting on, especially if there is to be a consolidation project.]]>
At some point someone will ask you for metrics about your SQL Servers. Why do you want to track the installation date? If you already collect the above information and the date SQL Server was installed, you can show more information about your SQL environment, leverage it to show trends and even present it to management as an argument for hiring more DBAs. You may want also opt to use one of the SERVERPROPERTY values. SERVERPROPERTY also has a parameter that will allow you to return the edition, which may be useful for reporting on, especially if there is to be a consolidation project.]]> Tue, 11 Feb 2014 10:36:23 GMT /slideshow/10-sql-server-metrics-to-monitor/31085742 SQLDBApros@slideshare.net(SQLDBApros) 10 SQL Server Metrics to Monitor SQLDBApros At some point someone will ask you for metrics about your SQL Servers. Why do you want to track the installation date? If you already collect the above information and the date SQL Server was installed, you can show more information about your SQL environment, leverage it to show trends and even present it to management as an argument for hiring more DBAs. You may want also opt to use one of the SERVERPROPERTY values. SERVERPROPERTY also has a parameter that will allow you to return the edition, which may be useful for reporting on, especially if there is to be a consolidation project. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/10sqlservermetricstomonitor-140211103624-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> At some point someone will ask you for metrics about your SQL Servers. Why do you want to track the installation date? If you already collect the above information and the date SQL Server was installed, you can show more information about your SQL environment, leverage it to show trends and even present it to management as an argument for hiring more DBAs. You may want also opt to use one of the SERVERPROPERTY values. SERVERPROPERTY also has a parameter that will allow you to return the edition, which may be useful for reporting on, especially if there is to be a consolidation project.
10 SQL Server Metrics to Monitor from SQLDBApros
]]> 2907 2 https://cdn.slidesharecdn.com/ss_thumbnails/10sqlservermetricstomonitor-140211103624-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 Achieving Gold Medal Performance From SQL Server /slideshow/getting-gold-medal-performance-from-sql-server-30630676/30630676 gettinggoldmedalperformancefromsqlserver-140130112444-phpapp01
You cant go wrong by starting with these SQL Server performance tips, which offer DBAs and others detailed information on specific issues and ways to apply them to their environment.]]>
You cant go wrong by starting with these SQL Server performance tips, which offer DBAs and others detailed information on specific issues and ways to apply them to their environment.]]> Thu, 30 Jan 2014 11:24:44 GMT /slideshow/getting-gold-medal-performance-from-sql-server-30630676/30630676 SQLDBApros@slideshare.net(SQLDBApros) Achieving Gold Medal Performance From SQL Server SQLDBApros You cant go wrong by starting with these SQL Server performance tips, which offer DBAs and others detailed information on specific issues and ways to apply them to their environment. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/gettinggoldmedalperformancefromsqlserver-140130112444-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> You cant go wrong by starting with these SQL Server performance tips, which offer DBAs and others detailed information on specific issues and ways to apply them to their environment.
Achieving Gold Medal Performance From SQL Server from SQLDBApros
]]> 2169 2 https://cdn.slidesharecdn.com/ss_thumbnails/gettinggoldmedalperformancefromsqlserver-140130112444-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 12 Days of Christmas for the SQL DBA /SQLDBApros/12-days-christmas-lite-speed12-16-13v2 12dayschristmaslitespeed121613v2-131216230937-phpapp02
]]>
]]> Mon, 16 Dec 2013 23:09:37 GMT /SQLDBApros/12-days-christmas-lite-speed12-16-13v2 SQLDBApros@slideshare.net(SQLDBApros) 12 Days of Christmas for the SQL DBA SQLDBApros <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/12dayschristmaslitespeed121613v2-131216230937-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br>
12 Days of Christmas for the SQL DBA from SQLDBApros
]]> 2284 2 https://cdn.slidesharecdn.com/ss_thumbnails/12dayschristmaslitespeed121613v2-131216230937-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 What SQL Server Pros Can Get by Giving this Holiday Season /slideshow/what-sql-server-pros-can-get-by-giving-this-holiday-season/29254496 whatsqlserverproscangetbygiving-131216110233-phpapp02
]]>
]]> Mon, 16 Dec 2013 11:02:33 GMT /slideshow/what-sql-server-pros-can-get-by-giving-this-holiday-season/29254496 SQLDBApros@slideshare.net(SQLDBApros) What SQL Server Pros Can Get by Giving this Holiday Season SQLDBApros <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/whatsqlserverproscangetbygiving-131216110233-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br>
What SQL Server Pros Can Get by Giving this Holiday Season from SQLDBApros
]]> 750 2 https://cdn.slidesharecdn.com/ss_thumbnails/whatsqlserverproscangetbygiving-131216110233-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 What SQL Server Pros Can Get By Giving /slideshow/what-sql-server-pros-can-get-by-giving/29045230 whatsqlserverproscangetbygiving-131209124659-phpapp01
SQL Server folks are by nature a generous bunch: We share our knowledge reflexively, documenting the tips and strategies that help out our fellow pros in webinars, blogs and at both global and local events. If you have ever found the solution to a vexing problem by watching a SQL Server gurus detailed breakdown of a database fragmentation challenge, then youve been a been a beneficiary of our communitys giving spirit. From SQL Saturdays to Give Camp, chances are there is somebody out there who needs your knowledge. The holidays are a great time to reflect on how we can share itand be amazed at what we get back when we do.]]>
SQL Server folks are by nature a generous bunch: We share our knowledge reflexively, documenting the tips and strategies that help out our fellow pros in webinars, blogs and at both global and local events. If you have ever found the solution to a vexing problem by watching a SQL Server gurus detailed breakdown of a database fragmentation challenge, then youve been a been a beneficiary of our communitys giving spirit. From SQL Saturdays to Give Camp, chances are there is somebody out there who needs your knowledge. The holidays are a great time to reflect on how we can share itand be amazed at what we get back when we do.]]> Mon, 09 Dec 2013 12:46:59 GMT /slideshow/what-sql-server-pros-can-get-by-giving/29045230 SQLDBApros@slideshare.net(SQLDBApros) What SQL Server Pros Can Get By Giving SQLDBApros SQL Server folks are by nature a generous bunch: We share our knowledge reflexively, documenting the tips and strategies that help out our fellow pros in webinars, blogs and at both global and local events. If you have ever found the solution to a vexing problem by watching a SQL Server gurus detailed breakdown of a database fragmentation challenge, then youve been a been a beneficiary of our communitys giving spirit. From SQL Saturdays to Give Camp, chances are there is somebody out there who needs your knowledge. The holidays are a great time to reflect on how we can share itand be amazed at what we get back when we do. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/whatsqlserverproscangetbygiving-131209124659-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> SQL Server folks are by nature a generous bunch: We share our knowledge reflexively, documenting the tips and strategies that help out our fellow pros in webinars, blogs and at both global and local events. If you have ever found the solution to a vexing problem by watching a SQL Server gurus detailed breakdown of a database fragmentation challenge, then youve been a been a beneficiary of our communitys giving spirit. From SQL Saturdays to Give Camp, chances are there is somebody out there who needs your knowledge. The holidays are a great time to reflect on how we can share itand be amazed at what we get back when we do.
What SQL Server Pros Can Get By Giving from SQLDBApros
]]> 934 2 https://cdn.slidesharecdn.com/ss_thumbnails/whatsqlserverproscangetbygiving-131209124659-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 SunBridge Ensures the Health of their SQL Server Database with Solutions from Dell /slideshow/tv-cs1/28866638 tvcs1-131203213637-phpapp01
]]>
]]> Tue, 03 Dec 2013 21:36:37 GMT /slideshow/tv-cs1/28866638 SQLDBApros@slideshare.net(SQLDBApros) SunBridge Ensures the Health of their SQL Server Database with Solutions from Dell SQLDBApros <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/tvcs1-131203213637-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br>
SunBridge Ensures the Health of their SQL Server Database with Solutions from Dell from SQLDBApros
]]> 759 2 https://cdn.slidesharecdn.com/ss_thumbnails/tvcs1-131203213637-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds document Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 DBA SQL Health Check-up /slideshow/schwartz-health-info/28678106 schwartzhealthinfo-131127101158-phpapp02
]]>
]]> Wed, 27 Nov 2013 10:11:58 GMT /slideshow/schwartz-health-info/28678106 SQLDBApros@slideshare.net(SQLDBApros) DBA SQL Health Check-up SQLDBApros <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/schwartzhealthinfo-131127101158-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br>
DBA SQL Health Check-up from SQLDBApros
]]> 986 2 https://cdn.slidesharecdn.com/ss_thumbnails/schwartzhealthinfo-131127101158-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds document Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 SQL Server Backup and Recovery Challenges /slideshow/sql-backup-and-recovery-challenges/27698051 sqlbackupandrecoverychallenges-131029111932-phpapp01
There are many important things to consider when planning out your SQL Server backup and SQL Server recovery environments. We will introduce some of the common challenges in this presentation. Data change and file retention issues arise when using SQL Server differentiation.]]>
There are many important things to consider when planning out your SQL Server backup and SQL Server recovery environments. We will introduce some of the common challenges in this presentation. Data change and file retention issues arise when using SQL Server differentiation.]]> Tue, 29 Oct 2013 11:19:31 GMT /slideshow/sql-backup-and-recovery-challenges/27698051 SQLDBApros@slideshare.net(SQLDBApros) SQL Server Backup and Recovery Challenges SQLDBApros There are many important things to consider when planning out your SQL Server backup and SQL Server recovery environments. We will introduce some of the common challenges in this presentation. Data change and file retention issues arise when using SQL Server differentiation. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlbackupandrecoverychallenges-131029111932-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> There are many important things to consider when planning out your SQL Server backup and SQL Server recovery environments. We will introduce some of the common challenges in this presentation. Data change and file retention issues arise when using SQL Server differentiation.
SQL Server Backup and Recovery Challenges from SQLDBApros
]]> 1752 4 https://cdn.slidesharecdn.com/ss_thumbnails/sqlbackupandrecoverychallenges-131029111932-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 Cache issues from T-SQL-generated Plans and How to Manage Them /slideshow/richard-douglas-wc-plan-cache/27494730 richarddouglaswcplancache-131023101246-phpapp02
Cache issues from T-SQL-generated plans and how to manage them. Webcast by Richard Douglas. To view the recorded webcast, click here:http://dell.to/1fVgKSp Looking for a foolproof way to improve SQL Server performance? Youll find it by intelligently managing cashed plans that T-SQL code generates. T-SQL code is different from many other languages; you tell it "what" to do and the optimisation engine interprets that command into "how" to do it, then files that information away. Join Dell SQL Server experts as they explain the concepts that support the storage of these how-to plans, ways to determine what has been stored, and how to create efficiency at both the database and all-important server level. This educational session will cover: Concepts behind cashed plans How to find out whats been stored How to create efficiencies at both query and server levels And much more ]]>
Cache issues from T-SQL-generated plans and how to manage them. Webcast by Richard Douglas. To view the recorded webcast, click here:http://dell.to/1fVgKSp Looking for a foolproof way to improve SQL Server performance? Youll find it by intelligently managing cashed plans that T-SQL code generates. T-SQL code is different from many other languages; you tell it "what" to do and the optimisation engine interprets that command into "how" to do it, then files that information away. Join Dell SQL Server experts as they explain the concepts that support the storage of these how-to plans, ways to determine what has been stored, and how to create efficiency at both the database and all-important server level. This educational session will cover: Concepts behind cashed plans How to find out whats been stored How to create efficiencies at both query and server levels And much more ]]> Wed, 23 Oct 2013 10:12:45 GMT /slideshow/richard-douglas-wc-plan-cache/27494730 SQLDBApros@slideshare.net(SQLDBApros) Cache issues from T-SQL-generated Plans and How to Manage Them SQLDBApros Cache issues from T-SQL-generated plans and how to manage them. Webcast by Richard Douglas. To view the recorded webcast, click here:http://dell.to/1fVgKSp Looking for a foolproof way to improve SQL Server performance? Youll find it by intelligently managing cashed plans that T-SQL code generates. T-SQL code is different from many other languages; you tell it "what" to do and the optimisation engine interprets that command into "how" to do it, then files that information away. Join Dell SQL Server experts as they explain the concepts that support the storage of these how-to plans, ways to determine what has been stored, and how to create efficiency at both the database and all-important server level. This educational session will cover: Concepts behind cashed plans How to find out whats been stored How to create efficiencies at both query and server levels And much more <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/richarddouglaswcplancache-131023101246-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> Cache issues from T-SQL-generated plans and how to manage them. Webcast by Richard Douglas. To view the recorded webcast, click here:http://dell.to/1fVgKSp Looking for a foolproof way to improve SQL Server performance? Youll find it by intelligently managing cashed plans that T-SQL code generates. T-SQL code is different from many other languages; you tell it &quot;what&quot; to do and the optimisation engine interprets that command into &quot;how&quot; to do it, then files that information away. Join Dell SQL Server experts as they explain the concepts that support the storage of these how-to plans, ways to determine what has been stored, and how to create efficiency at both the database and all-important server level. This educational session will cover: Concepts behind cashed plans How to find out whats been stored How to create efficiencies at both query and server levels And much more
Cache issues from T-SQL-generated Plans and How to Manage Them from SQLDBApros
]]> 840 4 https://cdn.slidesharecdn.com/ss_thumbnails/richarddouglaswcplancache-131023101246-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 I got 99 Problems but my backup ain't one by Richard Douglas /SQLDBApros/99-problems-v2 99problemsv2-131017124413-phpapp01
In this session, youll gain invaluable guidance for optimizing your backup and recovery efforts. Richard Douglas will show you how to dramatically accelerate backups, perform faster recoveries, and ensure your organizations critical data is always protected. Plus, youll learn tricks and tips to master database monitoring and benchmarking to achieve peak system performance.]]>
In this session, youll gain invaluable guidance for optimizing your backup and recovery efforts. Richard Douglas will show you how to dramatically accelerate backups, perform faster recoveries, and ensure your organizations critical data is always protected. Plus, youll learn tricks and tips to master database monitoring and benchmarking to achieve peak system performance.]]> Thu, 17 Oct 2013 12:44:13 GMT /SQLDBApros/99-problems-v2 SQLDBApros@slideshare.net(SQLDBApros) I got 99 Problems but my backup ain't one by Richard Douglas SQLDBApros In this session, youll gain invaluable guidance for optimizing your backup and recovery efforts. Richard Douglas will show you how to dramatically accelerate backups, perform faster recoveries, and ensure your organizations critical data is always protected. Plus, youll learn tricks and tips to master database monitoring and benchmarking to achieve peak system performance. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/99problemsv2-131017124413-phpapp01-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br> In this session, youll gain invaluable guidance for optimizing your backup and recovery efforts. Richard Douglas will show you how to dramatically accelerate backups, perform faster recoveries, and ensure your organizations critical data is always protected. Plus, youll learn tricks and tips to master database monitoring and benchmarking to achieve peak system performance.
I got 99 Problems but my backup ain't one by Richard Douglas from SQLDBApros
]]> 572 2 https://cdn.slidesharecdn.com/ss_thumbnails/99problemsv2-131017124413-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 Are the Native SQL Server Backup Utilities Holding You Back? /slideshow/are-the-native-sql-server-backup-utilities-holding/26840027 arethenativesqlserverbackuputilitiesholding-131003154946-phpapp02
]]>
]]> Thu, 03 Oct 2013 15:49:46 GMT /slideshow/are-the-native-sql-server-backup-utilities-holding/26840027 SQLDBApros@slideshare.net(SQLDBApros) Are the Native SQL Server Backup Utilities Holding You Back? SQLDBApros <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/arethenativesqlserverbackuputilitiesholding-131003154946-phpapp02-thumbnail.jpg?width=120&amp;height=120&amp;fit=bounds" /><br>
Are the Native SQL Server Backup Utilities Holding You Back? from SQLDBApros
]]> 820 3 https://cdn.slidesharecdn.com/ss_thumbnails/arethenativesqlserverbackuputilitiesholding-131003154946-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post http://activitystrea.ms/schema/1.0/posted 1 https://cdn.slidesharecdn.com/profile-photo-SQLDBApros-48x48.jpg?cb=1523606911 https://cdn.slidesharecdn.com/ss_thumbnails/10sqlservermetricstomonitor-140211103624-phpapp01-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/10-sql-server-metrics-to-monitor/31085742 10 SQL Server Metrics ... https://cdn.slidesharecdn.com/ss_thumbnails/gettinggoldmedalperformancefromsqlserver-140130112444-phpapp01-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/getting-gold-medal-performance-from-sql-server-30630676/30630676 Achieving Gold Medal P... https://cdn.slidesharecdn.com/ss_thumbnails/12dayschristmaslitespeed121613v2-131216230937-phpapp02-thumbnail.jpg?width=320&height=320&fit=bounds SQLDBApros/12-days-christmas-lite-speed12-16-13v2 12 Days of Christmas f...