tag:blogger.com,1999:blog-51087641961950213202024-02-20T15:06:51.790-05:00The Ashdar Partners BlogAshdar Partners specializes in Performance Engineering (and re-engineering) of Microsoft SQL Server database systems.Darin Straithttp://www.blogger.com/profile/04921427390476369554noreply@blogger.comBlogger97125tag:blogger.com,1999:blog-5108764196195021320.post-54750302829239008762020-05-19T18:08:00.002-04:002020-05-19T18:08:38.247-04:00What I'm working on nowI hope that you are all safe in this time of COVID.<br />
<br />
I am (slowly) working through the "Automate the Boring Things (with Python)" class over at Udemy.<br />
<br />
I am keeping my code/notes/experiments in an <a href="https://github.com/ashdar/automate-boringstuff" target="_blank">open GitHub repository</a>. You can read my raw files and see how I think when I write programs in a language I am not at all familiar with.<br />
<br />
I have also been (slowly) updating my old "Tools I use" <a href="https://github.com/ashdar/tools-i-use/wiki" target="_blank">wiki at github</a>. This includes things like programmer's editors and some of the languages I have used over the decades.<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0Downingtown, PA 19335, USA40.0064958 -75.703274239.982171300000005 -75.7436147 40.0308203 -75.6629337tag:blogger.com,1999:blog-5108764196195021320.post-31662917675059870552019-06-24T08:00:00.000-04:002019-06-24T08:00:07.382-04:00News Flash: Old dog learns new tricks (or tries to)Lately, I have been trying to up my game a bit and one of the things I am doing is using some of the latest tools and bits of things.<br />
<br />
(Partly, this is because I have been working with some old technology lately and I am feeling "dated". Ask me about Fox Pro, if you dare.)<br />
<br />
<b>PowerShell</b><br />
After many years of not seeing value in updating, I am moving to PowerShell 6. (Version 6.2, specifically.) Frankly, more things work than I expected. I haven't seen any performance regressions and things have gone smoothly. I think I spent more time incorporating the PowerShell version into my Prompt function than anything else that I had to do because of the upgrade.<br />
<b><br /></b>
<b>SSMS</b><br />
I am running the absolutely-latest build of SSMS. I skipped some SSMS builds when the removed the diagramming functionality. Now that it has been put back into the product, I am on the update train again.<br />
<br />
Aside: The diagramming feature isn't awesome but it is easy to use, requires no installation, doesn't cost anything and is more than adequate for 95% of the things I need such a tool for. I know that it isn't a real "enterprisey" ERD tool, but I don't need one. In fact, if they took out all of the "modify the tables in the database" features, I would like it more. The main thing is that, sometimes, you just want to look at a diagram of a subset of the tables in a database.<br />
<br />
<b>Windows 10 1903 Update</b><br />
After not getting any update action for weeks after it was released, I bit the bullet and forced this latest Windows release onto my main laptop. (Carpe Diem, right?) It's been fine so far. The blurred-out login display was a little jarring at first. Multi-monitor has always been the shakiest feature of my laptop, but it has not been any worse after updating.<br />
<br />
<b>DbaTools</b><br />
After several years of "beta", <a href="https://dbatools.io/dbatools10/" target="_blank">DbaTools </a>has had it's first release that is judged as production-ready. I've updated and I'm slowly looking through my code for issues. I've been using this as a production tool for years. I'm excited for this release because it validates all of the work that has been done on the tool and the names of functions should stop jumping around so much.<br />
<br />
<b>Learnings</b><br />
I spent a lot of time watching things on YouTube (or the SQL PASS site) in order to learn new things and see how other people approach the problems that I probably have. Lately, I have been focusing on the <a href="https://www.youtube.com/watch?v=Uy5Qd9g25Dg&list=PLfeA8kIs7Cocir1-TuSN3mOnj3qzyRShA" target="_blank">PowerShell + DevOps Global Summit 2019 videos</a>.<br />
<br />
<b>Just For Fun</b><br />
I am trying out the new "Windows Terminal", which is in preview and available in the Windows Store. I found this through a <a href="https://www.hanselman.com/blog/YouCanNowDownloadTheNewOpenSourceWindowsTerminal.aspx" target="_blank">post on Hanselman's site</a>. It found my Windows Subsystem for Linux (WSL) and gave me bash, it found my new and old PowerShell installations and my old, trusty cmd shell (which I still sometimes use for <a href="https://chocolatey.org/" target="_blank">chocolatey</a>). I haven't put it into heavy use yet, but nearly everything seems OK so far. (The settings menu pick doesn't seem to be working properly for me.)<br />
<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0Downingtown, PA 19335, USA40.0064958 -75.7032742000000139.982171300000005 -75.743614700000009 40.0308203 -75.662933700000011tag:blogger.com,1999:blog-5108764196195021320.post-17080957527153636782019-06-22T13:35:00.000-04:002019-06-22T13:35:13.298-04:00DbaTools version 1.0 has been released(Actually, they are up to version 1.0.2 already.)<br />
<br />
I've been using <a href="https://dbatools.io/dbatools10/" target="_blank">DbaTools </a>for a number of years. I have come to rely on it more and more. Now, I find it at least as deeply entwined in my PowerShell code as the SqlServer module is.<br />
<br />
All right-thinking people use DbaTools. And you should, too.<br />
<br />
More seriously, DbaTools is one of the few PowerShell modules I absolutely rely on, on a daily basis. I use DbaTools so frequently that I can't easily categorize it all. In short, I can:<br />
<br />
<ul>
<li>Check servers, instances, databases, disks, security and many other things for issues on a daily basis</li>
<li>Check business rules on a daily basis</li>
<li>Restore databases to test environments on an ad-hoc basis. I have this working so smoothly that I forget that I have Ola Hallengren's backup scripts actually running the database backups. </li>
<li>Load data into databases</li>
<li>Extract data from databases</li>
</ul>
<div>
I've never actually used DbaTools for it's original purpose, which was migrating databases and instances onto new computers. It can still do that, but it has added so much more goodness over the years that you should install it anyway. There really is something for everyone in DbaTools.</div>
<div>
<br /></div>
<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-43902789827071339662019-01-19T11:30:00.000-05:002019-01-19T11:30:10.847-05:00<br />
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
If you want to see a
cool ten-minute, "lightning" demo of how you can use PowerShell and
Excel together to analyze data or produce nice reports, <a href="https://youtu.be/fDQvdIEda_c?list=WL&t=467">watch this YouTube video</a>,
from 7:47 to 18:22. This is presented by Doug Finke, the author of the <a href="https://github.com/dfinke/ImportExcel">Import-Excel</a> PowerShell
module.</div>
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-51268278874292278272018-08-26T17:00:00.000-04:002018-08-26T17:00:15.378-04:00What I did for the week ending 2018/08/24<span style="font-family: Arial, Helvetica, sans-serif;">The highlights for this week have been a few videos from the free-to-view PASS Summit 2016 archive, available at <a href="http://pass.org/">PASS.org</a>.</span><br />
<b><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></b>
<b><span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></b>
<div style="margin: 0in;">
<b><span style="font-family: Arial, Helvetica, sans-serif;">Managing SaaS
Application Databases with Elastic Jobs: SQL Agent and More for Azure SQL
Database, presented by Deborah Dove</span></b></div>
<br />
<ul>
<li>Essentially, "Elastic Jobs" is SQL Agent for Azure SQL. She also talks about "Elastic Query", which allows you to run queries on all of your databases, or a specific subset of them.</li>
</ul>
<br />
<b><span style="font-family: Arial, Helvetica, sans-serif;">Azure
Data Services: Spotlight on Azure SQL Database, presented by Debora Dove</span></b><br />
<br />
<ul>
<li>I think that this is a good introduction to Azure SQL and it covers Elastic Pools. I'm sure that I learned a few things. One thing that bothers ms is the low query/minute ceilings for the various offerings.</li>
</ul>
<br />
<div style="margin: 0in;">
<b><span style="font-family: Arial, Helvetica, sans-serif;">Design Patterns for
SaaS Applications with Azure SQL Database, presented by Bill Gibson</span></b></div>
<div style="margin: 0in;">
</div>
<ul>
<li>If you are going multi-tenant, sharding and employing Elastic Pools seems to be the only sane choice.</li>
<li>"Most
of our customers are compute-bound, not storage-bound."</li>
<li>There are various clever things you can do with pools and tagging.</li>
</ul>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-57232402673051892042018-08-19T17:00:00.000-04:002018-08-19T17:00:18.834-04:00What I did for the week ending 2018/08/17<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">The summer has been busy and my Azure training schedule has suffered. Here are a few highlights from the last few weeks of study.</span><div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">The following are presentations that occurred during SQLPASS Summit 2016. I can't link to these presentations directly because they are behind a paywall (though it is free to subscribe):</span></div>
<div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<div style="font-size: 12pt; margin: 0in;">
</div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><b>Backup and Restore SQL
Server Databases in Microsoft Azure, presented by <span style="font-size: 12pt;">Andy McDermid and Pinal
Dave</span></b><span style="font-size: 12pt;"><br /></span></span></div>
<div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 12pt;">This presentation is about Virtual Machines, not SQL Azure. My takeaways were:</span></span><ul>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Segregating data, log, tempdb and backup locations is still recommended practice.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">The "backup to URL" feature can be useful because frees up a disk because it is not needed to hold backup files and writing to a URL doesn't count as bandwidth usage against your VM disks. "Backup to URL" can stripe the data just like writing "regular files" can. You need to ensure that the costs associated with the (required) Azure Storage Account make sense.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">You can stripe VM disks for performance, but remember that VM sizing has rate-limits on the disk performance. If striping provides capacity that exceeds those rate-limits, you won't get the performance benefit that you expect.</span></li>
</ul>
<div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<div style="font-size: 12pt; margin: 0in;">
<b><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Virtual SQL Servers.
Actual Performance, presented by <span style="font-size: 12pt;">David Klee</span></span></b></div>
<div style="font-size: 12pt; margin: 0in;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="font-size: 12pt; margin: 0in;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Klee is always worth listening to, though his client's systems are much bigger than anything I've seen. My takeaways were:</span></div>
<div style="font-size: 12pt; margin: 0in;">
</div>
<ul>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Your virtual sockets should look like your physical sockets. Put everything inside of a NUMA node, if you can.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Always consider: "What if my VM gets moved to a host with a different processor configuration?"</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Paraphrased:
"Changed from 1x16 (socket x core) to 2x8 and the performance went up
25%"</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Paraphrased: "A client had every VM
set to 64 vCPU. Changing from 64 vCPUs to 4 vCPUs got a throughput 3.5 times higher than anything the client had seen up to that point".</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Turn off "hot-add CPU" because it disables proper NUMA configuration.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Hypervisors generally ignore hyper-thread "cores" until the server is really loaded up. That level of load should not happen often. Therefore, there is little use in turning HT off in the BIOS.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">If your storage does compression, rely on that and turn off SQL Server's data compression.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Virtual Disk Controllers (VDCs) are still a problem. Creating additional (non-default) VDCs and spreading your IO load around is recommended.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">As always, test any change to make sure that you get what you expect.</span></li>
</ul>
</div>
<div>
<div style="font-size: 12pt; margin: 0in;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="font-size: 12pt; margin: 0in;">
<b><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">SQL Server in Azure
VM: Best Practices, Latest Features, and Roadmap, presented by <span style="font-size: 12pt;">Luis Vargas</span></span></b></div>
<div style="font-size: 12pt; margin: 0in;">
<span style="font-size: 12pt;"><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">and </span></span></div>
<div style="font-size: 12pt; margin: 0in;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><span style="font-size: 12pt;"></span></span></div>
<div style="margin: 0in;">
<b><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></b></div>
<div style="margin: 0in;">
<b><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">SQL Server High Availability & Disaster Recovery in Windows Azure, presented by Lous Vargas, Sanjay Misra, et al</span></b></div>
<div style="margin: 0in;">
<b><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></b></div>
<div style="margin: 0in;">
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Both of these were very good, with some overlap. I liked the first one so much (which Vargas presents "solo"), I watched the second one when I noticed that he was one of the presenters. </span><span style="font-family: "Helvetica Neue", Arial, Helvetica, sans-serif;">My takeaways were:</span></div>
<div style="margin: 0in;">
</div>
<ul>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">You are better off using storage pools, not MDF/NDF files, for striping and performance.</span></li>
<li><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;">Licensing seems to only get more complex as time goes by.</span></li>
</ul>
<br />
<div>
<span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></div>
<div style="font-size: 12pt; margin: 0in;">
<b><span style="font-size: 12pt;"><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></span></b></div>
<div style="font-size: 12pt; margin: 0in;">
<b><span style="font-size: 12pt;"><span style="font-family: Helvetica Neue, Arial, Helvetica, sans-serif;"><br /></span></span></b></div>
<div style="font-size: 12pt; margin: 0in;">
<b><span style="font-size: 12pt;"><br /></span></b></div>
</div>
</div>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-2901756779762914322018-07-22T17:00:00.000-04:002018-07-22T17:00:09.527-04:00What I did for the week ending 2018/07/21<div>
<br /></div>
<div>
I found a version of my favorite SSDT presentation (from PASS Summit 2016) <a href="https://www.youtube.com/watch?v=LSBOtv5VbKk">on YouTube</a>. On YouTube, it is named "Continuous Integration with SQL Server Data Tools", presented by Jon Boulineau for the Nashville SQL Server Users Group.</div>
<div>
<br /></div>
<div>
This seems to be an earlier (?) version of a presentation called "Agile Development Fundamentals: Continuous Integration with SSDT", given at a SQL Saturday. In an earlier blog post, I named the PASS version of the presentation as "my new favorite SSDT video". Both presentations were done by the same person and seem to be the same content. The sound on the YouTube version isn't as good as the PASS Summit version, but you do not have to go through the PASS sign-up process to see it. (Though I do recommend PASS for anyone who wants to know how SQL Server works or how Microsoft expects you to use it.)</div>
<div>
<br /></div>
<div>
Jon goes over several things, including an introduction to SSDT, the test project feature and deploying builds. It's just over an hour long.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
According to Microsoft's Certification Planning web site, I am officially a "Microsoft Certified Professional", having passed the following exams:</div>
<div>
<ul>
<li>Querying Microsoft SQL Server 2012/2014</li>
<li>Administering Microsoft SQL Server 2012/2014 Databases</li>
<li>Implementing a Data Warehouse</li>
</ul>
</div>
<div>
I'm going to need to evaluate what exam(s) to take next. The versions of SQL Server that I'm tested on are getting old and dusty but I need more Azure in my (professional) life.</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
I have started the edX.org "Azure 215x: Cloud Administration" course. Partly, I am interested in how edX runs it's online courses. I've taken a few other thing online over the years. I tend to do better with self-directed learning. The course is not very long, just a few hours, but I'm going to drag my feet until August starts in order to maximize the free time I have to use Azure tools. (There is a free account level for 12 months, but the minimum granularity seems to be "one month", so I'll dilly-dally for a week.)</div>
<div>
<br /></div>
<div>
<br /></div>
<div>
<div>
Microsoft is now saying that <a href="https://azure.microsoft.com/en-us/blog/announcing-new-options-for-sql-server-2008-and-windows-server-2008-end-of-support/">you can get security patches for SQL Server 2008 for free after extended support ends on 7/9/2019</a>. <i>The catch is that you have to move your SQL Server 2008 instance to Azure</i>. IOW, they are dangling extended lifetime for existing SQL Server 2008 applications in front of organizations in order to get more people onto their cloud systems.</div>
</div>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-17675342154097489562018-07-08T17:00:00.000-04:002018-07-08T17:00:10.291-04:00What I did for the week ending 2018/07/07I do not have much to report this week.<br />
<br />
I've started the <a href="https://cloudsociety.learning.microsoft.com/courses/course-v1:Microsoft+AZURE215x+2018_T1/about">Microsoft Professional Cloud Administration</a> course over at edX.org. I've only done the very first units and have yet to form an opinion.<br />
<br />
I'll be looking at learning a few things about Confluence in the upcoming weeks,as well.Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-23903794153308477162018-07-01T17:00:00.000-04:002018-07-01T17:00:00.386-04:00What I did for the week ending 2018/06/30Over the last two weeks, I've been watching PASS Summit 2016 videos. No particular presentation really stands out and I've been watching presentations that cover topics outside of my core competencies, so I haven't been keeping an inventory.<br />
<br />
I've signed up for an edX course on Azure. I expect this to take up all of my training time budget for the next few months. I've taken short online courses before, including Rhetoric, Learning and Spanish, but this will be my first time taking an edX course. Those low-intensity courses and required only a few hours a week, while (IIRC) the edX course materials state that I should budget 12 hours a week for the next three months. I'm excited to see how a more demanding course will work out.Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-15019579650327207312018-06-17T17:00:00.000-04:002018-06-17T17:00:04.375-04:00What I did for the week ending 2018/06/16<span style="font-family: Arial, Helvetica, sans-serif;">I have finished watching the PowerShell + DevOps Global Summit 2018 presentations on YouTube that caught my interest. If you have any interest in applied PowerShell, I suggest that you have a look at their <a href="https://www.youtube.com/watch?v=sN7xw_jq_64&list=PLfeA8kIs7CocGXuezOoYtLRdnK9S_Mq3e">playlist</a>. there are nearly 60 presentations and I'm sure that something in there will interest you. If not, <a href="https://www.youtube.com/user/powershellorg/featured">PowerShell.org has many other presentations</a>.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">After finishing up the PowerShell presentations, I went looking for some good tutorials on Jira. I found a lot of marketing, but I didn't find much on useful, implementable details. Some of that seems to be due to Jira being flexible enough to do whatever you want. That's great, but my problem is that I'm not at the point where I know what I want. I will just endeavor to persevere on this front. </span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">For the past week or two, I've been spending more time with <a href="http://www.trello.com/">Trello </a>than I had been. I had a ten minute look at <a href="http://www.kanbanflow.com/">Kanbanflow</a>, which seems like a worthy competitor to Trello. All of this activity is the fault of my reading <i>The Phoenix Project</i>, which re-ignited my interest in thinking about work strategically.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">The fact of the matter is that you can turn many information tools into a rough Kanban-style task manager. I use OneNote to do task management. I have been using methods based on <a href="https://gettingthingsdone.com/">GTD</a> since I read David Allen's book many years ago, but I've been moving towards Kanban. (A benefit of using OneNote is that my notes on my tasks become part of what I search when I say to myself "Didn't I do this before?". If something is buried in Trello, I might not find it so easily. I might not even think to search Trello.) You could use text files in some folders for a crude task list. The web sites start to shine when you need to work as part of a team or need better reporting.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I also did a little DFS research, because I am curious as to how that works even though it isn't really my bread-and-butter. One of the things I learned was that DFS was introduced in Windows Server 2003. I thought that DFS was a more recent innovation and (maybe Windows Server 2008). <b>It is good to know things. </b></span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I've started looking through the SQLPASS Summit 2016 presentations. I identified about 60 presentations that looked interesting. I've started going through them. The stand-out presentation so far is <i>Agile Development
Fundamentals: Continuous Integration with SSDT</i>, which was presented by Jon Boulineau. <b>This
is my new favorite "How to do SSDT" presentation.</b> It covers SSDT basics,
testing and deployment. I have been using SSDT since the days of "Data
Dude" back around 2008 (or earlier) and I need to improve my use of SSDT
to match Jon's.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">(I can't publish direct links to the SQLPASS site because of the way their site is built. You will just have to log into the SQLPASS site and search for Jon's work.)</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I have said this before, but I'll say it again: If you have any interest in SQL Server, you should join SQLPASS. They don't bother you very much and you will get access to hours and hours of free SQL presentations. Yes, much of the content is "old", but SQL Server doesn't move that fast and "older" doesn't mean "obsolete". I would avoid anything earlier than SQL Server 2014, unless you stuck on an older platform.The quality and focus of the SQLPASS presentations tends to be better than what you find randomly searching around on YouTube. Additionally, you don't have to weed out as many introductory presentations for newbies. Even if you are "just an analyst", there are enough presentations on reporting technologies for you to find something that you can use.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I am still finishing up Nate Silver's <i>The Signal and the Noise</i>. I found the chapter discussing the 1976 Swine Flu incident interesting as I kind-of-just-barely remember that time.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-13616441186318748592018-06-11T17:00:00.000-04:002018-06-11T17:00:08.422-04:00What I did for the week ending 2018/06/09<br />
I've watched so many of the Powershell + Devops Summit 2018 videos in the last week that I've lost track of the best ones. I won't bore you with a list. I'll just point you to the <a href="https://twitter.com/ashdarpartners">official Ashdar Partners twitter feed</a>. The feed shows all of the videos that I've liked.<br />
<br />
I have three more videos from the Summit that I want to watch. After that, I'll be switching focus to Jira for a while because one of my clients has adopted Jira and I feel a little lost.<br />
<br />
After Jira, I'll be going back to the SQL PASS 2016 videos that I put aside a few months back. With my recent certification and the way that the IT universe seems to be going, I am starting to believe that Azure is the future.<br />
<br />
I'm also on a kick to read more. I have a good local library and I should take more advantage of it. I have three branches within easy driving distance, including the main branch, and I have easy access to any book at any branch through their inter-branch loan system. After finishing "The Phoenix Project" last week, I am reading Nate Silver's "The Signal and the Noise". It is a lighter read than the book by Nassim Taleb that I read last year.<br />
<br />
<br />
<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-27079831712503667792018-06-03T17:00:00.000-04:002018-06-03T17:00:09.196-04:00What I did for the week ending 2018/06/02I took advantage of the following learning opportunities:<br />
<br />
<ul>
<li>PowerShell Team: Using PowerShell From a Browser to Manage Cloud Resources by Danny Maertens on <a href="http://youtu.be/b8_nE2HxXvo?a">YouTube</a></li>
<li>CSV, JSON and XML (Oh My!) by Jeff Hicks on <a href="http://youtu.be/Ukuj_DxueIc?a">YouTube</a></li>
<li>WebJEA: PowerShell driven Web Forms for Secure Self-Service by Mark Domansky on <a href="http://youtu.be/SWyG_GRddsA?a">YouTube</a></li>
</ul>
<br />
Perhaps more interestingly...<br />
<br />
Last week, the library didn't have the books I was actually looking for, so I picked up <i>The Phoenix Project</i> by Kim, et al. I should have read this book a couple of years ago. I've seen this book recommended as required reading for greater DevOps understanding a few times.<br />
<br />
I've been following the DevOps movement for a while, at a distance. I haven't paid much attention to DevOps's underpinnings or the scope of it's ideas. People don't hire me to re-engineer their business processes. As I did with TDD over ten years ago, I have adopted what I can of DevOps, according to my understanding of it.<br />
<br />
"DevOps" is usually sold to technologists as <i>tools </i>(open-source, closed-source or roll-your-own), or perhaps some tactical approaches to things. <i>Tools are easy to sell. </i>(If we are talking about open source tools, "sell" is metaphorical but someone still needs to convince you that you need that tool.). You put up a Kan-ban board, you use git, you install a CI/CD system and you are done. Frankly, I've seen tools come and go (ah...Borland...) and I'm jaded. Most tools do not last more than a few years. I've seen waterfall projects outlast the tools they were based on. Many tools are just old wine in new bottles. (A new text editor? Sure, I'll give it a go. Is it better than the old one? Yes. Is it revolutionary? No.)<br />
<br />
<i>Concepts are not easy to sell. </i>The book pushes the DevOps concept well beyond my previous understanding. I feel that my understanding of what the DevOps folks are trying to do has been radically upgraded. It encompasses tools, tactics and <i>corporate strategy</i>. IT isn't just something that "the IT department does". IT involves much of, if not all of, a company. whether the company understands it or not. IT should be seen as a competitive asset and data is as much the life blood of the company as cash flow is, or chargebacks between departments are. I've read that "going DevOps" requires a change in mindset, but I'd never understood the true breadth of what would be required, including from people who traditionally have as little as possible to do with IT.<br />
<br />
All of the book's stories about WIP, queued work and rework all ring true. My first job out of school was in a factory. I worked on testing programs and hardware. I didn't really see the factory's products as my worry, but my boss did. He worried about WIP all of the time. I would see him out on the manufacturing floors, counting the pallets of unfinished goods that were stacked all over the building and frowning. Just figuring out how much product was in the pipeline was a problem, they would conduct "inventory counts" a few times a year, when nearly all other plant work was frozen for a day or more. I saw <i>firsthand </i>the chaos that happened when "finished" goods started failing tests and had to be reworked. Those tests were run by the programs that I wrote.<br />
<br />
I've made note of many of the books mentioned after the end of the novel. I'll be following up on them at my local library.<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-24911380065595295052018-05-27T17:00:00.000-04:002018-05-27T17:00:07.516-04:00What I did for the week ending 2018/05/26<br />
I am slowly going through all of the PowerShell + DevOps Global Summit 2018 talks that I find interesting.<br />
<br />
I took advantage of the following learning opportunities:<br />
<br />
<ul>
<li><i>Whip Your Scripts into Shape: Optimizing PowerShell for Speed</i> by Joshua King <a href="http://youtu.be/Yp_m5T_kyJU?a">on YouTube</a></li>
<li><i>Application Provisioning with DSC and Octopus Deploy </i>by Josh Duffney <a href="http://youtu.be/qaR61q8w8Cc?a">on YouTube</a></li>
<li><i>PlatyPS: PowerShell Help meets Markdown </i>by Sergei Vorobev <a href="http://youtu.be/zGOl5g_AJ5U?a">on YouTube</a></li>
<li><i>Defending against PowerShell Attacks-In theory and in practice</i> by Lee Holmes on YouTube</li>
</ul>
<br />
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-17349273619574781482018-05-25T17:00:00.000-04:002018-05-25T17:00:01.712-04:00Certified, as opposed to merely CertifiableI passed the 70-767 <i>Implementing a Data Warehouse</i> exam this week.<br />
<br />
I first read Kimball's <i>Data Warehouse Lifecycle Toolkit</i> and <i>The Data Warehouse Toolkit</i> over fifteen years ago, so it's about time. I still have those books, although many other books have hit the recycling bin. A lot of the underlying technology has changed in the data warehousing area, but a grounding the basics of facts and dimensions is still important.<br />
<br />
I passed the exams for <i>Querying Microsoft Server 2012/2014</i> and <i>Administering Microsoft SQL Server 2012/2014 Databases</i>, a while back. My Microsoft Learning dashboard points tout that this third success qualifies me as a "Microsoft Certified Professional". The last time I was Microsoft-certified in anything was in 1998, when I had a certification in Windows 98 desktop support, or some such thing. I don't think I ever did anything with that.<br />
<br />
Co-incidentally, I used the last of my last business cards while attending a talk on Machine Learning at Jacquette Consulting on Wednesday. It must be time for new cards.Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-28107903590616214942018-05-20T17:00:00.000-04:002018-05-20T17:00:09.389-04:00What I did for the week ending 2018/05/19Here are the learning opportunities that I took advantage of last week:<br />
<br />
<ul>
<li><i>The Build Release Pipeline Model for Mere Mortals</i> by Ryan Coates on <a href="http://youtu.be/ccEO5buASv8?a">YouTube</a></li>
<li><i>PowerShell Team: Inventory Your Server Environment and Detect Change at Scale</i> by Jenny Hunter on <a href="http://youtu.be/91A_Bsyzu-g?a">YouTube</a></li>
</ul>
<br />
<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-64160357395074247072018-05-13T17:00:00.000-04:002018-05-19T12:12:03.456-04:00What I did for the week ending 2018/05/12<br />
Here are the learning opportunities that I took advantage of last week.<br />
<br />
Due to my interest in and use of <a href="https://dbatools.io/introducing-dbachecks/">DbaChecks</a>, I need to get a better handle on PowerBI:<br />
<br />
<ul>
<li><i>Introduction to Power BI Desktop</i> with Dustin Ryan on <a href="https://www.youtube.com/watch?v=TMMOByVrgzY">YouTube</a></li>
</ul>
<br />
<div>
<br /></div>
<div>
PowerBI seems to be the only reasonable way to visualize the results of the tens of thousands of tests I'm running.</div>
<div>
<br />
I could not resist watching a several things from the PowerShell + DevOps Global Summit 2018. The following are all from the Global Summit:</div>
<br />
<ul>
<li><i>Beyond Syntax: Pester Testing</i> with Dave Wyatt on <a href="http://youtu.be/0fFrWIxVDl0">YouTube</a></li>
<li><i>Keynote: State of the Community</i> with Don Jones on <a href="https://www.youtube.com/watch?v=sN7xw_jq_64">YouTube</a></li>
<li><i>PowerShell 2018: State of the Art</i> with Jeffrey Snover on <a href="https://www.youtube.com/watch?v=us4HTxtjfa8">YouTube</a></li>
<li><i>A Historical Architectural Tour of PowerShell</i> with Bruce Payette on <a href="https://www.youtube.com/watch?v=yWwcEsNnzBM">YouTube</a></li>
<li><i>Become a PowerShell Debugging Ninja</i> with Kirk Munro on <a href="https://www.youtube.com/watch?v=zhjU24hbYuI">YouTube</a></li>
</ul>
<br />
I don't usually listen to things like keynotes, but I find that Don Jones and Jeff Snover always have something valuable to share.<br />
<br />
I am surprised with the renaming of PowerShell Core to PowerShell. I am sure that won't be confusing to casual scripters. /s<br />
<br />
If you'd like to keep tabs on what I am watching more closely, you can head over to the official <a href="https://twitter.com/ashdarpartners">Ashdar Partners twitter feed</a>. I am not big on chitchat. It's mainly YouTube sharing what I watch and (what I hope are mostly) quality retweets.<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-28615156980745165682018-05-06T17:00:00.000-04:002018-05-06T17:00:15.159-04:00What I did for the week ending 2018/05/05<br />
<div style="border-width: 100%; direction: ltr;">
<div style="direction: ltr; margin-left: 0in; margin-top: 0in; width: 7.5in;">
<div style="direction: ltr; margin-left: 0in; margin-top: 0in; width: 7.5in;">
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
I took advantage of
these learning opportunities:</div>
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
<br /></div>
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
</div>
<ul>
<li>Building Your
T-SQL Tool Kit: Window Function Fundamentals with Christina E. Leo on <a href="https://www.youtube.com/watch?v=tUK3ohs7uDI" style="font-size: 12pt;">YouTube</a></li>
<li>SQL
Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance
Headaches with Adam Machanic on <a href="https://www.youtube.com/watch?v=GSZPvF2u6WY" style="font-size: 12pt;">YouTube</a></li>
<li> <span style="font-size: 12pt;">Beyond Pester 101: Applying
testing principles to PowerShell by Glenn Sarti on </span><a href="https://www.youtube.com/watch?v=NrUxgSaFvtk" style="font-size: 12pt;"><span style="font-size: 12pt;">YouTube</span></a><span style="font-size: 12pt;">.</span></li>
</ul>
</div>
</div>
</div>
<br />
<div>
<div style="font-size: 12pt; margin: 0in;">
<br /></div>
<div style="font-size: 12pt; margin: 0in;">
The PowerShell +
DevOps Global Summit has released their 2018 videos (62 in all!) and all I want
to do is watch PowerShell videos all day. Life intervenes, however...</div>
<div style="font-size: 12pt; margin: 0in;">
<br /></div>
<div style="font-size: 12pt; margin: 0in;">
<br /></div>
<ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc">
</ul>
<br />
<div style="border-width: 100%; direction: ltr;">
<div style="direction: ltr; margin-left: 0in; margin-top: 0in; width: 7.5in;">
<div style="direction: ltr; margin-left: 0in; margin-top: 0in; width: 7.5in;">
</div>
</div>
</div>
</div>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-86088785184091052172018-04-29T17:00:00.000-04:002018-04-29T17:00:38.464-04:00What I did for the week ending 2018/04/28<br />
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
<br /></div>
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
I attended SQL
Saturday in Blue Bell, PA. Specifically, I attended these sessions:</div>
<ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc">
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">Effective DW Storage Patterns
with Miner</span></li>
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">Azure SQL DW Migrate On-Premise
to Cloud, with Zhang</span></li>
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">Extending DevOps to SQL Server
with Fritchey</span></li>
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">Data Governance and Master Data
Management, with Napoli</span></li>
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">Successfully Running SQL in
AWS, with Carrig</span></li>
</ul>
<div style="font-family: Arial; font-size: 12.0pt; margin-left: .375in; margin: 0in;">
<br /></div>
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
<br /></div>
<div style="font-family: Arial; font-size: 12.0pt; margin: 0in;">
I took advantage of
these additional learning opportunities:</div>
<ul style="direction: ltr; margin-bottom: 0in; margin-left: .375in; margin-top: 0in; unicode-bidi: embed;" type="disc">
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">I watched Creative Uses of the
APPLY Operator, session 1, with Itzik Ben-Gan at SQLug.se on </span><a href="https://www.youtube.com/watch?v=-m426WYclz8"><span style="font-family: Arial; font-size: 12.0pt;">YouTube</span></a></li>
<li style="margin-bottom: 0; margin-top: 0; vertical-align: middle;"><span style="font-family: Arial; font-size: 12.0pt;">I watched Creative Uses of the
APPLY Operator, session 2, with Itzik Ben-Gan at SQLug.se on </span><a href="https://www.youtube.com/watch?v=goyWzAu-AA0"><span style="font-family: Arial; font-size: 12.0pt;">YouTube</span></a></li>
</ul>
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-85032203874129343352018-04-22T17:00:00.000-04:002018-04-22T17:00:01.314-04:00What I did for the week ending 2018/04/21<span style="font-family: "arial" , "helvetica" , sans-serif;">The big thing for this week is <a href="http://www.sqlsaturday.com/714/EventHome.aspx">SQL Saturday #714</a>, which will be held at Montgomery County Community College on 4/21. I'm writing this post a little early, as I won't have time to write over the weekend.</span><br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;">The time I had planned to spend on finishing up 70-767 has been taken up by </span><span style="font-family: "arial" , "helvetica" , sans-serif;">finishing up the annual and quarterly book keeping and </span><span style="font-family: "arial" , "helvetica" , sans-serif;">a strange issue with my backup laptop (an old Core Duo ThinkPad T500) refusing to update to a recent version of Windows 10. If I get the laptop working, I will post a more detailed entry. Unfortunately, I'm starting to think that it's time to retire the old workhorse or put Ubuntu on it.</span>Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-9887115221225919932018-04-16T17:00:00.000-04:002018-04-16T17:00:31.528-04:00What I did for the week ending 2018/04/14<span style="font-family: "arial" , "helvetica" , sans-serif;">I don't know what happened with the date in the title of the last blog entry. I don't think that it will cause any harm to anyone, so I'm going to leave it as-is.</span><br />
<br />
Here are the main things I worked on last week (in addition to my 'normal' work for clients, which I don't detail here):<br />
<br />
<ul>
<li>I
watched several videos from the <a href="https://www.youtube.com/playlist?list=PL08903FB7ACA1C2FB" style="font-family: Arial, Helvetica, sans-serif;">"SQL
Server tutorial for Beginners" playlist</a><span style="font-family: "arial" , "helvetica" , sans-serif;"> on YouTube, which is produced
by kudvenkat. As you know, I am not a beginner with SQL Server. Even so, I
don't have much practical experience with the LEAD(), LAG() and windowing
functions. I've been working on a project where these functions are beneficial,
so I am learning more about them. I found the ten or so videos that I watched
up around the "Part 110" area to be well-explained.</span></li>
<li>I am up to page 145 in my "Implementing a SQL Data Warehouse" review. </li>
<li>My progress was impeded by having to catch up with the quarterly and annual bookkeeping.</li>
</ul>
<br />
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
<span style="font-family: "arial" , "helvetica" , sans-serif;"><br /></span>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-33178843835300950882018-04-07T17:00:00.000-04:002018-04-07T17:00:06.157-04:00What I did for the week ending 2018/04/10<br />
<div style="font-size: 12pt; margin: 0in;">
<span style="font-family: Arial, Helvetica, sans-serif;">Here is the progress for the week:</span></div>
<div style="font-size: 12pt; margin: 0in;">
<br /></div>
<div style="font-size: 12pt; margin: 0in;">
</div>
<ul>
<li>I watched the
"Columnstore Indexes", episode 12 of Kalen Delaney's Weekly Webinar
series on <a href="https://www.youtube.com/watch?v=Xml_k3Q6ubg" style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt;">YouTube</a><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt;">.
Kalen references </span><a href="http://www.nikoport.com/category/columnstore/" style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt;">Niko
Neugebauer's blog</a><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt;"> several times in her talk. She also points to the SQL
Server Central </span><a href="http://www.sqlservercentral.com/stairway/121631/" style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt;">"Stairway
to SQL Server Columnstore Indexes"</a><span style="font-family: Arial, Helvetica, sans-serif; font-size: 12pt;"> series of blog postings.</span></li>
</ul>
<br />
<div style="font-size: 12pt; margin: 0in;">
<br /></div>
<div style="font-size: 12pt; margin: 0in;">
<span style="font-family: Arial, Helvetica, sans-serif;">I've spent quite a bit
of time on a couple of dbatools issues, which has negatively impacted the amount of time I
have had to read my 70-767 book. I am only 34 pages into the 70-767 book.</span></div>
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-71219805118415632392018-04-02T06:45:00.000-04:002018-04-02T06:45:00.268-04:00What I did for the week ending 2018/03/30<span style="font-family: Arial, Helvetica, sans-serif;">Last week was a very light week for learning.</span><div>
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span></div>
<div>
<div style="border-width: 100%; direction: ltr;">
<div style="direction: ltr; margin-left: 0in; margin-top: 0in; width: 6.0055in;">
<div style="direction: ltr; margin-left: 0in; margin-top: 0in; width: 6.0055in;">
<div style="font-size: 11pt; margin: 0in;">
<span style="font-family: Arial, Helvetica, sans-serif;">I watched:</span></div>
<div style="font-size: 11pt; margin: 0in;">
</div>
<ol>
<li><span style="font-family: Arial, Helvetica, sans-serif;">DSC in a
vSphere Environment<span style="font-size: 11pt;">
by Luc Dekens on </span><a href="https://www.youtube.com/watch?v=-53_OcptDi8" style="font-size: 11pt;"><span style="font-size: 11pt;">YouTube</span></a><span style="font-size: 11pt;">. Mainly, I am </span>interested
in DSC as I have moved on from VMWare in my home lab.</span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">Test your
Powershell code with AppVeyor for ITPros<span style="font-size: 11pt;"> with André Kamman & Rob Sewell on </span><a href="https://www.youtube.com/watch?v=8Nljk1deSmU" style="font-size: 11pt;"><span style="font-size: 11pt;">YouTube</span></a><span style="font-size: 11pt;">.</span></span></li>
</ol>
<br />
</div>
</div>
</div>
</div>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-85092942912498733072018-03-24T17:00:00.000-04:002018-03-24T17:00:03.931-04:00What I did for the week ending 2018/03/23<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">Another snowpocalypse has come and melted.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I've been busy, but I haven't made much progress on my training this week. Just about the only thing I have done is this:</span><br />
<br />
<ul>
<li><span style="font-family: Arial, Helvetica, sans-serif;">I listened to a <a href="http://runasradio.com/">RunAs Radio</a>
podcast on "<a href="http://runasradio.com/Shows/Show/576" style="font-size: 11pt;">Be the Master</a><span style="font-size: 11pt;">" with Don Jones.</span></span></li>
</ul>
<br />
<br />Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-80839541501428985432018-03-17T17:00:00.000-04:002018-03-17T17:00:39.812-04:00What I did for the week ending 2018/03/16<span style="font-family: Arial, Helvetica, sans-serif;">This week was very busy (work can be so inconvenient :-)) and I didn't get very far in my studies. </span><br />
<ul>
<li>I
went through the MVA course on <a href="https://mva.microsoft.com/en-US/training-courses/installing-configuring-and-managing-microsoft-sql-server-on-linux-18305?l=OD6INUc2E_2813214697" style="font-family: Arial, Helvetica, sans-serif;">SQL
Server on Linux</a><span style="font-family: Arial, Helvetica, sans-serif;">. This is several videos and takes a couple of hours. This required dusting off my aging Linux knowledge. In short, most SQL things are the same. I'm not sure that I would be in a hurry to build a complex cluster just yet, but small, uncomplicated single-instance applications should be fine. </span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">I watched <i>Introduction to Jira & Agile Project Management</i> with Dan Cuparkoff on <a href="https://www.youtube.com/watch?v=NrHpXvDXVrw">YouTube</a>. I'm not unfamiliar with Agile tactics and strategies, but I have not had a chance to work with Jira. </span></li>
<li><span style="font-family: Arial, Helvetica, sans-serif;">My exam reference book for 70-767 arrived but I haven't had a chance to crack it open.</span></li>
</ul>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0tag:blogger.com,1999:blog-5108764196195021320.post-58068883514098266062018-03-10T17:00:00.000-05:002018-03-10T17:00:13.394-05:00What I did for the week ending 2018/03/09<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<div style="margin: 0in;">
<span style="font-family: Arial, Helvetica, sans-serif;">Here in southeastern Pennsylvania, another Snowpocalypse petered out this week (7 to 13 inches of snow turned out to be 2 to 3 inches of slush) and I took advantage of the following learning opportunities:</span></div>
<div style="font-family: Arial; font-size: 11.0pt; margin: 0in;">
</div>
<ul>
<li><i>Performance Troubleshooting made easier New features
in Management Studio</i><span style="font-size: 11pt;"> by That DBAGuy on </span><a href="https://www.youtube.com/watch?v=ZLQkSfhCR7Y&" style="font-size: 11pt;">YouTube</a></li>
<li><i>PowerShell
and KeePass - A poor person's credential database</i><span style="font-size: 11.5pt;"> with Christian Lehrer on </span><span style="font-size: 11.5pt;"><a href="https://www.youtube.com/watch?v=LP5whIs42Jw">YouTube</a></span></li>
<li><i>Advanced
Components in SSIS MS SQL Server Integration Services 2016</i><span style="font-size: 11.5pt;"> with Tim Mitchell on </span><a href="https://www.youtube.com/watch?v=a17RNVAlvI8" style="font-size: 11pt;"><span style="font-size: 11.5pt;">YourTube</span></a><span style="font-size: 11.5pt;">. This is labelled as "SSIS 2016" but was
recorded in 2011. That doesn't matter very much, I've watch Tim present before and it's always illuminating in some way.</span></li>
<li><span style="font-size: 11.5pt; font-style: italic; text-decoration-line: underline;">SSIS Best Practices</span><span style="font-size: 11.5pt;"> on </span><span style="font-size: 11.5pt;"><a href="https://www.youtube.com/watch?v=3CG12SnOnXc">YouTube</a></span></li>
<li><span style="font-size: 11pt; font-style: italic;">Demystifying $THIS, $_, $PSITEM, $$, $Whatever…</span><span style="font-size: 11pt;">
with Jason Yoder on </span><a href="https://www.youtube.com/watch?v=s3hgj4rDtqM&t=11s" style="font-size: 11pt;">YouTube</a><span style="font-size: 11pt;">.</span></li>
</ul>
<br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">I realized that the 70-463 exam has been retired and that I should be targeting 70-767 exam. This is what happens when you let things lie fallow for to long.</span><br />
<span style="font-family: Arial, Helvetica, sans-serif;"><br /></span>
<span style="font-family: Arial, Helvetica, sans-serif;">There seems to be a dearth of SQL Server-specific open learning materials for data warehouse topics, so I bought the Microsoft Press book for 70-767 and I'll be going through that once before taking the exam. This will push me back a couple of weeks, but my knowledge will be more up-to-date. </span>Darinhttp://www.blogger.com/profile/10442944956131032983noreply@blogger.com0