Today's Topic - Earlier

Back to Today's Topic

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