tag:blogger.com,1999:blog-20763261769802210382024-02-20T04:29:44.743-05:00Ronald Dameron - IT beats loading bombsIT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.comBlogger80125tag:blogger.com,1999:blog-2076326176980221038.post-314689593571591062020-05-16T17:24:00.001-04:002020-05-16T17:24:55.449-04:00Set Azure App Service Platform Configuration to 64 bit.<font face="arial">If you need to update several Azure App Services' Configuration to change the Platform setting from 32 bit to 64 bit under Configuration | General settings, this script will save you about six clicks per service and you won't forget to press the SAVE button. Ask me I know. 🙄</font><div><font face="arial"><br /></font></div><div style="text-align: left;"><div style="background-color: white; font-family: consolas, "courier new", monospace; font-size: 14px; line-height: 19px; white-space: pre;"><pre>Login-AzureRmAccount<br /><span style="color: #795e26;">Set-AzureRmContext</span> -SubscriptionName <span style="color: #a31515;">"Your Subscription"</span><br /><span style="color: #001080;">$ResourceGroupName</span> = <span style="color: #a31515;">'RG1'</span>, <span style="color: #a31515;">'RG2', 'RG3'</span><br /><span style="color: #af00db;">foreach</span> (<span style="color: #001080;">$g</span> <span style="color: #af00db;">in</span> <span style="color: #001080;">$ResourceGroupName</span>)<br />{ <br /> <span style="color: green;"># Set PROD slot to use 64 bit Platform Setting<br /></span> <span style="color: #795e26;">Get-AzureRmWebApp</span> -ResourceGroupName <span style="color: #001080;">$g</span> | Select Name | <span style="color: #af00db;">%</span> { <span style="color: #795e26;">Set-AzureRmWebApp</span> -ResourceGroupName <span style="color: #001080;">$g</span> -Name <span style="color: #001080;">$_</span><span style="color: #795e26;">.Name</span> -Use32BitWorkerProcess <span style="color: blue;">$false</span> } <br /> <span style="color: green;"># Set staging slot to use 64 bit Platform setting<br /></span> <span style="color: #795e26;">Get-AzureRmWebApp</span> -ResourceGroupName <span style="color: #001080;">$g</span> | Select Name | <span style="color: #af00db;">%</span> { <span style="color: #795e26;">Set-AzureRmWebAppSlot</span> -ResourceGroupName <span style="color: #001080;">$g</span> -Name <span style="color: #001080;">$_</span><span style="color: #795e26;">.Name</span> -Slot <span style="color: #a31515;">"staging"</span> -Use32BitWorkerProcess <span style="color: blue;">$false</span> } <br />}</pre></div></div><div style="text-align: left;"><font face="arial"><br /></font><div><font face="arial"><br /></font></div><div><font face="arial"><br /></font></div></div>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-45788379933958041552019-09-19T14:13:00.001-04:002019-09-19T14:13:36.027-04:00AzureRM Templates 101<span style="font-family: Verdana, sans-serif;">I've recently started working with AzureRM templates to build new environments.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">This document really helped me understand the template structure when I first started looking at them.</span><br />
<a href="https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-authoring-templates">https://docs.microsoft.com/en-us/azure/azure-resource-manager/resource-group-authoring-templates</a><br />
<br />
<span style="font-family: Verdana, sans-serif;">I love examples when I'm trying to learn something new and the Quick Start templates are the mother lode. </span><br />
<a href="https://github.com/Azure/azure-quickstart-templates">https://github.com/Azure/azure-quickstart-templates</a><br />
<br />
<span style="font-family: Verdana, sans-serif;">Our goal is to incorporate our templates into an Azure Blueprint so that we can quickly build new environments when needed. </span><span style="font-family: Verdana, sans-serif;">AzureRM templates can be artifacts of a blueprint.</span><br />
<a href="https://docs.microsoft.com/en-us/azure/governance/blueprints/overview">https://docs.microsoft.com/en-us/azure/governance/blueprints/overview</a><br />
<br />
<br />IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-68126334210299639352018-01-27T06:58:00.000-05:002018-01-27T06:58:06.722-05:00Uptight Database Security scripts on Github now<span style="font-family: Verdana, sans-serif;">To all of you who attended my GroupBy <a href="https://groupby.org/conference-session-abstracts/uptight-database-security/" target="_blank">session</a> "Uptight Database Security", I have placed the scripts for that presentation on Github. You can find them here, <a href="https://github.com/rdameron/SQL">https://github.com/rdameron/SQL</a></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Thank you again for attending my session.</span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-71303167957324530822017-10-17T12:20:00.000-04:002017-10-17T12:20:43.709-04:00Modifying Endpoint URLs on Availability Group Replicas<span style="font-family: "verdana" , sans-serif;">I recently had to modify the Endpoint URLs on our SQL Server Availability Group replicas. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The reason for this blog post is that I could not answer the following questions:</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><i>Do I need to suspend data movement prior to making this change? </i></span><br />
<span style="font-family: "verdana" , sans-serif;"><i><br /></i></span>
<span style="font-family: "verdana" , sans-serif;"><i>Would this change require a restart of the database instance?</i></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">I spent enough time searching on my own to no avail that I tossed the question to the #sqlhelp hashtag on Twitter and Slack but didn't get an answer prior to executing the change request.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span><span style="font-family: "verdana" , sans-serif;">After reading the relevant documentation, I think it's probably a good idea to suspend data movement for this change.</span><br />
<br />
<span style="font-family: "verdana" , sans-serif;">The T-SQL is straightforward. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">USE MASTER</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">GO</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">ALTER AVAILABILITY GROUP [AG1] </span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">MODIFY REPLICA ON 'SQL2012-1' WITH (ENDPOINT_URL = 'TCP://10.10.10.1:5022');</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">ALTER AVAILABILITY GROUP [AG1] </span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">MODIFY REPLICA ON 'SQL2012-2' WITH (ENDPOINT_URL = 'TCP://10.10.10.2:5022');</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">ALTER AVAILABILITY GROUP [AG2] </span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">MODIFY REPLICA ON 'SQL2012-1' WITH (ENDPOINT_URL = 'TCP://10.10.10.1:5022');</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">ALTER AVAILABILITY GROUP [AG2] </span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">MODIFY REPLICA ON 'SQL2012-2' WITH (ENDPOINT_URL = 'TCP://10.10.10.2:5022');</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">ALTER AVAILABILITY GROUP [AG3] </span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">MODIFY REPLICA ON 'SQL2012-1' WITH (ENDPOINT_URL = 'TCP://10.10.10.1:5022');</span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;"><br /></span>
<span style="color: blue; font-family: "verdana" , sans-serif;">ALTER AVAILABILITY GROUP [AG3] </span><br />
<span style="color: blue; font-family: "verdana" , sans-serif;">MODIFY REPLICA ON 'SQL2012-2' WITH (ENDPOINT_URL = 'TCP://10.10.10.2:5022');</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">I completed this change successfully last night. I suspended data movement for each replica prior to executing their respective ALTER. I'm not sure suspending data movement was required but it didn't hurt. </span><br />
<span style="font-family: "verdana" , sans-serif;"><b>This change did not require a restart of the SQL instance. </b></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-65964532457451755152017-09-05T07:26:00.000-04:002017-09-05T07:26:27.472-04:00Uptight Database Security<span style="font-family: Verdana, sans-serif;">If you need a practical approach to managing database administrator access without always granting the sysadmin role to your database administrators then I encourage you to vote for my <a href="https://groupby.org/" target="_blank">GroupBy</a> session for the December lineup. </span><div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><a href="https://groupby.org/conference-session-abstracts/uptight-database-security/">https://groupby.org/conference-session-abstracts/uptight-database-security/</a></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<div>
<span style="font-family: Verdana, sans-serif;">As the SQL Server security model has become more granular, it is now easier to do routine database administration without sysadmin access. </span><span style="font-family: Verdana, sans-serif;">Starting with SQL Server 2005, </span><span style="font-family: Verdana, sans-serif;">administering SQL Server without sysadmin access is now possible for many of the typical DBA tasks.</span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">For example, a DBA only needs the ALTER SETTINGS permission to use the sp_configure command on a database instance. To run SELECT queries on Database Management Views requires either VIEW SERVER STATE or VIEW DATABASE STATE depending on the DMV being queried. To use Query Store requires only VIEW DATABASE STATE. CONTROL SERVER can be granted to DBAs that allows them to do almost all the tasks that sysadmin allows but unlike the sysadmin role, it can be DENYED access to data that the business considers sensitive.</span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">This session will review a proven process for managing database administrators permissions without giving uncontrolled sysadmin access.</span></div>
</div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">If you want more practical advice on how to manage database administrator access, <a href="https://groupby.org/conference-session-abstracts/vote-now-to-pick-the-december-groupby-conference-lineup/" target="_blank">vote</a> for this session.</span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;">Thank you for your consideration.</span></div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span><div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span><div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Verdana, sans-serif;"> </span></div>
</div>
</div>
</div>
IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-42208947527408082502017-06-05T13:18:00.000-04:002017-06-14T12:06:19.132-04:00Azure Portal CPU Graph Bug or Feature?<span style="font-family: "verdana" , sans-serif;">I support an Azure PaaS application.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">We had a brief outage recently.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Given that the code had not been changed in a month, we suspected some maintenance in an Azure data center stepped on our application.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Ping tests and self-tests failed for approximately 10 minutes.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The outage resolved on its own without intervention.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">I submitted a ticket to Azure Support to determine the cause of the outage but the reason I'm writing this post is because of the behavior I observed with the CPU graphs for Cloud Services while investigating the outage.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><b>The CPU graphs show different results depending on the time range selected.</b></span><br />
<span style="font-family: "verdana" , sans-serif;"><b><br /></b></span>
<span style="font-family: "verdana" , sans-serif;">I would expect to see the CPU spike with the same value no matter what time range I selected. But, to see the spike that fired the alert, I had to to "Edit" the chart and select different time ranges to see the differences. It wasn't until I selected a narrow custom time range that the CPU graph would display the CPU spike that corresponded to the alert firing. The alert fires if the CPU percentage exceeds 80% over 15 minutes. </span><span style="font-family: "verdana" , sans-serif;">So, if you "know" something happened, try different time ranges but especially the custom range to find what you are looking for.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">This behavior has been documented and forwarded to the Azure portal team for review. It appears in both the Classic and current Azure portal.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The response from Azure Support when I raised this concern.</span><br />
<span style="color: #2f5597; font-family: "verdana" , sans-serif;">"I have had discussion with our
Azure UI team and Azure Monitoring team regarding the portal graph.</span><br />
<div class="MsoNormal">
<br /></div>
<div class="MsoNormal">
<span style="color: #2f5597;"><span style="font-family: "verdana" , sans-serif;">As they mentioned, When we look
at the 24 hours of data in the portal, the data is aggregated at 1 hour
granularity and the average is shown. Similar is the case for 1 week of data
shown on the portal. Since the spike exist for 5 to 10 minutes, we need to see
the custom data option instead of using the 24 hour and 1 week. These 24 hours/
1 week graph will be h</span></span><span style="color: #2f5597; font-family: "verdana" , sans-serif;">elpful when you have spike for
more than an hour."</span></div>
<div class="MsoNormal">
<span style="color: #2f5597; font-family: "verdana" , sans-serif;"><br /></span></div>
<div class="MsoNormal">
<span style="font-family: "verdana" , sans-serif;">The CPU spikes are lower in the graphs that have a longer time range because of the aggregation and averaging. </span><span style="font-family: "verdana" , sans-serif;">This is not a bug with the Azure graphs, it's a feature. ;-)</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3LJTGuXKmBmztS3F1dKFnzwCEwIMpZTKcMpwftHIq8C9N4zHD0i4zoSn0lJSfhcF_9jcDSwe_obUaHRxWGp3iXVibdNohCJian3XY-ti9mEDwj9I77FG7b-EkQqQwW5GNxXkgllrHgrI/s1600/cabatt-webapp-classic-portal-crop.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="317" data-original-width="954" height="106" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiK3LJTGuXKmBmztS3F1dKFnzwCEwIMpZTKcMpwftHIq8C9N4zHD0i4zoSn0lJSfhcF_9jcDSwe_obUaHRxWGp3iXVibdNohCJian3XY-ti9mEDwj9I77FG7b-EkQqQwW5GNxXkgllrHgrI/s320/cabatt-webapp-classic-portal-crop.jpg" width="320" /></a></div>
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-Er0mzGLBexFPQ9pVFuCz0XEndSub5FLNy065LaH_lJmRXQ4vjDVYnlLmraes5tre-csu0v100Pbpk5M4Mml2teGjWffH-yzMFQyy7vMdvsphmzPSo1ZluCciN4yCr4_kXIkfZoBYWu0p/s1600/cabatt-webapp-cpu-last-week-blur.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="332" data-original-width="490" height="216" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-Er0mzGLBexFPQ9pVFuCz0XEndSub5FLNy065LaH_lJmRXQ4vjDVYnlLmraes5tre-csu0v100Pbpk5M4Mml2teGjWffH-yzMFQyy7vMdvsphmzPSo1ZluCciN4yCr4_kXIkfZoBYWu0p/s320/cabatt-webapp-cpu-last-week-blur.jpg" width="320" /></a></div>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhSToMM2IfMT0lrk1MRADfvIAn_HcRYUWio4BCAbdxpfjyHvZm8UfPnUzc89xBYqiUD9iA4tKg0DGdUTfzgodpvNS0s6j4MxIM3vmqbZzKvJLTBgDZtFR1KtZVQKnaASWMEJh0r3earYLe/s1600/cabatt-webapp-cpu-crop.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" data-original-height="305" data-original-width="432" height="225" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhhSToMM2IfMT0lrk1MRADfvIAn_HcRYUWio4BCAbdxpfjyHvZm8UfPnUzc89xBYqiUD9iA4tKg0DGdUTfzgodpvNS0s6j4MxIM3vmqbZzKvJLTBgDZtFR1KtZVQKnaASWMEJh0r3earYLe/s320/cabatt-webapp-cpu-crop.jpg" width="320" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-61324764899843434662017-01-11T10:05:00.000-05:002017-01-11T10:05:06.747-05:00Rediscovering SQL Server Agent Alerts...<span style="font-family: "verdana" , sans-serif;">Having moved from a Fortune 50 company using BMC Patrol for SQL Server Monitoring to a small software company of less than 200 people, I'm rediscovering SQL Server Agent Alerts.</span><br />
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;">Why might you ask? Because small companies can't afford expensive tools and need to use the out-of-the-box features as much as possible.</span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;">This past week, I rediscovered that you can alert on SQL Server performance conditions using SQL Server Agent. I needed to alert on database transaction log usage. </span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">How to create SQL Server Agent alerts can be found at the link below.</span></div>
<div>
<a href="https://draft.blogger.com/goog_1665626017"><br /></a>
<a href="https://msdn.microsoft.com/en-us/library/ms180982.aspx"><span style="font-family: Verdana, sans-serif;">https://msdn.microsoft.com/en-us/library/ms180982.aspx</span></a><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Under Options, I suggest you set a delay of 10 minutes. Unless you like to be spammed every minute when bad things happen.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">I'm hoping it will provide enough notice to prevent an undesirable event from complicating my life.</span><br />
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<span style="font-family: "verdana" , sans-serif;"></span>
<span style="font-family: "verdana" , sans-serif;">Do this before your storage runs out of space on a holiday. ;-)</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjkY-xFqah2701F1oZQGtwFy2eAjwJPP0ecVqxmVNFlxVAPGozL07YRo1Lc28P0I7aDBVaPJTMpjcBhw6LfV8vnCvI70q1PNhHlZzZvv-3pUqm_vTqL9y-oJG6GZdaHK_aLXhFqZvBCucB/s1600/AW2012LogUsedAlert.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="289" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjkY-xFqah2701F1oZQGtwFy2eAjwJPP0ecVqxmVNFlxVAPGozL07YRo1Lc28P0I7aDBVaPJTMpjcBhw6LfV8vnCvI70q1PNhHlZzZvv-3pUqm_vTqL9y-oJG6GZdaHK_aLXhFqZvBCucB/s320/AW2012LogUsedAlert.JPG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfMic4Gf8feLTs1fDKapArMJNJgJdoeMJwDePqQQ2RP27JAX25z-DPvjAzUtqYzlk7AC6syH4rE05HhFnDwhYqgyEk1StczedmrFtAGB9UgpfIcuOsSdKygI6IM9DAyzkDi1TyanC0Jayr/s1600/AgentAlert1488.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgfMic4Gf8feLTs1fDKapArMJNJgJdoeMJwDePqQQ2RP27JAX25z-DPvjAzUtqYzlk7AC6syH4rE05HhFnDwhYqgyEk1StczedmrFtAGB9UgpfIcuOsSdKygI6IM9DAyzkDi1TyanC0Jayr/s1600/AgentAlert1488.JPG" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-34988711399387297782016-06-26T08:27:00.000-04:002016-06-26T08:27:52.997-04:00If at first you don't connect, try again...<br />
<span style="font-family: Verdana, sans-serif;">I've noticed on several occasions that my first attempt to connect to an Azure Sql Server using SQL Server Management Studio 2016 doesn't always succeed.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHTmMmPXpPVpeiF7yRC1zxLItGcSmmzvaFEo257gOQ4BDYngfHwbXXK3NgvjDUiS2aFJJ6nYRnVs1AroXYSFLsPqffmNeJrbvL0lQHdYfLw0dTkC5aBlurGcYToDwSlBv0nXqpAMZz44yh/s1600/FirstTryConnectFail.JPG" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="227" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjHTmMmPXpPVpeiF7yRC1zxLItGcSmmzvaFEo257gOQ4BDYngfHwbXXK3NgvjDUiS2aFJJ6nYRnVs1AroXYSFLsPqffmNeJrbvL0lQHdYfLw0dTkC5aBlurGcYToDwSlBv0nXqpAMZz44yh/s640/FirstTryConnectFail.JPG" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">First attempt</td></tr>
</tbody></table>
</div>
<br />
<br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The fix? Press OK and try again. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilRkb3WIJim-b-ZjjL5IwA5fubvi3UJKjm80s_k9GGktmC3UUUW0KrqlL2HAAY7N89Tg8V8i8vwmwhATiitUWpC0aHwX6RAqLSmbrSZEK8r8A_c2NMhGTUgmpM0oJlQEO9ieNWNAJLUtDn/s1600/ConnectToServer.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEilRkb3WIJim-b-ZjjL5IwA5fubvi3UJKjm80s_k9GGktmC3UUUW0KrqlL2HAAY7N89Tg8V8i8vwmwhATiitUWpC0aHwX6RAqLSmbrSZEK8r8A_c2NMhGTUgmpM0oJlQEO9ieNWNAJLUtDn/s1600/ConnectToServer.JPG" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">I have no explanation but it</span><span style="font-family: Verdana, sans-serif;"> always seems to connect the second time.</span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjts3HgW9F0ogDL1MtYc-d46O0jtkAB8eu_X7qZzNknYptoBlAVp248T08TTs3iUlrqJmYmkcBemaMZQxtBOBKs8ppwRKVbqM2K43Z1viSib2d2IoCABTmSilxlfJHyk8W0yWsc7ka_juuI/s1600/Connected.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="349" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjts3HgW9F0ogDL1MtYc-d46O0jtkAB8eu_X7qZzNknYptoBlAVp248T08TTs3iUlrqJmYmkcBemaMZQxtBOBKs8ppwRKVbqM2K43Z1viSib2d2IoCABTmSilxlfJHyk8W0yWsc7ka_juuI/s640/Connected.JPG" width="640" /></a></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div style="text-align: left;">
<br /></div>
<div style="text-align: left;">
<span style="font-family: Verdana, sans-serif;">I'm assuming you have your security and firewall rules setup correctly.</span></div>
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjts3HgW9F0ogDL1MtYc-d46O0jtkAB8eu_X7qZzNknYptoBlAVp248T08TTs3iUlrqJmYmkcBemaMZQxtBOBKs8ppwRKVbqM2K43Z1viSib2d2IoCABTmSilxlfJHyk8W0yWsc7ka_juuI/s1600/Connected.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjts3HgW9F0ogDL1MtYc-d46O0jtkAB8eu_X7qZzNknYptoBlAVp248T08TTs3iUlrqJmYmkcBemaMZQxtBOBKs8ppwRKVbqM2K43Z1viSib2d2IoCABTmSilxlfJHyk8W0yWsc7ka_juuI/s1600/Connected.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjts3HgW9F0ogDL1MtYc-d46O0jtkAB8eu_X7qZzNknYptoBlAVp248T08TTs3iUlrqJmYmkcBemaMZQxtBOBKs8ppwRKVbqM2K43Z1viSib2d2IoCABTmSilxlfJHyk8W0yWsc7ka_juuI/s1600/Connected.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><br /></a>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-49332194768787354202016-04-13T20:57:00.000-04:002016-04-21T07:17:21.421-04:00Azure Status Alerts via Outlook Rules<div>
<span style="font-family: "verdana" , sans-serif;">My current duties involve production support for an Azure PaaS application, therefore, I must know when Microsoft Azure services are experiencing issues.</span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;">I do have alerts set up on the Azure <a href="https://portal.azure.com/" target="_blank">portal </a>and in <a href="https://azure.microsoft.com/en-us/services/application-insights/" target="_blank">Application Insights</a> to notify me when availability or performance thresholds are violated but I also need to know if there is a global or regional issue that might affect our app so that I can respond and notify the staff when appropriate. Azure status changes are reported on the Azure Status web <a href="https://azure.microsoft.com/en-us/status/" target="_blank">page</a>.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">The following will describe how to use the Azure Status page RSS feeds and Outlook rules for notification if things go sideways in Microsoft Azure.</span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;">The Azure Status page has RSS feeds for nearly all of its services. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9BP01x7Y8DgGR6ihjIePHhDD5T3MkfIn48kQ4SBKqW7e_ygR3k3tpaDqm9s0W1vhyphenhyphenZ2AKHhKjtIelzNrmU25_S0WjLfBGjwenVEiJzvrqp7JNjOnouEPlZu0k8RAnrLvxNoIQFMNK25jp/s1600/AzureStatusPage.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="331" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh9BP01x7Y8DgGR6ihjIePHhDD5T3MkfIn48kQ4SBKqW7e_ygR3k3tpaDqm9s0W1vhyphenhyphenZ2AKHhKjtIelzNrmU25_S0WjLfBGjwenVEiJzvrqp7JNjOnouEPlZu0k8RAnrLvxNoIQFMNK25jp/s640/AzureStatusPage.JPG" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKEZ0Lmd-HugPQHV_06BG1YMh3HuAVJldr1IgWvB5esOOCnf_lT6I738rYBKfVAyNrV1cIIjUBHFAnfq-rAE4Y2f25VBrkysPyto1ZdbfdADpUy72M8yPfP_wu95JioXj6BolD5zU7Efbs/s1600/AzureStatusFeeds.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="379" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiKEZ0Lmd-HugPQHV_06BG1YMh3HuAVJldr1IgWvB5esOOCnf_lT6I738rYBKfVAyNrV1cIIjUBHFAnfq-rAE4Y2f25VBrkysPyto1ZdbfdADpUy72M8yPfP_wu95JioXj6BolD5zU7Efbs/s640/AzureStatusFeeds.JPG" width="640" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">First, </span><span style="font-family: "verdana" , sans-serif;">You'll need to add relevant feeds to the RSS Feeds folder in Outlook. I am using Outlook 2016. </span><br />
<span style="font-family: "verdana" , sans-serif;">Click on the orange RSS feed icon for each service you are interested in to show the feed URL, copy the URL, and add to your Outlook RSS Feeds folder by right-clicking the RSS Feeds folder. This brings up a context menu where you can select "Add a New RSS Feed...". </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA2LRhOLCv2jNrQOgfBtpSW0VRON2FdT_FtcC-IJi4OECrmzq6r9g4fka7YecbH7Yklna9zQObfCVnAJYnOz9k7uUZ4Soshe_AZv6om0viLucQrfUYqeR-J4Y6tvp85XVXRrwlP4z7Tl-I/s1600/AddNewRSSFeed.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="58" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjA2LRhOLCv2jNrQOgfBtpSW0VRON2FdT_FtcC-IJi4OECrmzq6r9g4fka7YecbH7Yklna9zQObfCVnAJYnOz9k7uUZ4Soshe_AZv6om0viLucQrfUYqeR-J4Y6tvp85XVXRrwlP4z7Tl-I/s400/AddNewRSSFeed.JPG" width="400" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Enter the URL for the feed in the dialog box and click Add.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb_s3Quz5ytSNeTJQdDbWNyPBJfvFcZvPIpeY3fZfPekTUJ_GaHSZsGE8bNsAty-fxcEJwKbxfr6lw4MhOa3iEu4njugh7g2Y6cITLayPzwgVMbM-VRNCBfcgQBhcamwZUgmKhi8r_jLep/s1600/NewRSSFeedDialog.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="147" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjb_s3Quz5ytSNeTJQdDbWNyPBJfvFcZvPIpeY3fZfPekTUJ_GaHSZsGE8bNsAty-fxcEJwKbxfr6lw4MhOa3iEu4njugh7g2Y6cITLayPzwgVMbM-VRNCBfcgQBhcamwZUgmKhi8r_jLep/s400/NewRSSFeedDialog.JPG" width="400" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span><br />
<span style="font-family: "verdana" , sans-serif;">Here's what my RSS Feeds folder in Outlook looks like currently.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-brzSaMhH2I7QwmTlUFwe6LbPmyjYlEac11zczgn_wHVpgssgFzc7RiBju33S2C7Ljq6SECpKnmaOUPSruyNzhr0H82CauXFCLYnUjL7isC_Peuuzrs20H2NyhcxZy0FtLAxxqaEpcq1N/s1600/AzureStatusRSS.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="330" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-brzSaMhH2I7QwmTlUFwe6LbPmyjYlEac11zczgn_wHVpgssgFzc7RiBju33S2C7Ljq6SECpKnmaOUPSruyNzhr0H82CauXFCLYnUjL7isC_Peuuzrs20H2NyhcxZy0FtLAxxqaEpcq1N/s400/AzureStatusRSS.JPG" width="400" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Then, create rules to <b>forward </b>a copy of the RSS posts to your Inbox so that Outlook will notify you when an Azure Status change has occurred. You will <b>NOT</b> be notified if you simply move a copy to your Inbox. Outlook notifies me when new mail arrives in my Inbox on both my laptop and mobile phone.</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic2i6ufxHCmoev4YmyRIAT0kDwTP-jMSvAJNK_JM2ZOcEwehOdhG9WVlYCAG09g91BZqgIFoTAz099ZtSw1Y-tWrf3k_S7ywa-6_icrFn_e25sdbgUbEuYJubZaANhuIODpNtTGeO-pHOs/s1600/AzureStatusRule.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="400" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEic2i6ufxHCmoev4YmyRIAT0kDwTP-jMSvAJNK_JM2ZOcEwehOdhG9WVlYCAG09g91BZqgIFoTAz099ZtSw1Y-tWrf3k_S7ywa-6_icrFn_e25sdbgUbEuYJubZaANhuIODpNtTGeO-pHOs/s400/AzureStatusRule.JPG" width="323" /></a></div>
<span style="font-family: "verdana" , sans-serif;"><br /></span></div>
<div>
<span style="font-family: "verdana" , sans-serif;"><span style="font-family: "verdana" , sans-serif;"><br /></span></span></div>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">You must check the box in red below for these rules to work properly.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO9qL8byiew9MH8q2KwCC7T8AjrHp63AKRHJicx1GNviWcnBRrJTDc69ZawKDNcylrpYpI6s8KKMSgXYV7AiTjmL36mqpiqem5K9tvzPMGkv5dIUm_7x35ENB6rz8QMSZRZZ7E1YEUaOTY/s1600/AzureStatusRules.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="328" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjO9qL8byiew9MH8q2KwCC7T8AjrHp63AKRHJicx1GNviWcnBRrJTDc69ZawKDNcylrpYpI6s8KKMSgXYV7AiTjmL36mqpiqem5K9tvzPMGkv5dIUm_7x35ENB6rz8QMSZRZZ7E1YEUaOTY/s400/AzureStatusRules.JPG" width="400" /></a></div>
<br />
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">With the above in place, I am now being alerted by Outlook on my laptop and mobile phone when a status change occurs on the Azure Status page. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTUnjnvcby8Pizl3QZTXJ3hol9jpJKPxl6O5O4rQsStK1zVlckd33-Rc9weQcAHjDgCPOKaRbadfT2wlaQKq8GbRayD6R1oYt6vUBVfzWVqiuz9Da3nni4GiMgE7C-swgCHIUBeHzz7WQ8/s1600/IUsedToSleepAtNight.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgTUnjnvcby8Pizl3QZTXJ3hol9jpJKPxl6O5O4rQsStK1zVlckd33-Rc9weQcAHjDgCPOKaRbadfT2wlaQKq8GbRayD6R1oYt6vUBVfzWVqiuz9Da3nni4GiMgE7C-swgCHIUBeHzz7WQ8/s1600/IUsedToSleepAtNight.jpg" /></a></div>
<br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><a href="http://quotesgram.com/quotes-about-the-night-shift/" target="_blank"><span style="font-size: xx-small;">http://quotesgram.com/quotes-about-the-night-shift/</span></a></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-74197767049136706932016-03-31T07:34:00.000-04:002016-03-31T07:34:26.653-04:00February was busy but good...<span style="font-family: "verdana" , sans-serif;">February was very busy because I had to prepare for my 18th SQL Saturday, prepare abstracts for the 2016 PASS Summit Call for Speakers and keep up with big things happening at work. <<a href="https://youtu.be/Bxauqa7rJgI" target="_blank">Cue sad violin music...</a>></span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">I submitted two sessions for SQL Saturday Tampa and ended up giving both of them. One in the morning and one in the afternoon. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">My morning <a href="http://www.sqlsaturday.com/489/sessions/details.aspx?sid=42786" target="_blank">session</a> on Monitoring and Alerting for an Azure PaaS Application earned me <a href="http://www.scarydba.com/2016/03/04/speaker-of-the-month-february-2016-2/" target="_blank">Speaker of the Month</a> from The Scary DBA and PASS EVP Grant Fritchey. </span><span style="font-family: verdana, sans-serif;">I truly appreciate his recognition and feedback. I WILL incorporate it in future sessions.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">In the afternoon, I did a <a href="http://www.sqlsaturday.com/489/sessions/details.aspx?sid=42784" target="_blank">session</a> on how to lock down SQL Server so that DBAs don't have unfettered access to business data. This makes your Compliance staff smile, trust me. </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><span style="font-family: verdana, sans-serif;">After SQL Saturday was the final push to get my abstracts done for the 2016 PASS Summit Call for Speakers. They were due the Wednesday after the Tampa SQL Saturday. Do you now understand why February was busy? </span></span><span style="font-family: verdana, sans-serif;">I submitted four abstracts for consideration for this year's PASS Summit. Two were technical and two were professional development.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;"><a href="https://twitter.com/SQLRunr" target="_blank">Allen White</a> always starts his talks with a little blurb about how we all know something that we can teach others to encourage new speakers.</span><span style="font-family: "verdana" , sans-serif;">To prove that point, this <a href="https://dba.stackexchange.com/users/8783/kin" target="_blank">guy</a> asked me questions via Twitter about my security session. I got a huge kick out of someone with such a stellar reputation score on <a href="http://dba.stackexchange.com/">dba.stackexchange.com</a> asking me for help.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Finally, I've joined my company's Toastmaster club in the hope that it will improve my speaking skills for future PASS events.</span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<span style="font-family: "verdana" , sans-serif;">Whew! </span><br />
<span style="font-family: "verdana" , sans-serif;"><br /></span>
<br />IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-16601257715149933732016-01-11T07:02:00.000-05:002016-01-11T07:02:04.900-05:00PASS Summit 2015 Speaker Idol "Round of Death"<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzpHdf0mJLwyg0HAGlHOvS2OQoKlQUumPeHmGJ4zJeD9feTI3H-KsZ8lQJBZtYTItJlO5kSOEnVPLL-Aj-t1LhTYcQgZcZJfTpKO8rqyvnH6qXsxLlNzqM46Tmsvi9X5zw9kLJCohGBrUi/s1600/SpeakerIdolVideo.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="241" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjzpHdf0mJLwyg0HAGlHOvS2OQoKlQUumPeHmGJ4zJeD9feTI3H-KsZ8lQJBZtYTItJlO5kSOEnVPLL-Aj-t1LhTYcQgZcZJfTpKO8rqyvnH6qXsxLlNzqM46Tmsvi9X5zw9kLJCohGBrUi/s400/SpeakerIdolVideo.JPG" width="400" /></a></div>
<span style="font-family: Verdana, sans-serif;">Hi. I wanted to wait on my recap of this event until I had seen the </span><a href="http://www.sqlpass.org/summit/2015/PASStv/Community.aspx?watch=SpYTZ2GCVWI" style="font-family: Verdana, sans-serif;" target="_blank">video</a><span style="font-family: Verdana, sans-serif;"> of my Speaker Idol session at PASS Summit 2015. I come on around 14:30.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Speaker Idol is purely a test of your presentation skills. Probably one of the most grueling tests because it is very difficult to cover a topic effectively in FIVE minutes. I also try to tell a story when I speak. So, in five minutes it has to be really concise. My topic was SQL Injection. Could you imagine what a disgruntled speaker could do with SQL Injection? Of course, this is all hypothetical. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I thought beforehand that the eventual winner would have to do what a speaker does typically during a PASS Summit session. Talk, do a demo and wrap up. I also like speakers who throw in a few laughs along the way so I was hoping someone like that would win. No time for Q&A in this format so you are spared that part of the test. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I used <a href="https://play.google.com/store/apps/details?id=com.microsoft.office.officeremote&hl=en" target="_blank">Office Remote for Android</a> to control my PowerPoint 2016 deck. This is a very new phone app and it was the first time I had used it in a live session. I really like this app and will continue to use it but I do need to get better using it so that as the judges correctly indicated it doesn't become such a distraction.</span><br />
<span style="font-family: Verdana, sans-serif;">This app basically gives you Presentation View on your phone and allow you to run your laptop in Duplicate Screen mode which minimizes the breaks when you switch between the deck and your demo tools. I did use ZoomIt successfully and I still have a few "umms" to eliminate. I could have formatted the code to be easier to read but that would have revealed the punch line at the end of my presentation. Finally, I wish I had found that sound cord to plug into my laptop for my ending because I though AC-DC's "It's a Long Way to the Top" was a fun way to end for Speaker Idol. I had gone into the room more than once to check out the tech layout but didn't find that cord. </span><br />
<br />
<span style="font-family: Verdana, sans-serif;">The judges' comments were very helpful for all the rounds and it will definitely help me to improve as a speaker. </span><span style="font-family: Verdana, sans-serif;">I'm hoping the exposure I got at Speaker Idol will help me get selected for next year's PASS Summit. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">My Speaker Idol round should now be called the "Round of Death" because the eventual winner and runner-up were in it. Congratulations to <a href="https://twitter.com/dmmaxwell" target="_blank">David Maxwell</a> for his well deserved victory. I think he will do a great job next year.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I'm glad I did Speaker Idol but I have to say the normal abstract process is the less stressful way to go if you want to speak at PASS Summit. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Happy New Year!</span><br />
<br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-49944335442958175222015-12-17T06:58:00.003-05:002015-12-17T06:58:42.582-05:00The PowerShell Advent of Code <span style="font-family: Verdana, sans-serif;">So, Jeremiah Peschka's </span><a href="http://facility9.com/2015/12/practice-writing-code/" style="font-family: Verdana, sans-serif;" target="_blank">post</a><span style="font-family: Verdana, sans-serif;"> on practicing has hooked me into working through this <a href="http://adventofcode.com/" target="_blank">series</a> of word problems. You can use any language to solve the problems. I'll be using PowerShell because I need the exercise and I need to learn how to use <a href="https://github.com/" target="_blank">Github</a>.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">You can try the Advent of Code yourself <a href="http://adventofcode.com/" target="_blank">here</a> and see my answers so far <a href="https://github.com/rdameron/adventofcode" target="_blank">here</a>.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I was able to answer the first puzzle with four lines of PowerShell. Yeah!</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Merry Christmas and Happy New Year!</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfhutXHQWtX_ELCgKvTpSRM3h_fURS7nWQK-tslD-14fZ1FchKLFPvD_lALh1Q_QuAUXxfkYTo37ZMXd6tOjs0ngBpODIqlvzCHlWTSiHB_62AEf6-RISqwBeQVDLtQyU4e8HxoKSB4so1/s1600/Screen+Shot+2015-12-17+at+06.51.04.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfhutXHQWtX_ELCgKvTpSRM3h_fURS7nWQK-tslD-14fZ1FchKLFPvD_lALh1Q_QuAUXxfkYTo37ZMXd6tOjs0ngBpODIqlvzCHlWTSiHB_62AEf6-RISqwBeQVDLtQyU4e8HxoKSB4so1/s320/Screen+Shot+2015-12-17+at+06.51.04.png" width="297" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-7316040787033100752015-10-16T20:31:00.000-04:002015-10-16T20:31:12.330-04:00Office Remote for Android<span style="font-family: Verdana, sans-serif;">While practicing for the upcoming PASS Summit <a href="http://www.sqlpass.org/summit/2015/Connect/SpeakerIdol.aspx" target="_blank">Speaker Idol</a> contest it occurred to me that it would be great if I could use my Android phone to control my Powerpoint deck. </span><span style="font-family: Verdana, sans-serif;">I also recalled <a href="https://twitter.com/lindsayoclark" target="_blank">Lindsay Clark</a> holding her phone while she was doing her <a href="http://www.sqlsaturday.com/442/sessions/details.aspx?sid=38496" target="_blank">talk</a> this past week at <a href="http://www.sqlsaturday.com/442/eventhome.aspx" target="_blank">SQL Saturday Orlando</a>.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">So, I searched the Google Play Store and lo and behold there it was, </span><a href="https://play.google.com/store/apps/details?id=com.microsoft.office.officeremote&hl=en" style="font-family: Verdana, sans-serif;" target="_blank">Office Remote for Android</a><span style="font-family: Verdana, sans-serif;">.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The instructions to install it are very good but I did have issues getting my laptop to pair with my HTC One M9 phone.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span><span style="font-family: Verdana, sans-serif;">To resolve the issue, I had to uninstall and reinstall the Bluetooth drivers to get it working because my Windows 8.1 laptop wasn't recognizing <b><i>ANY</i></b> Bluetooth devices. Also, I set the <b>Log On as</b> account to NT AUTHORITY\LocalService for the Bluetooth Support Service. It was then able to find my phone and pair with it.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The following links were very helpful. I did not have to do the registry change suggested in the first link to get this working. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><a href="https://superuser.com/questions/491061/bluetooth-enabled-and-working-correctly-but-not-finding-any-devices">https://superuser.com/questions/491061/bluetooth-enabled-and-working-correctly-but-not-finding-any-devices</a></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><a href="https://answers.microsoft.com/en-us/windows/forum/windows8_1-hardware/error-1079-on-starting-bluetooth-support-service/63a49a65-e22d-4cba-9bd6-271a6d1c6404">https://answers.microsoft.com/en-us/windows/forum/windows8_1-hardware/error-1079-on-starting-bluetooth-support-service/63a49a65-e22d-4cba-9bd6-271a6d1c6404</a></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">When using Office Remote, close all other apps so that it displays the previous and next screens properly, otherwise they may be blank. I'm guessing this was simply a resource issue on the phone.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Office Remote shows you basically a miniature version of Presentation Mode. There is also a laser pointer that can be invoked by simply touching on the current slide and moving your finger around.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The "New Microsoft" has outdone themselves with this app!</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWFktsNQ1DKPTyhy2lqJlGeQQ-1aD3s5aP8-tACublYKtCFgm1L5mMomKYRBLYwB00BCimvw2VVhRpj36IDSgqUCCksOYG_0vuxckC3xsaA3tqMwtspwTwEi1-St5EqDtKcEKqPbEP0Vad/s1600/Screenshot_2015-10-16-14-21-33.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiWFktsNQ1DKPTyhy2lqJlGeQQ-1aD3s5aP8-tACublYKtCFgm1L5mMomKYRBLYwB00BCimvw2VVhRpj36IDSgqUCCksOYG_0vuxckC3xsaA3tqMwtspwTwEi1-St5EqDtKcEKqPbEP0Vad/s320/Screenshot_2015-10-16-14-21-33.png" width="180" /></a><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo6PG2SQKVwb7CBzfRqy-aIebjWbP5v5CFLiPkW4LTRVOXnbaNautlVn-CwJJomllDh05iYXIyshU8hyphenhyphenb0MTLwPWLGTCcRqC3VaLgkxiwYo_wvcB1r0DbnOHD7MvJ43FRUInKuyhdv5zIO/s1600/Screenshot_2015-10-16-14-06-35.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjo6PG2SQKVwb7CBzfRqy-aIebjWbP5v5CFLiPkW4LTRVOXnbaNautlVn-CwJJomllDh05iYXIyshU8hyphenhyphenb0MTLwPWLGTCcRqC3VaLgkxiwYo_wvcB1r0DbnOHD7MvJ43FRUInKuyhdv5zIO/s320/Screenshot_2015-10-16-14-06-35.png" width="180" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-56688633213563436642015-10-14T19:26:00.002-04:002015-10-14T19:26:56.258-04:00PASS Summit 2015 Speaker Idol Contestant!<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3-z0bypayGkEJkjnGKAmKRWTTkhzu1pe0AQMQd9mB3jQCu5OtIKyWym4K_gS2lTYpzxra8voHC3OgpbzZDN_Wgcz22keCVUhPL00NfFX-2OmeF0ODVKN6Ifwk5Dk7sdfVZnwCaHBW5wHy/s1600/Poe.jpg" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj3-z0bypayGkEJkjnGKAmKRWTTkhzu1pe0AQMQd9mB3jQCu5OtIKyWym4K_gS2lTYpzxra8voHC3OgpbzZDN_Wgcz22keCVUhPL00NfFX-2OmeF0ODVKN6Ifwk5Dk7sdfVZnwCaHBW5wHy/s320/Poe.jpg" width="180" /></a><span style="font-family: Verdana, sans-serif;">Yes. I have finally been selected to speak at PASS Summit! </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">For at least 5 minutes. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Along with 11 others in the <a href="http://www.sqlpass.org/summit/2015/Connect/SpeakerIdol.aspx" target="_blank">Speaker Idol</a> contest.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">If I get to speak for another 5 minutes, I might win a slot at next year's Summit for a full session. No pressure.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">By the way, they are live streaming the event from a room that can hold 250 people. No pressure.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">I was pretty excited when I saw the e-mail from Denny Cherry that I had been selected but it also comes with an equally heavy dose of dread. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">What will I talk about for 5 minutes? How will I handle such a big room? </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Will Poe Dameron save me? </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Come to the Speaker Idol session on Friday at PASS Summit to find out.</span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-73913102242171844252015-09-24T07:08:00.000-04:002015-09-24T07:08:25.156-04:00SQL Saturday #442<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;">I'll be speaking at <a href="http://www.sqlsaturday.com/442/eventhome.aspx" target="_blank">SQL Saturday #442</a> in Orlando on October 10, 2015.</span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"><br /></span>
<span style="color: #666666; font-family: Verdana, sans-serif;"><span style="background-color: white; font-size: 13.2px; line-height: 18.48px;">This will be the next to last time I present this session. If you miss it, I will be presenting it for the <a href="http://pinellas.sqlpass.org/" target="_blank">Pinellas SQL User Group</a> in November before it goes into the vault. </span></span><br />
<br />
<span style="background-color: white; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"></span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;">So, if you are interested in minimizing or possibly preventing the type of breach that happened at <a href="http://krebsonsecurity.com/2015/02/china-to-blame-in-anthem-hack/" style="color: #888888; text-decoration: none;" target="_blank">Anthem Inc</a>, you will likely find my </span><a href="https://www.sqlsaturday.com/viewsession.aspx?sat=371&sessionid=29563" style="background-color: white; color: #888888; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px; text-decoration: none;" target="_blank">session</a><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"> "<b>Real World SQL Server Database Administration with just a bit of sysadmin</b>" very interesting. </span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"><br /></span><span style="background-color: white; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"></span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;">It is becoming increasingly difficult to allow SQL Server database administrators to retain perpetual sysadmin access on production servers due to IT Security, Audit, and Compliance concerns. </span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"><br /></span><span style="background-color: white; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"></span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;">I'</span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;">ll review the fundamentals needed to define a configurable permission model</span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"> </span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;">that allows database administrators to do routine work without having unfettered access to business data. Several demonstrations will show that many DBA tasks can be done without sysadmin access. Attendees will also learn how to deploy a set of permissions that allows DBAs to do routine work, elevate DBA permissions quickly to respond to production emergencies and how to grant sysadmin permissions during disaster recovery scenarios. Scripts will be reviewed and demonstrated that secure the database server, undo the permission model in case of unforeseen circumstances and discover which servers remain to be locked down. Attendees will leave this session with the realization that DBAs need to be sysadmin only when required.</span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"><br /></span><span style="background-color: white; color: #666666; font-family: 'Trebuchet MS', Trebuchet, Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"></span><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"><a href="http://www.sqlsaturday.com/" target="_blank">SQL Saturday</a> is a FREE training event for SQL Server professionals and those wanting to learn about SQL Server. SQL Saturdays are possible because of <a href="http://sqlpass.org/Home.aspx" style="color: #888888; text-decoration: none;" target="_blank">PASS</a>, our sponsors, and the many volunteer speakers and staff that run the event. I encourage you to attend. </span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13.2px; line-height: 18.48px;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-28829980233036312802015-06-04T09:02:00.000-04:002015-06-04T09:02:30.291-04:00Finding the next job was easier because...<span style="font-family: Verdana, sans-serif;">I am an active participant </span><span style="font-family: Verdana, sans-serif;">in </span><a href="http://sqlpass.org/" style="font-family: Verdana, sans-serif;" target="_blank">PASS</a><span style="font-family: Verdana, sans-serif;">, </span><a href="http://sqlsaturday.com/" style="font-family: Verdana, sans-serif;" target="_blank">SQL Saturday</a><span style="font-family: Verdana, sans-serif;">, and </span><a href="https://twitter.com/" style="font-family: Verdana, sans-serif;" target="_blank">Twitter</a><span style="font-family: Verdana, sans-serif;">.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Due to circumstances beyond my control, I had to look for a job after nine years at my previous employer. </span><br />
<span style="font-family: Verdana, sans-serif;">The management decided to relocate the IT department to North Carolina. </span><span style="font-family: Verdana, sans-serif;">I live in Florida. Neither myself nor my wife were interested in moving to colder climes. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I posted my updated resume in January 2015. I really started looking seriously at the end of March.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Because of my participation in the Florida PASS user groups, SQL Saturdays, and Twitter, most of my job leads came from people I know. The one job that I did a phone interview for via a recruiter ended up being with someone who had attended the most recent Tampa SQL Saturday and one of his co-workers had attended my session. They wanted to do an in-person interview but couldn't wait until June for me to start. The conditions of my severance package dictated a June start date for the next job.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I had leads from my user group leader, a former co-worker via Twitter, and an MCM who I met via SQL Saturday. I joined Twitter because of a Tampa SQL user group presentation in 2009 given by Jorge Segarra AKA <a href="https://twitter.com/sqlchicken" target="_blank">@sqlchicken</a>. Speaking at SQL Saturdays and user groups made interviews a breeze.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I ended up taking the job with the <a href="https://twitter.com/aboutsqlserver" target="_blank">MCM</a>. He is now my manager. :</span><span style="font-family: Verdana, sans-serif;">-D</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">I start my new job after two weeks vacation.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The point of this post is the transition was MUCH easier than I could have ever imagined because of the participation I've described above.</span><br />
<br />
<span style="font-family: Verdana, sans-serif;">If you have to find another job, this is the way to do it. Be social. Contribute.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-82929891609840680712015-04-14T15:39:00.000-04:002015-04-14T15:39:40.044-04:00One of many reasons to translate VBScript to PowerShell<span style="font-family: Verdana, sans-serif;">I'm wrapping up the deployment of a cross-platform automation tool for our distributed databases(DB2 LUW, SQL Server, Oracle). </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">One of our major items to convert is a VBScript that does several post-installation tasks for SQL Server. </span><br />
<br />
<span style="font-family: Verdana, sans-serif;">I've decided to take this opportunity to retire as much VBScript as possible. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Why might you ask? </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Here's my first example...</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">To check the version of Windows in our VBScript requires twelve lines of code</span><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtWEtITb5Hnn8SQPAjyOEWQuBC0IEkUcswgYz7nhowa-alBPtmSAlCJ_AAGFswnyAmBRnxqlSV3_ggIkaUsBZiSsbpA3vyLpqoD0MDdE3_ddhSADAsJJNlD8J1TYvUK7U8ZYXfFAYNpJQd/s1600/VBS_chk_OSVer.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgtWEtITb5Hnn8SQPAjyOEWQuBC0IEkUcswgYz7nhowa-alBPtmSAlCJ_AAGFswnyAmBRnxqlSV3_ggIkaUsBZiSsbpA3vyLpqoD0MDdE3_ddhSADAsJJNlD8J1TYvUK7U8ZYXfFAYNpJQd/s1600/VBS_chk_OSVer.jpg" height="186" width="640" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: left;">
<span style="font-family: Verdana, sans-serif;">PowerShell only needs one. </span></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhw3CaTlFjMziY0c85rU81VBA0fDxLKUz0NJGUfJeELJTc1rRQnKV9fwmUPIQkvaXMB140KGZ6UrPPsPNfNb_wWcAdkYsf8OzfsEcQG-oh3m600OzPEwAa-uvNLdv-HMEP7qN50Htz7RAaL/s1600/PS_Chk_OSVer.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhw3CaTlFjMziY0c85rU81VBA0fDxLKUz0NJGUfJeELJTc1rRQnKV9fwmUPIQkvaXMB140KGZ6UrPPsPNfNb_wWcAdkYsf8OzfsEcQG-oh3m600OzPEwAa-uvNLdv-HMEP7qN50Htz7RAaL/s1600/PS_Chk_OSVer.jpg" height="126" width="640" /></a></div>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Well, we'll need two lines to store the Caption and CSDVersion in variables for later use.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I expect I'll have several other great examples to show from this effort.</span><br />
<span style="font-family: Verdana, sans-serif;"><br />Get stuff done faster with less code. Use PowerShell.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-91715987415447644652015-02-12T20:04:00.000-05:002015-02-24T08:22:51.299-05:00SQL Saturday #371 Tampa - I'm speaking!<span style="font-family: Verdana, sans-serif;">I'll be speaking at <a href="https://www.sqlsaturday.com/371/eventhome.aspx" target="_blank">SQL Saturday #371</a> in Tampa on February 28, 2015.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">If you are interested in minimizing or possibly preventing the type of breach that happened at <a href="http://krebsonsecurity.com/2015/02/china-to-blame-in-anthem-hack/" target="_blank">Anthem Inc</a>, you will likely find my </span><a href="https://www.sqlsaturday.com/viewsession.aspx?sat=371&sessionid=29563" style="font-family: Verdana, sans-serif;" target="_blank">session</a><span style="font-family: Verdana, sans-serif;"> "<b>Real World SQL Server Database Administration with just a bit of sysadmin</b>" very interesting. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">It is becoming increasingly difficult to allow SQL Server database administrators to retain perpetual sysadmin access on production servers due to IT Security, Audit, and Compliance concerns. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I </span><span style="font-family: Verdana, sans-serif;">will review the fundamentals needed to define a configurable permission model </span><span style="font-family: Verdana, sans-serif;">currently in use at a large insurance company </span><span style="font-family: Verdana, sans-serif;">that allows database administrators to do routine work without having unfettered access to business data. Several demonstrations will show that many DBA tasks can be done without sysadmin access. Attendees will also learn how to deploy a set of permissions that allows DBAs to do routine work, elevate DBA permissions quickly to respond to production emergencies and how to grant sysadmin permissions during disaster recovery scenarios. Scripts will be reviewed and demonstrated that secure the database server, undo the permission model in case of unforeseen circumstances and discover which servers remain to be locked down. Attendees will leave this session with the realization that DBAs need to be sysadmin only when required.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">SQL Saturday is a FREE training event for SQL Server professionals and those wanting to learn about SQL Server. SQL Saturdays are possible because of <a href="http://sqlpass.org/Home.aspx" target="_blank">PASS</a>, our sponsors, and the many volunteer speakers and staff that run the event. I encourage you to check the <a href="https://www.sqlsaturday.com/371/schedule.aspx" target="_blank">schedule</a>. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">I guarantee you will learn something new by the end of the day!</span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-65265307345590509162014-12-04T06:44:00.000-05:002014-12-04T06:44:08.630-05:00Getting SQLPSX to work with SQL Server 2012<span style="font-family: Verdana, sans-serif;">A few years ago, I wrote PowerShell scripts to assist our IT Risk department with auditing and ID management. With the deployment of SQL Server 2012 in our environment those scripts are starting to show their age. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The scripts were designed to run from a central server and they use SQL Server PowerShell Extensions version 1.6.1. </span><br />
<br />
<span style="font-family: Verdana, sans-serif;">The scripts are throwing errors when trying to connect to SQL Server 2012 instances.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">The SMO assemblies are loaded with the following code by LibrarySmo.ps1:</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWa7du5FTRksPLCUquVYkhVIjB7IAbM0eLOm_yf7Dr_zq4aoX6nwL0TseuWA24CcYGccBVUIkR98W_sXj8MKlEw5ohFbdKY6uevUMCgUmYeqTjGJtMWWJgyyyo3oPhmYtBxADlYitnpb3S/s1600/LoadSMO.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhWa7du5FTRksPLCUquVYkhVIjB7IAbM0eLOm_yf7Dr_zq4aoX6nwL0TseuWA24CcYGccBVUIkR98W_sXj8MKlEw5ohFbdKY6uevUMCgUmYeqTjGJtMWWJgyyyo3oPhmYtBxADlYitnpb3S/s1600/LoadSMO.JPG" height="50" width="640" /></a></div>
<br />
<span style="font-family: Verdana, sans-serif;">If I run this bit of code on our central server it returns the Version 10 SMO assemblies that allow it to connect to SQL Server 2008 R2 and below.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Running this code on my laptop or server that has the SQL Server 2012 tools installed returns the Version 11 SMO assemblies which allow the scripts to run on SQL Server 2012.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">In addition, if the scripts are copied to a server with SQL Server 2012 installed, they run successfully because the code above is loading the later version of the SMO assemblies.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">So, the fix for our central server is to either install the SQL Server 2012 client tools or just the compatible SMO assemblies. We now know we need to keep the central server up to date with the latest assemblies to keep these scripts working.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="font-family: Verdana, sans-serif;">Helpful references:</span><br />
<a href="http://sqlpsx.codeplex.com/discussions/353631" style="font-family: Verdana, sans-serif;">http://sqlpsx.codeplex.com/discussions/353631</a><br />
<span style="font-family: Verdana, sans-serif;"><a href="http://sqlserverpowershell.com/2012/07/24/sqlpsx-sql-server-2012/">http://sqlserverpowershell.com/2012/07/24/sqlpsx-sql-server-2012/</a></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-82638945517719409502014-11-10T07:05:00.000-05:002014-11-10T07:05:08.381-05:00Veteran's Day Trivia - Name That Aircraft<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEie7yoEi_6GFemk9raUVhMTkzPMSg-ihZk1W2WwgoPWsyLKt5ykyCTMIJkBeJdkrcsV7Jv69YvRxh8L9Xx5_1IwJBM-1qNCqNUgYCNnGkMlSPVuIio-Y5ReQNMS23iG94tlRT7LZiAs0c2x/s1600/IMG-20140826-WA0001.jpg" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEie7yoEi_6GFemk9raUVhMTkzPMSg-ihZk1W2WwgoPWsyLKt5ykyCTMIJkBeJdkrcsV7Jv69YvRxh8L9Xx5_1IwJBM-1qNCqNUgYCNnGkMlSPVuIio-Y5ReQNMS23iG94tlRT7LZiAs0c2x/s1600/IMG-20140826-WA0001.jpg" height="400" width="300" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif; font-size: xx-small;">Feeding a wild pig</span></td></tr>
</tbody></table>
<b style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13px; line-height: 18.479999542236328px;"><br /></b>
<b style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13px; line-height: 18.479999542236328px;"><br /></b>
<b style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13px; line-height: 18.479999542236328px;"><br /></b>
<b style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13px; line-height: 18.479999542236328px;">WORKING CONDITIONS: </b><span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13px; line-height: 18.479999542236328px;">Works indoors and outdoors, in inclement weather, and on icy, wet, or slippery ramps and aircraft surfaces in temperature and humidity extremes. Subject to dangers from exposure to toxic fumes, high-pressure air and fluids, fast actuating aircraft surfaces such as landing gear, speed brakes, and flaps. Dangers also include engine noise, jet blast, jet intakes, explosive munitions, electrical voltage cartridge actuated devices, liquid oxygen, fire, aircraft fuels, lubricants, paints, hydrazine, and solvents.</span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: 13px; line-height: 18.479999542236328px;"><br /></span>
<span style="background-color: white; color: #666666; line-height: 18.479999542236328px;"><span style="font-family: Verdana, sans-serif;">Working in IT is a piece of cake.</span></span><br />
<span style="background-color: white; color: #666666; line-height: 18.479999542236328px;"><span style="font-family: Verdana, sans-serif;"><br /></span></span>
<span style="color: #666666; font-family: Verdana, sans-serif;"><span style="background-color: white; line-height: 18.479999542236328px;">That airman on the left is me!</span></span><br />
<span style="color: #666666; font-family: Verdana, sans-serif;"><span style="background-color: white; line-height: 18.479999542236328px;">I salute all veterans on Veteran's Day!</span></span><br />
<span style="color: #666666; font-family: Verdana, sans-serif;"><span style="background-color: white; line-height: 18.479999542236328px;"><br /></span></span>
<span style="color: #666666; font-family: Verdana, sans-serif;"><span style="background-color: white; line-height: 18.479999542236328px;">Bonus points if you can name the aircraft I'm working on.</span></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-14989340669411763932014-10-31T21:14:00.000-04:002014-10-31T21:14:54.933-04:00Training on the T's - SQL Server Security Easy Button Q&A<span style="font-family: Verdana, sans-serif;">On October 7, 2014, I spoke for Pragmatic Works' Training on the T's webinar series. </span><br />
<span style="font-family: Verdana, sans-serif;">Here's the rest of the questions I didn't get to answer. </span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="color: blue; font-family: Verdana, sans-serif;">Q: Where can I get the slide deck and presentation?</span><br />
<span style="font-family: Verdana, sans-serif;">A: <a href="https://www.sqlsaturday.com/viewsession.aspx?sat=318&sessionid=21152" target="_blank">Orlando SQL Saturday</a> , <a href="https://www.sqlsaturday.com/viewsession.aspx?sat=273&sessionid=20129" target="_blank">Tampa SQL Saturday</a> , <a href="https://www.sqlsaturday.com/viewsession.aspx?sat=298&sessionid=20650" target="_blank">Jacksonville SQL Saturday</a></span><br />
<br />
<span style="color: blue; font-family: Verdana, sans-serif;">Q: All of our database tables are under the dbo schema. How can I set up programmers to be able to modify stored procedures but not give them the dbo schema permission with which they can modify tables?</span><br />
<span style="font-family: Verdana, sans-serif;">A: <b>I think the only possible way to do this is to split the stored procedures and tables into different schema. I do not see a way in the permission models to grant permission to modify stored procedures without also granting the same permission to modify tables. Granting ALTER ON OBJECT gives access to multiple object types in the database. See longtime SQL Server MVP Erland Sommarskog's comment <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/581c9a56-b50f-4649-9e5b-f649a13bd137/permission-alter-view-and-execute-all-the-stored-procedures?forum=sqlsecurity" target="_blank">here</a> on this question. </b></span><b style="font-family: Verdana, sans-serif;">See the next question for additional information. </b><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="color: blue; font-family: Verdana, sans-serif;">Q: Where i can get the SQL Server permissions PDF?</span><br />
<span style="font-family: Verdana, sans-serif;">A. <b>Google "sql server permissions poster" or go to this <a href="http://social.technet.microsoft.com/wiki/contents/articles/11842.sql-server-database-engine-permission-posters.aspx" target="_blank">link</a>.</b></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="color: blue; font-family: Verdana, sans-serif;">Q: Good morning, Where I can find the current session recording? I missed half of the beginning part.</span><br />
<span style="font-family: Verdana, sans-serif;">A: <b>Consider yourself lucky. You missed most of my 'ums' in the first half. ;-)</b></span><br />
<span style="font-family: Verdana, sans-serif;"><b>You can find it</b> <a href="http://pragmaticworks.com/Training/FreeTraining/ViewWebinar/WebinarID/692" target="_blank">here</a>.</span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="color: blue; font-family: Verdana, sans-serif;">Q: Would you recommend using this security script along with C2 auditing?</span><br />
<span style="font-family: Verdana, sans-serif;">A: <b>Yes, but I would recommend using the <a href="http://msdn.microsoft.com/en-us/library/bb326650.aspx" target="_blank">Common Criteria Compliance option</a> instead. <a href="http://msdn.microsoft.com/en-us/library/ms187634.aspx" target="_blank">C2 audit mode</a> is deprecated and will be removed from a future version of SQL Server.</b></span><br />
<br />
<span style="color: blue; font-family: Verdana, sans-serif;">Q: The password vault you keep referring to is the windows credential manager found under user accounts in control panel?</span><br />
<span style="font-family: Verdana, sans-serif;">A. <b>No, it's called the</b> <a href="http://www.cyberark.com/products/privileged-account-security-solution/enterprise-password-vault/" target="_blank">Cyber-Ark Enterprise Password Vault</a></span><br />
<span style="font-family: Verdana, sans-serif;"><br /></span>
<span style="color: blue; font-family: Verdana, sans-serif;">Q:You mentioned a couple of names of people we should know and I missed the name of the first guy.</span><br />
<div>
<span style="font-family: Verdana, sans-serif;">A: </span><a href="http://sqlblog.com/blogs/aaron_bertrand/" style="font-family: Verdana, sans-serif;" target="_blank">Aaron Bertrand</a><span style="font-family: Verdana, sans-serif;"> <b>and</b> </span><a href="https://ola.hallengren.com/" style="font-family: Verdana, sans-serif;" target="_blank">Ola Hallengren</a></div>
<div>
<span style="font-family: Verdana, sans-serif;"><br /></span></div>
<div>
<span style="color: blue; font-family: Verdana, sans-serif;">Q: How does the DBA sign out a user id with sysadmin rights?</span><br />
<span style="font-family: Verdana, sans-serif;">A: <b>In our environment, they log in to Cyber-Ark and provide a valid change or incident ticket.</b></span></div>
<div>
<br />
<span style="font-family: Verdana, sans-serif;">I apologize for too many 'ums' and completely forgetting to use Zoomit while reviewing the script.</span><br />
<span style="font-family: Verdana, sans-serif;">Thank you for attending! </span></div>
IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-30878135808514685092014-09-19T19:40:00.000-04:002014-09-19T19:40:49.858-04:00MagicPASS September meeting<span style="font-family: Verdana, sans-serif; font-size: large;">I spoke at the MagicPASS September User Group meeting in Celebration, FL.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">Kendal Van Dyke (<a href="http://www.kendalvandyke.com/" target="_blank">b</a>|<a href="https://twitter.com/SQLDBA" target="_blank">t</a>) does a great job running this group.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">Home-cooked meals for attendees! Need I say more? B</span><span style="font-family: Verdana, sans-serif; font-size: large;">ut, I will. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span><span style="font-family: Verdana, sans-serif; font-size: large;">The Disney Vacation Club provides an excellent facility.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">I liked the MagicPASS meeting format. They have a pre-meeting and a main meeting. I spoke during the main meeting at 7:30 PM. The meal is served between the two meetings. </span><span style="font-family: Verdana, sans-serif; font-size: large;">Baked ziti and salad. Nom, nom, nom.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">During the pre-meeting, the presentation was a recording from the <a href="http://performance.sqlpass.org/" target="_blank">PASS Performance Virtual Chapter</a>. This is a great idea because it makes attendees aware that virtual chapters exist and they get a chance to see a presentation that maybe they didn't get to see. </span><span style="font-family: Verdana, sans-serif; font-size: large;">I had seen this one. Oh, well.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">Another informative agenda item in the pre-meeting is "Industry News". Kendal talked about upcoming service packs, cumulative updates, and critical patches. He asked if anyone was using Ola Hallengren's scripts. (YES!) Then, he described an issue he had with the scripts caused by a memory leak in one of the SQL Server components that is fixed by a recent CU. Kendal also shared his experience on a recent trip to VMWare. I learned DBAs should have READ access to vSphere ( I do.) and that if you turn the correct "nerd knobs", SQL Server runs pretty well on VMWare. This is WHY I go to user group meetings! I always learn something I didn't know.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">My take-away from this meeting is that I need to have a clear view of my notes in Presenter view. My laptop was on a table instead of on a podium and I think this caused too many hesitations in my talk at the beginning because I would pause to bend over and check my notes. I like to stand when presenting instead of sitting. I'll need to expand the font size of the notes or commit more to memory.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">The next day, I figured out how to increase the font size of the notes in Presenter View. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">It takes just over an hour to drive to the MagicPASS meeting location from my house so I'd be willing to do it again for the "Happiest SQL User Group on Earth". </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;">Thank you Kendal and MagicPASS for having me! </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">I'll be there the next time you have tacos. ;-)</span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-74501449966166671832014-08-20T13:33:00.000-04:002014-08-20T14:02:01.002-04:00My upcoming speaking calendar<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;">If you work in an organization that is finding it increasingly difficult to allow SQL Server database administrators unfettered sysadmin access to your Production servers, then you have four opportunities to hear me speak about how to control this type of access.</span></span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><br /></span></span>
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><b>PASS Healthcare Virtual Chapter</b></span></span><br />
<span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><span style="background-color: white; line-height: 25.200000762939453px;">August 21, 2014</span></span><br />
<span style="background-color: white; line-height: 25.200000762939453px;"><span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><a href="http://healthcare.sqlpass.org/">http://healthcare.sqlpass.org</a>/</span></span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><br /></span></span>
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><b>MagicPASS </b></span></span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;">September 17, 2014</span></span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; font-size: large; line-height: 25.200000762939453px;"><a href="http://magicpass.sqlpass.org/">http://magicpass.sqlpass.org</a>/</span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><br /></span></span>
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><b>SQL Saturday #318 in Orlando, FL</b> </span></span><br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;">September 27, 2014</span></span><br />
<span style="background-color: white; line-height: 25.200000762939453px;"><span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><a href="http://www.sqlsaturday.com/viewsession.aspx?sat=318&sessionid=21152">http://www.sqlsaturday.com/viewsession.aspx?sat=318&sessionid=21152</a></span></span><br />
<br />
<span style="background-color: white; color: #666666; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;"><b>Training on the T's</b></span></span><br />
<span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><span style="background-color: white; line-height: 25.200000762939453px;">October 7, 2014</span></span><br />
<a href="http://www.pragmaticworks.com/LearningCenter/FreeTrainingWebinars/FutureWebinars.aspx?ResourceId=692" style="background-color: white; font-family: Verdana, sans-serif; line-height: 25.200000762939453px;"><span style="font-size: large;">http://www.pragmaticworks.com/LearningCenter/FreeTrainingWebinars/FutureWebinars.aspx?ResourceId=692</span></a><br />
<span style="background-color: white; line-height: 25.200000762939453px;"><span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><br /></span></span>
<span style="background-color: white; line-height: 25.200000762939453px;"><span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><br /></span></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-27184196648576113962014-08-03T16:54:00.000-04:002014-08-03T16:54:25.631-04:00How do I get started with PowerShell?<span style="font-family: Verdana, sans-serif; font-size: large;">My co-workers recently asked me how to get started with PowerShell. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;">Many of them are still writing VBScript and I am VERY willing to help them stop writing VBScript.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">So, I sent the following to them. Most of which is FREE.</span><br />
<br />
<h3>
<span style="font-family: Verdana, sans-serif; font-size: large;">Windows PowerShell Scripting</span></h3>
<div class="MsoNormal" style="background-color: white; color: #222222; margin: 0in 0in 0.0001pt;">
<a href="http://technet.microsoft.com/en-us/scriptcenter/dd742419.aspx" style="color: #1155cc; font-family: Calibri, sans-serif; font-size: 11pt;" target="_blank">http://technet.microsoft.com/<wbr></wbr>en-us/scriptcenter/dd742419.<wbr></wbr>aspx</a><span style="font-family: Calibri, sans-serif; font-size: 11pt;"><u></u><u></u></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background-color: white; margin: 0in 0in 0.0001pt;">
<h3>
<span style="color: #666666; font-family: Verdana, sans-serif; font-size: large;"><b>FREE</b> E-books:</span></h3>
</div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<a href="http://www.hofferle.com/list-of-free-powershell-ebooks/" style="color: #1155cc; font-size: 11pt;" target="_blank">http://www.hofferle.com/list-<wbr></wbr>of-free-powershell-ebooks/</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<a href="http://blogs.technet.com/b/pstips/archive/2014/05/26/free-powershell-ebooks.aspx" style="color: #1155cc; font-size: 11pt;" target="_blank">http://blogs.technet.com/b/<wbr></wbr>pstips/archive/2014/05/26/<wbr></wbr>free-powershell-ebooks.aspx</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background-color: white; margin: 0in 0in 0.0001pt;">
<span style="color: #707070; font-family: Verdana, sans-serif; font-size: 11pt;"><b>The VBScript-to-Windows PowerShell Conversion Guide</b></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<span style="color: #1f497d;"><a href="http://technet.microsoft.com/library/ee221101.aspx" style="color: #1155cc;" target="_blank">http://technet.microsoft.com/<wbr></wbr>library/ee221101.aspx</a></span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; margin: 0in 0in 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: large;">Don Jones’ "Learn 'Something' in a Month of Lunches" books are very good. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;">I have this one.</span></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<a href="http://www.amazon.com/Learn-Windows-PowerShell-Month-Lunches/dp/1617290211" style="color: #1155cc;" target="_blank">http://www.amazon.com/Learn-<wbr></wbr>Windows-PowerShell-Month-<wbr></wbr>Lunches/dp/1617290211</a></div>
<div class="MsoNormal" style="background-color: white; color: #222222; font-family: Calibri, sans-serif; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<br /></div>
<div class="MsoNormal" style="background-color: white; color: #222222; margin: 0in 0in 0.0001pt;">
<span style="font-family: Verdana, sans-serif; font-size: large;">For real world examples, I recommended:</span></div>
<div class="MsoNormal" style="background-color: white; font-size: 11pt; margin: 0in 0in 0.0001pt;">
<a href="http://sqlserverpowershell.com/" target="_blank"><span style="color: #0b5394; font-family: Verdana, sans-serif;">http://sqlserverpowershell.com/</span></a><br />
<div style="font-family: Calibri, sans-serif;">
<a href="http://technet.microsoft.com/en-us/scriptcenter/bb410849.aspx" target="_blank"><span style="color: #0b5394;">http://technet.microsoft.com/en-us/scriptcenter/bb410849.aspx</span></a></div>
<div style="color: #222222; font-family: Calibri, sans-serif;">
<br /></div>
</div>
<div class="MsoNormal" style="background-color: white; margin: 0in 0in 0.0001pt;">
<span style="color: #222222;"><span style="font-family: Verdana, sans-serif; font-size: large;">Finally, </span></span><span style="color: #222222; font-family: Verdana, sans-serif; font-size: large;"><b>The Stairway to SQL PowerShell</b> looks like one of the easiest ways to start.</span></div>
<div class="MsoNormal" style="background-color: white; margin: 0in 0in 0.0001pt;">
<a href="http://www.sqlservercentral.com/stairway/91327/" target="_blank"><span style="color: #0b5394; font-family: Verdana, sans-serif;">http://www.sqlservercentral.com/stairway/91327/</span></a><br />
<div style="color: #222222;">
<br /></div>
</div>
<div class="MsoNormal" style="background-color: white; margin: 0in 0in 0.0001pt;">
<span style="color: #222222; font-family: Verdana, sans-serif; font-size: large;">This is not meant to be a complete list because I didn't want to overwhelm them. You can always find more with your favorite search engine.</span><br />
<span style="color: #222222; font-family: Verdana, sans-serif; font-size: large;">I'm hoping this post will help someone else get started with PowerShell. </span></div>
IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0tag:blogger.com,1999:blog-2076326176980221038.post-14559830200466362242014-07-29T12:41:00.000-04:002014-07-29T19:10:24.623-04:00Checking for SQL Server AlwaysOn patches for Windows Server 2008R2...<span style="font-family: Verdana, sans-serif; font-size: large;">Time moves slower in a big company's data centers.</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: large;">Meaning, you might not get to run SQL Server AlwaysOn Availability groups on Windows Server 2012. If not, </span><span style="font-family: Verdana, sans-serif; font-size: large;">you'll have to check several patches are applied for it to work correctly on Windows Server 2008 R2.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span><span style="font-family: Verdana, sans-serif; font-size: large;">This excellent <a href="http://www.brentozar.com/sql/sql-server-alwayson-availability-groups/">resource</a> provides a list of the needed patches in the FREE AlwaysOn Setup Checklist PDF.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span><span style="font-family: Verdana, sans-serif; font-size: large;">I think the easiest way to determine if all the required patches are installed is by using the PowerShell cmdlet <b>get-hotfix </b>with the <b>-computername</b> and <b>-id</b> parameters.</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">Beware, the example below is a single line.</span><br />
<span style="color: blue; font-family: Verdana, sans-serif; font-size: x-small;"><br />get-hotfix -computername YourServerNameHere -id KB2494036, KB2494162, KB2520235, KB2524478, KB2531907, KB2550886, KB2552040, KB2578103, KB2578113, KB2582281, KB2616514, KB2654347, KB2687741, KB976097, KB980915</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">If any of the patches are found, a five column result set is returned. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">If all the patches are found, you'll see fifteen rows. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">If none of the patches are found, the command throws an error and you'll see <span style="color: red;">red</span>.</span><br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCOLsD-Ubmmh4GhFIvnwnklAtauNCSdaT1LJctjKmceoMRSdW2jlTMtKXfR8A4h2kec_lt-9IJ2Q53C7OlV5sol3wrSfGxwbNi2Zn8oCNhPWoE0zRdvOXUBDHYW8UWQjF480WpJYSKSric/s1600/get-hotfix.jpg" imageanchor="1" style="clear: left; display: inline !important; margin-bottom: 1em; margin-left: auto; margin-right: auto; text-align: center;"><img border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiCOLsD-Ubmmh4GhFIvnwnklAtauNCSdaT1LJctjKmceoMRSdW2jlTMtKXfR8A4h2kec_lt-9IJ2Q53C7OlV5sol3wrSfGxwbNi2Zn8oCNhPWoE0zRdvOXUBDHYW8UWQjF480WpJYSKSric/s1600/get-hotfix.jpg" height="234" width="640" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;"><span style="font-family: Verdana, sans-serif;">White beats red any day.</span></td></tr>
</tbody></table>
<span style="font-family: Verdana, sans-serif; font-size: large;">While writing this post, Windows Server 2012 was approved for PRODUCTION deployment at my big company. </span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;">Does that mean time moves faster when you blog? ;-D</span><br />
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>
<span style="font-family: Verdana, sans-serif; font-size: large;"><br /></span>IT Beats Loading Bombshttp://www.blogger.com/profile/06948492592182113293noreply@blogger.com0