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 […]

Featured Article(s) Book Review: Practical SQL Handbook: Using SQL Variants A review of the book – it’s targeted at the beginner DBA, and part of a series of titles for this market. Best Practices for Business Intelligence "Complexity Curve" Peter wrote in with thoughts from his perspective – and specifically asking (paraphrasing) what the benefit is for third-party tools if […]

Featured Article(s) Tips for using SQL Server 2005 Query Hints (Part 2) Here are some helpful tips to optimize your SQL Server 2005 queries by using hints. Business Intelligence – Moving from Office to More Customized Solutions Some solid feedback from a number of readers about how you approach BI solutions. Essentially, the question was about when you move from […]

Featured Article(s) BCP Basics – an Introduction This article will cover the basics of BCP – get the basics and how you can apply them to your work. How Do You Do BI with SQL Server? Things are shifting with Microsoft’s direction with Business Intelligence-type support for SQL Server. Not going away, just shifting and focusing (changes with performance point). […]