Ресурсы по Microsoft SQL Server

BIML Resources and Bloggers

BIML - Business Intelligence Markup Language

BIML Resources

BIML Bloggers

PowerShell and SQL Server

TSQL Format Code

  • http://sqlinform.com/
  • http://www.dpriver.com/pp/sqlformat.htm
  • http://stackoverflow.com/questions/401928/sql-formatter-for-sql-management-studio
  • http://www.apexsql.com/sql_tools_refactor.aspx
  • http://poorsql.com/
  • http://www.architectshack.com/PoorMansTSqlFormatter.ashx
  • http://www.ssmstoolspack.com/
  • http://www.devart.com/dbforge/sql/sqlcomplete/
  • http://www.sql-format.com/

SQL Server Test Data Generation

  • https://www.simple-talk.com/sql/t-sql-programming/generating-test-data-in-tsql/
  • http://www.convertcsv.com/generate-test-data.htm
  • https://github.com/benkeen/generatedata
  • https://sourceforge.net/projects/dbmonster/
  • https://sourceforge.net/projects/spawner/
  • Tools for Generating Mock Data?
  • https://mockaroo.com
  • https://anonymize.strd.co/

Free SQL Server and R ebooks

SQL Server:

R: