Today's Topic - Earlier

Back to Today's Topic

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