Today's Topic

What did you learn or study today?

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/

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/

Previous Topics
Today's Topic - Earlier