The Curious Engineer

All blogs / Databases

SQL Canada (@SQLCAN)

learn.microsoft.com/en-us/archive/blogs/sqlcan

Use to be originall called SQL Learnings, but on recommendation from a friend. Going to start using SQLCAN, lets see what I can do with this. Purpose of the blog is to put lessons learned from my experinces in PFE.

DatabasesPerformance / optimizationMicrosoft blogsMSDN archive

’15’20’25
Posts
12 from 7 Nov 2011 to 21 Jun 2016
Posting
archived, read-only
Kind
personal blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/sqlcan/feed.xml

2016 4

  1. Help! I have -2, -3, or -4 Session ID!
  2. Dissecting SQL Server Execution Plans
  3. How to get orphaned logins for all databases?
  4. Changing @@SERVERNAME causes SQL Server Backups to Fail for AlwaysOn Availability Group

2015 5

  1. sys.foreign_keys does not have matching row in sys.indexes
  2. Index Creation Date
  3. SQL Server 2012 NUMA Node Imbalance–Conclusion
  4. SQL Server 2012 NUMA Node Imbalance – Cont’d
  5. SQL Server 2012 NUMA Node Imbalance

2014 1

  1. Service Principal Names for SQL Server

2012 1

  1. A Microsoft SQL Server DMV/DMF Cheat-Sheet

2011 1

  1. Adventures in Installing the SQL Server AdventureWorks Sample Database