Today's Topic 2016

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-22 Friday
RFC 3339 - Date and Time on the Internet: Timestamps
 * https://tools.ietf.org/html/rfc3339

2016-07-21 Thursday
SQL Server differences of char, nchar, varchar and nvarchar data types
 * https://www.mssqltips.com/sqlservertip/4322/sql-server-differences-of-char-nchar-varchar-and-nvarchar-data-types/

2016-07-20 Wednesday
Speakers: O'Reilly Artificial Intelligence Conference, September 26 - 27, 2016, New York
 * http://conferences.oreilly.com/artificial-intelligence/ai-deep-learning-bots-ny/public/schedule/speakers

List all permission in all databases
 * http://www.sqlservercentral.com/Forums/Topic676084-1502-1.aspx

2016-07-18 Monday
The Remote DBA - SQLServerCentral
 * http://www.sqlservercentral.com/articles/Editorial/143648/

"JustMarie (7/18/2016)

However my boss's boss has a thing about 'butts in seats' and likes to see his people busily typing away and talking on phones.

This kind of attitude drives me insane, but (I think) it also points to insecure management. They don't trust their workforce, or they don't feel empowered to manage any issues that might arise from their employees working from home, so they just dictate that everybody must be visible at all times instead. A good manager should judge their employee on the quality of their work, not the vague observation that they're always at their desk. It's insane.

Preaching to the choir here. That attitude is about 15 years out of date. And it's going to cost them future talent when they're told that they have to be in the office 100% of the time. The underlying assumption you point out - that they can't trust their employees to work if they're not in the office - comes out very clear when telecommuting is taken off the table for no reason."

Shining Light on Non-Public Data Flows | ICSI
 * https://www.icsi.berkeley.edu/icsi/projects/networking/non-public-data-flows

2016-07-14-Thursday
Using the new SQLServer Powershell module to get SQL Agent Job Information - SQLServerCentral
 * http://www.sqlservercentral.com/blogs/sql-dba-with-a-beard/2016/07/03/using-the-new-sqlserver-powershell-module-to-get-sql-agent-job-information/

2016-07-12-Tuesday
The COUNT Function in T-SQL - SQLServerCentral
 * http://www.sqlservercentral.com/articles/T-SQL/142568/

2016-07-07 (Friday)
5 Monitoring Queries for SQL Server
 * https://www.simple-talk.com/content/article.aspx?article=2424

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