vertonghenb/DBII-Workshops

Issues

• Find a replacement for Diagrams SSMS

  #25 opened 4 years ago by vertonghenb
  0

• Replace LTRIM(STR(x)) with FORMATMESSAGE()

  #12 opened 4 years ago by vertonghenb
  0

• Introduce Chapter about Unit Testing with SSDT

  #7 opened 4 years ago by vertonghenb
  0

• Explain difference between Functions and Stored Procedures

  #8 opened 4 years ago by vertonghenb
  0

• [GENERAL] Topic about Naming Conventions

  #16 opened 4 years ago by vertonghenb
  0

• Depends on Graph example

  #33 opened 5 years ago by vertonghenb
  0

• [PERFORMANCE] Improvements

  #15 opened 5 years ago by vertonghenb
  0

• triggers-3.sql REMARK

  #29 opened 5 years ago by BertHG
  1

• [GENERAL] Topic NVARCHAR vs VARCHAR

  #17 opened 5 years ago by vertonghenb
  0

• Introduce Dynamic SQL Exercise

  #2 opened 5 years ago by vertonghenb
  0

• perf. sol 2

  #20 opened 5 years ago by vertonghenb
  0

• Repeatable Read - Select(count(*))

  #24 opened 5 years ago by BertHG
  1

• Wrong year used in solution performace-2

  #19 opened 5 years ago by Bobobaal
  0

• Rework Data Formatting (XML and JSON)

  #21 opened 5 years ago by vertonghenb
  0

• Cannot create database diagram (stackoverflow db, 1gig version)

  #18 opened 5 years ago by Bobobaal
  1

• Introduce Performance Exercises

  #10 opened 5 years ago by vertonghenb
  1

• Introduce XML

  #11 opened 5 years ago by vertonghenb
  1

• Replace all RAISERROR with THROW

  #9 opened 5 years ago by vertonghenb
  1

• Rollback execution code

  #5 opened 5 years ago by vertonghenb
  1

• Introduce Exercise 1 of Triggers

  #3 opened 5 years ago by vertonghenb
  1

• Introduce Chapter about Sequences

  #6 opened 5 years ago by vertonghenb
  0