Today's Topic - Earlier

Back to Today's Topic

December 2016

Title	URL	Date and day of the week
Extended Events for Tracking Backup and Restore Progress	sqlservercentral.com	2016-12-28 Wednesday
Office Hours Podcast - Brent Ozar Unlimited®	brentozar.com	2016-12-27 Tuesday
SQL Server 2014 Licensing Changes	brentozar.com	2016-12-27 Tuesday
Multi-Step Input Forms in ASP.NET MVC	simple-talk.com	2016-12-09 Friday
Validating a Set of Database Scripts using DLM Automation	voiceofthedba.wordpress.com	2016-12-09 Friday
Some Tips for Minimising the Pain of HTML Input Forms	simple-talk.com	2016-12-09 Friday
The Seven Sins against TSQL Performance	simple-talk.com	2016-12-08 Thursday (published in 2012)
Truncate tables with foreign keys	sqlservercentral.com	2016-12-02 Friday

November 2016

Title	URL	Date and day of the week
SQL Server on Linux: Boring - Home Of The Scary DBA	scarydba.com	2016-11-28 Monday
Wildcard Searches	sqlservercentral.com	2016-11-21 Monday
When was my index created or at least last updated?	sqlstudies.com	2016-11-21 Monday
Implementing a Custom Sort	sqlperformance.com	2016-11-21 Monday
Is JavaScript Single-Threaded?	simpletalk.com	2016-11-04 Friday
Set Statistics… Profile?	brentozar.com	2016-11-03 Thursday
Script All Logins / Users / and Roles	sqlservercentral.com	2016-11-02 Tuesday
List and Execute SQL Server Stored Procedures with PowerShell	mssqltips.com	2016-11-02 Tuesday
Analysis Services Lives On	sqlservercentral.com	2016-11-01 Tuesday

October 2016

Title	URL	Date and day of the week
8 Ways to Export SQL Results To a Text File	sqlservercentral.com	2016-10-26 Wednesday
dbatools - best practices and instance migration module	dbatools.io	2016-10-25 Tuesday
Store a file and Retrieve it in SQL Server	sqlservercentral.com	2016-10-21 Friday
MariaDB vs. Microsoft SQL Server Comparison	db-engines.com	2016-10-21 Friday
Where Do You Run Your R Scripts?	sqlservercentral.com	2016-10-20 Thursday
SQLCMD to export data in txt file	sqlservercentral.com	2016-10-13 Thursday
Bones of SQL - Practical Calendar Queries	sqlservercentral.com	2016-10-13 Thursday
Search for SQL Saturday sessions by specified key phrase - Wayne Sheffield	blog.waynesheffield.com	2016-10-11 Tuesday
The Free-Con Returns to Seattle | Voice of the DBA	voiceofthedba.wordpress.com	2016-10-11 Tuesday
Error Logging Gone Wild - SQLServerCentral	sqlservercentral.com	2016-10-11 Tuesday
Who the Devil Wrote This SQL Code? - Simple Talk	simple-talk.com	2016-10-10 Monday
Introducing the Set-based Loop - SQLServerCentral	sqlservercentral.com	2016-10-07 Friday

September 2016

Title	URL	Date and day of the week
SQL Server for Linux - Simple Talk	simple-talk.com	2016-09-30 Friday
PSYaml: PowerShell does YAML - Simple Talk	simple-talk.com	2016-09-26 Monday
Stairway to Advanced T-SQL Level 5: Turning Data On Its Side Using PIVOT Operator - SQLServerCentral	sqlservercentral.com	2016-09-23 Friday
Monitor up-time and connectivity with Powershell - SQLServerCentral	sqlservercentral.com	2016-09-22 Thursday
Reading the SQL Server log files using TSQL	mssqltips.com	2016-09-20 Tuesday
Foreign Keys in SQL Server (video) - Brent Ozar Unlimited®	brentozar.com	2016-09-16 Friday
Stairway to U-SQL Level 8: Joining Tables in U-SQL	sqlservercentral.com	2016-09-15 Thursday
The Bones of SQL - The Calendar Table - SQLServerCentral	sqlservercentral.com	2016-09-08 Thursday
Stairway to Exploring Database Metadata Level 2: Using the Dynamic Online Catalog to Solve Problems - SQLServerCentral	sqlservercentral.com	2016-09-07 Wednesday
Copying an on-premise Database to an Azure SQL Database	sqlservercentral.com	2016-09-06 Monday
The Copy Cat Poll (backup strategies)	sqlservercentral.com	2016-09-02 Friday
The Joys Of Migrating From SQL Server To MariaDB : Coding Ninja	codingninja.co.uk	2016-09-01 Wednesday
New Drop If Exists Syntax in SQL Server 2016	mssqltips.com	2016-09-01 Wednesday

August 2016

Title	URL	Date and Day of the Week
5 Monitoring Queries for SQL Server	simple-talk.com	2016-08-30 Tuesday
Curious..about data (about page)	curiousaboutdata.com	2016-08-30 Tuesday
Formatting SQL Code – Part the Second	simple-talk.com	2016-08-30 Tuesday
Query Performance Tuning – A Methodical Approach - SQLServerCentral	sqlservercentral.com	2016-08-26 Friday
Install ReadyRoll via Command Line	sheldonhull.com	2016-08-26 Friday
SQL Server Access Control: The Basics - Simple Talk	simple-talk.com	2016-08-25 Thursday
What is the impact of setting SET ANSI_WARNINGS OFF?	sqlservercentral.com	2016-08-23 Tuesday
Upload files to DropBox from PowerShell - Laurent Kempé	laurentkempe.com	2016-08-19 Friday
Why Not Just Create Statistics? - Brent Ozar Unlimited® by Brent Ozar Unlimited®	brentozar.com	2016-08-18 Thursday
PowerShell is open sourced and is available on Linux | Blog | Microsoft Azure	azure.microsoft.com	2016-08-18 Thursday
Simple T-SQL Code Comparison With PowerShell	mssqltips.com	2016-08-16 Tuesday
Module 11 - Calendar Visualization - YouTube	youtube.com	2016-08-16 Tuesday
SQL Saturday Distances, A Closer Look | 36 Chambers - The Legendary Journeys: Execution to the max!	36chambers.wordpress.com	2016-08-10 Wednesday
SQL Awesomesauce - Feasel’s Grand Analysis of the PASS 600 mile radius rule	sqlservercentral.com	2016-08-10 Wednesday
Feasel’s Grand Analysis of the PASS 600 mile radius rule | The MidnightDBA Star-Times	midnightdba.com	2016-08-10 Wednesday
What is the Lambda Architecture? - SQLServerCentral	sqlservercentral.com	2016-08-08 Monday
Modifying Tables Online - Part 1: Migration Strategy | Michael J. Swart	michaeljswart.com	2016-08-08 Monday
Analyzing Data in Real Time - Page 2	sqlservercentral.com	2016-08-01 Monday
IDERA Community	community.idera.com	2016-08-01 Monday
Unit Testing discussion:	sqlservercentral.com	2016-08-01 Monday
Quick Scalar Tables–#SQLNewBlogger | Voice of the DBA	voiceofthedba.wordpress.com	2016-08-01 Monday
Slimmer SQL Saturdays | Voice of the DBA	voiceofthedba.wordpress.com	2016-08-01 Monday

July 2016

Title	URL	Date
RFC 3339 - Date and Time on the Internet: Timestamps	tools.ietf.org	2016-07-22 Friday
SQL Server differences of char, nchar, varchar and nvarchar data types	mssqltips.com	2016-07-21 Thursday
Speakers: O'Reilly Artificial Intelligence Conference, September 26 - 27, 2016, New York	conferences.oreilly.com	2016-07-20 Wednesday
List all permission in all databases	sqlservercentral.com	2016-07-20 Wednesday
The Remote DBA - SQLServerCentral	sqlservercentral.com	2016-07-18 Monday
Shining Light on Non-Public Data Flows | ICSI	www.icsi.berkeley.edu	2016-07-18 Monday
Using the new SQLServer Powershell module to get SQL Agent Job Information - SQLServerCentral	sqlservercentral.com	2016-07-14 Thursday
The COUNT Function in T-SQL - SQLServerCentral	sqlservercentral.com	2016-07-12 Tuesday
5 Monitoring Queries for SQL Server	simple-talk.com	2016-07-07 Thursday
Using sp_executesql	voiceofthedba.wordpress.com	2016-07-07 Thursday
How To Survive A Database Disaster - Thomas LaRock	thomaslarock.com	2016-07-06 Wednesday

Daily Format

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)

• https://en.wikipedia.org/wiki/Business_Intelligence_Markup_Language biml

(from: http://sqldatapartners.com/podcast/ episode 48, with Tim Mitchell)

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

• http://stackoverflow.com/questions/9097067/get-cpu-usage-from-windows-command-prompt

typeperf

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:

• http://www.sqlservercentral.com/Forums/FindPost1792427.aspx

"If you want a significant amount of data to use in test I recommend the stack exchange database as detailed in this blog post:

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

• http://www.sqlservercentral.com/Forums/Topic1255712-263-3.aspx

Interesting comment:

• 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

• http://sqlblog.com/blogs/adam_machanic/

-I sent him a message about wikis

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

• http://www.sqlservercentral.com/articles/SQL+Server+2014/111460/

There are a lot of limitations

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

• https://www.brentozar.com/blitz/

Questions About PowerShell Basics That You Were Too Shy To Ask

• 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?

• Someone answered:

I use an Ubuntu VM for general browsing. With no shared folders

• I asked:

Is there a good guide to getting started somewhere?

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

• http://www.sqlservercentral.com/articles/Installation/138000/

Powershell and SQL Server

• http://www.sqlservercentral.com/articles/powershell/140440/

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

• 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