(Scott Guthrie) People often ask me at conferences for PC hardware recommendations. Specifically – “what type of machine do you recommend I get for doing development with Visual Studio?” and/or “your laptop seems really fast, what type is it?”
Other News
Running Windows XP Control Panel Applets from Visual Basic.NET 2005
(Hannes du Preez) I’ve always been intrigued by the Control Panel; what are those items in the Control Panel? Are they programs? What makes them appear? I’m not talking about what the various objects inside the Control Panel do or mean; I’m speaking about what make those objects tick, how can I make
Picture SMS Using the .NET Compact Framework 2.0
(Wei-Meng Lee) Recently, I was consulting on a Windows Mobile project where the client asked if it is possible to send images using SMS messaging. After searching high and low for a solution, I concluded that there is no easy way to do it unless you want to buy some fanciful third-party software. Ba
How To Trim A .NET Application’s Memory Workingset
(Arno) .NET developers who have monitored their application’s memory consumption in Windows Taskmanager or a more sophisticated Process Explorer might have noticed the effect when memory usage slowly rises, and hardly ever drops unless the whole operating systems starts to run low on memory – this i
Creating SQL Server tables: A best practices guide
(Baya Pavliashvili) Always save CREATE TABLE statements, along with all other statements defining database schema in a secure location. Every time you make a change to a database object, be sure to script the change and check it into version-control software, such as Visual Source Safe. (R)
Back to the basics: LEN() vs DATALENGTH()
In our back to basics series, today we will cover the difference between LEN() and DATALENGTH() functions to obtain the length of the column or a variable. LEN returns the number of character in the string or variable. DATALENGTH() returns the number of bytes used to represent any sting or expressio
Information Integration: The Information Server Blade Dream Team
(Vincent McBurney) Welcome to the enterprise data integration pentathlon in which the athletes run a ten-meter dash, install an enterprise ETL (extract, transform, and load) or ELT (extract, load, and transform) tool, configure it, test it, and then process a terabyte of data from multiple sources.
Logon Triggers
(Cristian Lefter) When I asked a friend from the SQL Server development team “what’s the story behind Logon Triggers?” the answer was brief “Common Criteria compliance for SQL Server and nothing more”. That is, indeed, the short story but if you work with SQL Server 2005 and need the long story, rea
I Admit It, I’m a Bit Torn…DevConnections/SQLConnections)… Day 3
Featured Article(s) Easy SQL Server Database Monitoring for the Oracle (and SQL Server) DBA – Part 2 This article is the second in this series. It describes how to develop your own SQL Server polling and monitoring system. This article presents the repository ERD and the polling mechanism allowing you to easily retrieve instance, database, and failed jobs into the […]
DevConnections (and SQLConnections)… Day 2
Featured Article(s) Troubleshooting SQL Server 2005 Merge Replication (Part 1) In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2005 merge replication. He also tells how you can resolve these problems. Don’t Throw Away Your Reporting Services Masterpieces… Once you’re done creating the reports your users need, you know you’re almost […]