Related resources for TSQL
  • 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.
Beginning C# 2005 Databases: From Novice to Professional
Beginning C# 2005 Databases: From Novice to Professional teaches you everything you n...