A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way? But ...
I recently wrote a .NET web application for work. I always make a data access class with methods for getting data, but I usually just point the methods to stored procedures. This time, I decided to ...
Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works. Database ...
I need to get a list of users inside a given group/folder/ou whatever in Active Directory.<BR><BR>I want to take this list and dump it into a table on MS SQL Server 2005.<BR><BR>I was wondering if ...