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 – SQL in Sixty Seconds – 5 Videos from Joes 2 Pros Series – SQL Exam Prep Series 70-433
Rick Morelan’s Joes 2 Pros books go from opening SSMS to core architecture. Here are five SQL in Sixty Seconds videos from this SQL Exam Prep Series 70-433.
SQL SERVER – Introduction to Discovering XML Data Type Methods – A Primer
The XML data type has five methods in SQL Server 2008. This primer from Joes 2 Pros Volume 5 introduces the XML data type methods, starting with query().
SQL SERVER – Introduction to SQL Error Actions – A Primer
Many think an error of severity 11 or higher stops the rest of the batch. This primer on SQL error actions shows it is true only most of the time.