Featured Article(s) Creating Dynamic Where Clauses in SQL One very common scenario in when working with User Interface database queries is the concept of a "Dynamic Search Query". A select statement that can have optional items in the where clause. There are a number of methods to implement this, however, they have varying levels of difficulty and, overall each have […]

Biggest Discount Early Bird Registration Ends Feb 15 ’09 …for the April vConference – you can save huge on early bird registration now – while the rates are at their absolute lowest. You can’t lose – $80 for a conference? Seriously? Yes. – SQL Server – Business Intelligence – SharePoint – .NET Developers [Get registered here] Upgrading DTS to SSIS? […]

Featured Article(s) Doing More with Less Money on Your Servers In the past I have worked at corporations where we had a limited budget and we were always expected to do more with what we had. I always loved the way that the budget was done based on what we spent and performed at the previous year and yet, when […]

Featured Article(s) MySQL Basic SQL Part II The Simple SELECT SQL is one of those lost arts. We often just throw something together without considering the ramifications to our applications and the database engine that must crunch through the tables to get at the information we require. Bear with me. This series will introduce more difficult SQL as time goes […]

Featured Article(s) Find all Un-Restricted/Restricted Sized db files on SQL Server The following stored procedure finds all files on the server (with difference between log and data files ) that have / do not have a MAX SIZE limit These file can auto-Grow to consume all space on the drive. The procedure can report data files or log files. SelectViews […]

Featured Article(s) Introducing the ADO.NET Entity Framework This article takes a look at the ADO.NET Entity Framework, its features and benefits. It also discusses why it promises to be the technology of choice for the next generation of data access using ADO.NET. The primary objective of the ADO.NET Entity Framework is to objectify your applications data – add a level […]

Featured Article(s) Tips for using SQL Server 2005 Join Hints In this article, you can find some helpful tips to use SQL Server 2005 join hints. Best Practices – How to Establish Them, Where to Find Them Kathy wrote in with some lessons-learned that have become best practices – and there is a key item in the things she’s applying […]

Featured Article(s) What Can Cause Performance Problems On occasion I come across a question that really perks my interest. When I came across the question regarding performance problems, it brought a number of past experiences to mind that I could use for different examples. I answered the question, but the more that I thought about it the more I thought […]

Featured Article(s) MySQL Basic SQL Part I It has been my opinion that many of us in the database world rely too heavily on canned applications or insignificant knowledge to write our SQL statements for us. So, Im going to take some time (articles) to walk through some of the more basic but often lost skills of writing SQL. Venture […]

Featured Article(s) Stored Procedure to get all db files list on the server along with DATA + LOG sizes The following stored procedure does not accept any parameters. It scans all databases on a server and lists all file names with paths along with size in MB and file types (Data/Log) IT then sums data file sizes. and log file […]