.Net, Ajax, ASP.NET, C#, HTML, JavaScript, JQuery, Programming, Software, SQL Server 2008, SQL Server 2012, Various Languages, VB.NET, Visual Studio 2013

Three Free Online Code Sandbox and Collaboration Tools for SQL, .NET, JavaScript

Being able to write and test code snippets in your Web browser in collaboration with others anywhere in the world is an empowering experience. This is especially true when the tool is free for anyone to use. I can see no better way for developers to learn new languages or code better applications when the old-school barriers of software and hardware are removed.

In the realms of coding for JavaScript, SQL, and .NET, I am aware of three very useful environments that I would suggest: JSFiddle, SQL Fiddle, and .NET Fiddle. In the article below I will briefly describe the capabilities of each tool and how they will give your programming efforts an edge. Continue reading “Three Free Online Code Sandbox and Collaboration Tools for SQL, .NET, JavaScript”

Database, Programming, SQL, SQL Server 2005, SQL Server 2008, SQL Tips, System Objects, Transact-SQL, tSQL

T-SQL Find Highly Populated Tables in a Database

When you are working with an unfamiliar database, such as a third-party SQL Server database, you want to find out which tables actually store the important data. If there is no clean database diagram, then the best option is to write a T-SQL query in SQL Server Management Studio (SSMS).

If you are interested in this topic, then I’d suggest also reading my article on batch searching your SQL Server database to find out in which tables the information is being stored.

Continue reading “T-SQL Find Highly Populated Tables in a Database”