Today's Topic

What did you learn or study today?

2016-07-06 (Wednesday)
How To Survive A Database Disaster - Thomas LaRock
 * http://thomaslarock.com/2016/07/survive-any-database-disaster/

2016-06-30 (Thurday)
Is Resource Monitor (resmon) all I need to troubleshoot storage? - SQLServerCentral
 * http://www.sqlservercentral.com/blogs/confessions-of-a-microsoft-addict/2016/06/23/is-resource-monitor-resmon-all-i-need-to-troubleshoot-storage/
 * https://sqltechblog.com/2016/06/23/is-resource-monitor-resmon-all-i-need-to-troubleshoot-storage

2016-06-29 (Wednesday)
(from: http://sqldatapartners.com/podcast/ episode 48, with Tim Mitchell)
 * https://en.wikipedia.org/wiki/Business_Intelligence_Markup_Language biml

2016-06-27 (Monday)
The Desktop rebuild Part 2
 * https://voiceofthedba.wordpress.com/2016/06/27/the-desktop-rebuild-part-2/

First command: @powershell -NoProfile -ExecutionPolicy Bypass -Command "iex ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))" && SET PATH=%PATH%;%ALLUSERSPROFILE%\chocolatey\bin

2016-06-24 (Friday)
Voice of the DBA - have you ever build a database from scratch?
 * https://voiceofthedba.wordpress.com/2016/06/24/have-you-designed-a-database-from-scratch/

2016-06-22 (Wednesday)
Nice map of computer languages/tech:
 * http://varianceexplained.org/images/network1.png

2016-06-20 (Monday)
Comparing two query plans - SQLServerCentral
 * http://www.sqlservercentral.com/blogs/sqlstudies/2016/06/14/comparing-two-query-plans/

PowerShell One-Liners: Help, Syntax, Display and Files
 * https://www.simple-talk.com/sysadmin/powershell/powershell-one-liners-help,-syntax,-display-and--files/

Powershell Profiles:
 * https://www.simple-talk.com/sysadmin/powershell/persistent-powershell-the-powershell-profile/?utm_source=simpletalk&utm_medium=pubemail&utm_content=powershell-profile-20160620&utm_campaign=sysadmin&utm_term=simpletalkmain

2016-06-19
Get CPU Usage from Windows Command Prompt - Stack Overflow typeperf
 * http://stackoverflow.com/questions/9097067/get-cpu-usage-from-windows-command-prompt

2016-06-16
biml
 * https://www.varigence.com/Biml
 * https://twitter.com/scottcurrie

2016-06-14
Write to File - SQLServerCentral
 * http://www.sqlservercentral.com/scripts/ole/141060/
 * http://www.sqlservercentral.com/Forums/Topic1785902-3401-1.aspx

2016-06-06 (Monday)
A New Sample Database - SQLServerCentral
 * http://www.sqlservercentral.com/articles/Editorial/142225/

Comment about what Sample Database to use: "If you want a significant amount of data to use in test I recommend the stack exchange database as detailed in this blog post:
 * http://www.sqlservercentral.com/Forums/FindPost1792427.aspx

https://www.brentozar.com/archive/2014/01/how-to-query-the-stackexchange-databases/"

Unified Extensible Firmware Interface
 * The Unified Extensible Firmware Interface is a specification that defines a software interface between an operating system and platform firmware. Wikipedia

2016-06-03 (Friday)
Accept Failure - Page 3 Interesting comment:
 * http://www.sqlservercentral.com/Forums/Topic1255712-263-3.aspx
 * http://www.sqlservercentral.com/Forums/FindPost1791915.aspx

2016-06-02 (Thursday)
Consuming JSON Formatted API Data in 2016 - SQLServerCentral
 * http://www.sqlservercentral.com/articles/JSON/141175/

I asked:
 * http://www.sqlservercentral.com/Forums/FindPost1791683.aspx

2016-06-01 (Wednesday)
GoToWebinar - Painting with PowerShell: SQL Server Administration

2016-05-31 (Tuesday)
EdVassie: Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2016, 2014, 2012, 2008 R2, 2008 and 2005. 11 May 2016: now over 37,000 downloads.


 * http://sqlserverfinebuild.codeplex.com/


 * source: http://www.sqlservercentral.com/Forums/FindPost1790747.aspx

2016-05-27
How to drop a table if it exists in SQL Server? - Stack Overflow
 * http://stackoverflow.com/questions/7887011/how-to-drop-a-table-if-it-exists-in-sql-server

Adam Machanic -I sent him a message about wikis
 * http://sqlblog.com/blogs/adam_machanic/

2016-05-24
Unified Approach to Generating Documentation for PowerShell Cmdlets
 * https://www.simple-talk.com/sysadmin/powershell/unified-approach-to-generating-documentation-for-powershell-cmdlets/

Web-Based Tracks Keeps Your GTD System in Order
 * http://lifehacker.com/5217246/web-based-tracks-keeps-your-gtd-system-in-order

2016-05-23
Database Hardware and Infrastructure Trends - SQLPerformance.com
 * http://sqlperformance.com/2016/04/system-configuration/database-hardware-infrastructure-trends

SQL Server Diagnostic Information Queries
 * http://www.sqlskills.com/blogs/glenn/sql-server-diagnostic-information-queries-for-may-2016/

Automatically Creating UML Database Diagrams for SQL Server
 * https://www.simple-talk.com/sql/sql-tools/automatically-creating-uml-database-diagrams-for-sql-server/

Edward Tufte forum: Sparkline theory and practice Edward Tufte
 * http://www.edwardtufte.com/bboard/q-and-a-fetch-msg?msg_id=0001OR

Previous Topics
Today's Topic - Earlier