Related resources for TSQL
  • Use Of DISTINCT Keyword In T-SQL (SQL Server)2/5/2019 6:24:45 AM. In this session of SQL Server Training series, we are going to learn how to use Distinct keyword in SQL Server.
  • SQL Server Query Optimization - Day 1 (Basics)1/8/2016 9:32:02 AM. The only secret behind good performing queries is understanding and writing queries according to the SQL Server Query Optimizer. "Day1: Basics" will describe some basics of SQL Server, which are must to know before starting this journey.
  • Populate Excel Files From Data Source7/3/2015 5:53:30 PM. This article shows how to use Visual Basic .NET, together with Excel Interops, to connect to a data source and extract information to be imposed to an existing Excel model. In other words, how is it possible to write a simple Excel reporting software.
  • Retrieve Table List With Number of Rows4/22/2015 3:37:19 PM. This article shows a quick way to list tables with a number of rows in a database.
  • How to Track User That Dropped/Deleted TSQL on SQL Server Objects7/15/2014 11:47:47 PM. In this article I will explain how to track the user that dropped/deleted TSQL on SQL Server Objects.
  • .NET SQL Authorization Manager10/3/2012 10:57:50 AM. .NET Sql Authorization Manager (AzMan x .NET 2.0) allows you to set Item-based permissions for Authorization Manager-enabled Microsoft.NET 2.0 applications. Storage reside on a MS Sql Server DataBase and can be administrated by a managed MMC 3.0 Snap-In.