This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
SQL SERVER - Generate Live Currency Exchange Rates using dbForge Data Generator for SQL Server

SQL SERVER – Generate Live Currency Exchange Rates using dbForge Data Generator for SQL Server

January 21, 2017
Pinal Dave
SQL Tips and Tricks
Devart

Testing billing features needs realistic data. Here is how to fill your database with live currency exchange rates using dbForge Data Generator for SQL Server.

Read More
SQL SERVER - Beautify SQL Code with dbForge SQL Complete

SQL SERVER – Beautify SQL Code with dbForge SQL Complete

January 20, 2017
Pinal Dave
SQL Tips and Tricks
Devart

Messy SQL code is hard to review, and team code styles differ. Here is how to beautify SQL code with dbForge SQL Complete and set one formatting standard.

Read More
dbForge Studio for SQL Server - Ultimate SQL Server Manager Tool from Devart

dbForge Studio for SQL Server – Ultimate SQL Server Manager Tool from Devart

January 2, 2017
Pinal Dave
SQL Tips and Tricks
Devart, SQL Server Management Studio, SQL Utility

dbForge Studio for SQL Server from Devart is a powerful IDE for managing, configuring and developing SQL Server, with coding help and SQL formatting.

Read More
SQL SERVER - How to Automatically Generate SQL Server Documentation ?

SQL SERVER – How to Automatically Generate SQL Server Documentation ?

December 27, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Documentation, SQL Server

Writing database documentation by hand takes hours and goes stale fast. dbForge Documenter for SQL Server generates it automatically. Here is how it works.

Read More
SQL SERVER - Testing Database Performance with tSQLt and SQLQueryStress

SQL SERVER – Testing Database Performance with tSQLt and SQLQueryStress

December 21, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Performance, SQL Scripts, SQL Server

Database testing is often skipped until there is a problem. Here is my approach to testing database performance with tSQLt and SQLQueryStress.

Read More
Creating and Running an SQL Server Unit Test - Best Ways to Test SQL Queries

Creating and Running an SQL Server Unit Test – Best Ways to Test SQL Queries

October 18, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Devart, SQL Scripts, SQL Server

Testing SQL code matters as much as writing it. I show how to create and run a SQL Server Unit Test with tSQLt, the free open source framework.

Read More
freeicon

SQL SERVER – Summer Sale and Monowheel Raffle

August 23, 2016
Pinal Dave
SQL Tips and Tricks
Devart, SQL Server

Devart’s summer sale brings discounts on its database tools, and every customer gets a chance to win a monowheel at the end of the sale. Here are the details.

Read More
1 2 3 4 5 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com