Everyone is cutting costs and keeping a close eye on spending, but for far too many organizations cutting costs also means cutting projects that could help the business grow.
Other News
Memory Diagnostics – PGA Part 1
(Miladin Modrakovic) Second and very short post related to Oracle memory structures. This time I will focus on PGA.
Input Validation in ASP.NET MVC
(Dino Esposito) In Data Entry and ASP.NET MVC I discussed how to arrange a data entry page using the ASP.NET MVC Framework. There’s a common sentiment around the community that the ASP.NET MVC Framework is not particularly suited to data entry. I was one of those sustaining this point of view. Well,
SQL Expressions, Conditions, and Operators
(Arie D. Jones, Ron Plew and Ryan Stephens) This lesson introduces SELECT and FROM and expands the basic query with some new terms, a new clause, and a group of handy items called operators.
Using jQuery with ASP.NET Part 2: Making an AJAX Callback to ASP.NET
(Rick Strahl) This time around I’ll expand on these concepts and show you how you can use jQuery in combination with ASP.NET as an AJAX backend to retrieve data. I’ll also discuss how you can create ASP.NET controls and otherwise interact with jQuery content from ASP.NET pages in Web Forms.
Logging connection strings
(Darren Green) If you some of the dynamic features of SSIS such as package configurations or property expressions then sometimes trying to work out were your connections are pointing can be a bit confusing. You will work out in the end but it can be useful to explicitly log this information so that
Planner Statistics
(Leo Hsu and Regina Obe) You’ll often hear the term planner statistics thrown around by database geeks. Did you update your statistics. This lingo isn’t even limited to PostgreSQL, but is part and parcel to how most decent databases work. For example in PostgreSQL you do a vacuum analyze to update y
Execute same SQL Server query across multiple servers at the same time using Central Management Servers
(Kun Lee) Managing multiple SQL Servers has its challenges. One of the big challenges is having to collect data from each of the servers you manage and figure out which servers need attention. You can setup a process to connect to each server and collect the data or you can use a third party tool,
Building a SQL Server Cluster for Testing – Part2
(Jonathan Kehayias) Its been a few days since the first post in this series, and I have learned a lot about clustering in Windows Server 2008 with SQL Server 2008. The first thing I learned over the last few days is that there are some significant changes in Windows 2008 Clustering that affect how
Comparing IBM DB2 and IBM solidDB SQL procedures, Part 2: Compare conditional statements, looping statements, error handling, and returning results sets in SQL procedures
(Nora Sokolof) Have you ever wondered how IBM DB2 and IBM solidDB procedures differ? This article series of comparisons spells out the differences very clearly. In this Part 2, learn the differences between conditional statements, looping statements, error handling, returning results sets, and misce