Today's Topic - Earlier

Back to Today's Topic

2016-08-25 Thursday
SQL Server Access Control: The Basics - Simple Talk
 * https://www.simple-talk.com/sql/database-administration/sql-server-access-control-basics/

2016-08-23 Tuesday
What is the impact of setting SET ANSI_WARNINGS OFF?
 * http://www.sqlservercentral.com/articles/SET+Options/144571/

2016-08-19 Friday
Upload files to DropBox from PowerShell - Laurent Kempé
 * http://laurentkempe.com/2016/04/07/Upload-files-to-DropBox-from-PowerShell/

2016-08-18 Thursday
Why Not Just Create Statistics? - Brent Ozar Unlimited® by Brent Ozar Unlimited®
 * https://www.brentozar.com/archive/2016/07/not-just-create-statistics/

PowerShell is open sourced and is available on Linux | Blog | Microsoft Azure
 * https://azure.microsoft.com/en-us/blog/powershell-is-open-sourced-and-is-available-on-linux/

Simple T-SQL Code Comparison With PowerShell
 * Simple T-SQL Code Comparison With PowerShell

2016-08-16 Tuesday
Module 11 - Calendar Visualization - YouTube Published on Aug 8, 2016
 * In this module you will learn how to use the Calendar Visualization Power BI Custom Visual (https://app.powerbi.com/visuals/). The Calendar Visualization is a very unique visual that allows you to show the distribution of values across a calendar.
 * https://www.youtube.com/watch?v=3dP5mCjmAAs&feature=youtu.be

2016-08-08 Wednesday
SQL Saturday Distances, A Closer Look | 36 Chambers - The Legendary Journeys: Execution to the max!
 * https://36chambers.wordpress.com/2016/07/29/sql-saturday-distances-a-closer-look/

SQL Awesomesauce Feasel’s Grand Analysis of the PASS 600 mile radius rule
 * http://www.sqlservercentral.com/blogs/sql_awesomesauce/2016/08/01/feasels-grand-analysis-of-the-pass-600-mile-radius-rule/
 * http://www.midnightdba.com/Jen/2016/08/feasels-grand-analysis-of-the-pass-600-mile-radius-rule/#respond

2016-08-08 Monday
What is the Lambda Architecture? - SQLServerCentral
 * http://www.sqlservercentral.com/blogs/jamesserra/2016/08/05/what-is-the-lambda-architecture/

Modifying Tables Online - Part 1: Migration Strategy | Michael J. Swart
 * http://michaeljswart.com/2012/04/modifying-tables-online-part-1-migration-strategy/

2016-08-01 Monday
Analyzing Data in Real Time - Page 2
 * http://www.sqlservercentral.com/Forums/Topic1803735-263-2.aspx?Update=1

IDERA Community
 * http://community.idera.com/

Unit Testing discussion:
 * http://www.sqlservercentral.com/Forums/Topic1804099-263-4.aspx

Quick Scalar Tables–#SQLNewBlogger | Voice of the DBA
 * https://voiceofthedba.wordpress.com/2016/07/28/quick-scalar-tables-sqlnewblogger/

Slimmer SQL Saturdays | Voice of the DBA
 * https://voiceofthedba.wordpress.com/2016/07/26/slimmer-sql-saturdays/#comments

2016-07-07 (Thursday)
Using sp_executesql
 * https://voiceofthedba.wordpress.com/2016/07/07/using-sp_executesql-parameters-sqlnewblogger/

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

2016-05-20
Natively Compiled Stored Procedures: What they are all about - SQLServerCentral There are a lot of limitations
 * http://www.sqlservercentral.com/articles/SQL+Server+2014/111460/

2016-05-18
SQL Server 2012 Build List - SQLServerCentral
 * http://www.sqlservercentral.com/articles/SQL+Server+2012/87518/

2016-05-16
Links regarding table compares:
 * https://www.toadworld.com/platforms/sql-server/b/weblog/archive/2013/12/05/how-to-get-the-tablediff-utility
 * http://www.sqlservercentral.com/blogs/sqlstudies/2016/05/12/comparing-the-contents-of-two-tables/
 * https://sqlstudies.com/2016/05/12/comparing-the-contents-of-two-tables/#comments

2016-05-13
Dateadd query plan issue
 * http://sqlperformance.com/2016/04/sql-performance/surprises-dateadd

2016-05-12
Steve's recovery tools:
 * https://voiceofthedba.wordpress.com/2016/05/12/back-home-despite-a-scare/#comments


 * Dropbox
 * One Drive
 * Google Drive
 * VMs
 * Crashplan
 * Evernote

2016-05-11
SQL Server Central: Stairway to Server Management Objects (SMO) – a SQL Server tutorial
 * http://www.sqlservercentral.com/stairway/140967/

Stairway to Server Management Objects (SMO) Level 1: Concepts and Basics
 * http://www.sqlservercentral.com/articles/SMO/140966/

SQL Server Central: Stairway to SQL PowerShell – a SQL Server tutorial
 * http://www.sqlservercentral.com/stairway/91327/

2016-05-10
How to look up metadata on different DBMS

2016-05-06
Indexing, unique versus non-unique
 * http://www.sqlservercentral.com/articles/Indexing/110064/

2016-05-04
I asked:
 * http://www.sqlservercentral.com/Forums/FindPost1783235.aspx

Execute Dynamic SQL:
 * https://www.mssqltips.com/sqlservertip/1160/execute-dynamic-sql-commands-in-sql-server/

Forcing SQL Agent Jobs to Fail When Remote Procedures Timeout
 * http://www.sqlservercentral.com/articles/SQL+Agent/140491/

Paul Ford: What is Code? | Bloomberg http://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/

2016-04-25
sp_Blitz® – Free SQL Server Health Check Script Questions About PowerShell Basics That You Were Too Shy To Ask
 * https://www.brentozar.com/blitz/
 * https://www.simple-talk.com/sysadmin/powershell/questions-about-powershell-basics-that-you-were-too-shy-to-ask

2016-04-19
Stairway to T-SQL: Beyond The Basics Level 6: Using the CASE Expression and IIF Function
 * http://www.sqlservercentral.com/articles/Stairway+Series/108723/

2016-04-19
I asked on SQL Server Central (4/19/2016)
 * Has anyone set up 2 virtual machines on their desktop, one for browsing and email and one for everything else?

I use an Ubuntu VM for general browsing. With no shared folders
 * Someone answered:

Is there a good guide to getting started somewhere?
 * I asked:

Simple:


 * 1) install Virtual Box, Virtual Box can read Hyper-V, VMware and its own Virtual Box images. For non-production use, it a great way to get started with VM's
 * 2) download a pre-built Ubuntu image
 * https://virtualboxes.org/images/ubuntu/

If your VM engine is Virtual Box, make it easy, and choose the most current that has Guest Additions installed. Looks like that would be v. 13.04

Refer to this discussion:
 * http://www.sqlservercentral.com/Forums/Topic1778921-263-4.aspx#bm1779189

2016-04-18
Unattended Installation Powershell and SQL Server Chrissy LeMaire @cl Cajun living in Belgium. PowerShell MVP. Mostly tweet about PowerShell, SQL Server, Belgian beer, Linux, and Infosec. PASS PowerShell Virtual Chapter Co-Lead. Brussels, Belgium blog.netnerds.net Joined March 2007
 * http://www.sqlservercentral.com/articles/Installation/138000/
 * http://www.sqlservercentral.com/articles/powershell/140440/
 * https://twitter.com/CL/

2016-04-11
Changing the sa Password with SSMS–#SQLNewBlogger – Voice of the DBA
 * https://voiceofthedba.wordpress.com/2016/04/11/changing-the-sa-password-with-ssmssqlnewblogger/

The PoSh DBA: Assigning Data to Variables Via PowerShell Common Parameters
 * https://www.simple-talk.com/sql/database-administration/the-posh-dba-assigning-data-to-variables-via-powershell-common-parameters/

2016-04-08

 * Making a SQL Study plan (how long does it take to learn something in SQL)

2016-04-07

 * How to set up Filezilla