Three quick ways to comment T-SQL code and uncomment it in SSMS, starting with keyboard shortcuts. A SQL in Sixty Seconds video that saves time while debugging.
SQL SERVER – Importing CSV File Into Database – SQL in Sixty Seconds #018 – Video
What is the quickest way of importing CSV file data into a SQL Server table? This SQL in Sixty Seconds video shows it: create a table, BULK INSERT, verify.
SQL SERVER – Tricks to Replace SELECT * with Column Names – SQL in Sixty Seconds #017 – Video
SELECT * pulls extra columns, hurts plans and makes debugging hard. This sixty second video shows two tricks to replace SELECT * with column names.
SQL SERVER – Standard Reports from SQL Server Management Studio – SQL in Sixty Seconds #016 – Video
SSMS comes with many built-in performance and activity reports. This sixty second video shows where to find the Standard Reports and how to run them.
SQL SERVER – Quiz and Video – Introduction to Hierarchical Query using a Recursive CTE
Learn to write a hierarchical query using a recursive CTE with a short video and a quiz on an employee and manager table. Check your answer.
SQL SERVER – Installing AdventureWorks Sample Database – SQL in Sixty Seconds #010 – Video
Need sample data to try new SQL Server features safely? This SQL in Sixty Seconds video shows how to install the AdventureWorks sample database.
SQL SERVER – T-SQL Constructs – *= and += – SQL in Sixty Seconds #009 – Video
Vinod Kumar is back with T-SQL constructs in SQL in Sixty Seconds #009, showing how .NET developers can use familiar syntax like *= and += in T-SQL.