Today's Topic

What did you learn or study today?

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

Previous Topics
Today's Topic - Earlier