(Hemant K Chitale) As a followup to my previous post “Running a COUNT(column) versus COUNT(*)”, here’s a demo of :
Other News
Enable Coded Builds with PowerShell and psake
(Ian Davis) In an earlier column I explored the use of codified build scripts using tools like Albacore and Rake. There is a lot of focus and work going into the migration from XML- and GUI-based build systems to coded build scripts using tools like Rake and Albacore, FAKE, and psake. Leveraging exi
SSMS – Performance Tuning using graphical execution plans – Missing indexes hints
(Nakul Vachhrajani) SQL Server Performance tuning is an interesting exercise, and I for one, can enjoy tuning performance for hours at an end. I believe that if a system is facing a performance issue, the issue is almost never the SQL Server. The order in which I attack a performance issue is:
Create a custom tab in the SharePoint ribbon interface
(Vijai Anand) In this article we will be seeing how to create a custom tab, group and button to the server ribbon in Sharepoint 2010. Tabs are the root of the Server ribbon and they contain one or more groups. Every tab in the ribbon contains a series of one or more groups.
SQL Server: Manage the Migration
(Welly Lee) The latest iteration of SQL Server, code-named “Denali,” offers many compelling features and will drive many organizations to move to SQL Server. Even with the performance and total-cost-of-ownership (TCO) advantages for moving to SQL Server, though, some organizations may have concerns
SQL Server 2005’s APPLY, Part 2
(Itzik Ben-Gan) Last month I started a two-part series about SQL Server 2005’s APPLY operator. I covered the fundamentals of APPLY, explaining the three modes in which you can use it: CROSS APPLY, OUTER APPLY, and implicit APPLY.
Simple and Secure PHP Login Script
This programming tutorial will teach you how to create a simple, yet secure login script utilizing PHP using MySQL and bracing for XSS attack prevention.
How to log the current call stack in .NET
(Daniele Mazzeranghi) Tracing method calls to a log file is a troubleshooting technique used when a standard debug session is not possible (for example when a given problem can only be reproduced in the production enviroment or in the customer’s computer).
Recommended practices for using Cognos with Informix, Part 2: Deploy Informix with IBM Cognos BI Server 10
(Sreeni Paidi and Jeffrey Williamson) Connecting your Informix databases to Cognos Business Intelligence software gives you a way to unleash the power of your data with expanded query, reporting, and analysis capabilities.
Is Access Really Dead?
Is Access Really Dead? One reader asked my opinion about Access, and is it dead. So, here is where I stand. Back in the early ‘90s I was actually a Microsoft Certified Developer with my primary tool being Microsoft Access. It really bothered me that developers hated the tool. I thought it was cool. I could do a LOT of […]