Gabe
  • Member for 10 years, 11 months
  • Last seen this week
Revision Tracking & Source Control for Azure SQL Data Warehouse
0 votes

Microsoft has started work on this and there is a signup page for a preview version. In the meantime you may want to look at DBUp and FiveTran, although I haven't worked with either of these. Update: ...

View answer
How to change "deployment target version" on SSIS 2019?
Accepted answer
7 votes

Be sure to go to the Project properties, not the solution properties. See image below.

View answer
Choosing the right algorithm in HashBytes function
0 votes

I haven't seen this mentioned in the answers but per MSDN: Beginning with SQL Server 2016 (13.x), all algorithms other than SHA2_256, and SHA2_512 are deprecated. Older algorithms (not ...

View answer
SQL Sentry Plan Explorer - Execution Mode in plan diagram?
Accepted answer
2 votes

Plan Explorer 19.0 has this feature, along with sexy new icons. Now there is an overlay for BatchMode operations. See Plan Explorer release notes for more details.

View answer
Where are some useful SQL puzzles to teach SQL in a workplace?
11 votes

One that I've used before is: http://www.sql-tutorial.ru/en Has an interactive book with exercises (and tips) and solutions

View answer