(Tony Patton) Encryption support for configuration files was added to the .NET Framework beginning with version 2.0. Last week’s article focused on using ASP.NET command-line tools for encrypting portions of configuration files, while this week’s article covers coding options. The .NET Framework lib
Other News
What Query Plans are in SQL Server’s Memory?
(Bill Graziano) SQL Server memory is primarily used to store data (buffer) and query plans (procedure cache). In this article I’ll show how much memory is allocated to the procedure cache (RAM). I’ll explain how to determine what plans are in the cache and how often they’re used.
Did You Know? Forcing a nonclustered index scan to avoid sorting
(Kalen Delaney) Hopefully, if you know enough about SQL Server to understand most of my posts here, you’re aware of the fact that using a nonclustered index is not always an optimal choice for accessing data, particularly if there are thousands (or more) rows of data you need to retrieve. However,
Manage Visual Studio Auto Connect to Team Foundation Server
(Peter DeBetta) I’ve been on a project where we are using Team Foundation Server (TFS). As you may already be aware, Visual Studio (VS) automatically tries to connect to TFS. When I am onsite, this is great, but when I am offsite and not VPN-ed into the client site, VS takes a long time to time out
Compute the percentage of a total with Oracle’s RATIO_TO_REPORT
(Bob Watkins)
Uploading CSV files into dynamic ADF Faces tables – programmtically creating columns
(Lucas Jellema) In a recent article – ADF Faces File Uploading – It is really that simple! – I described how to set up file uploading with ADF Faces. Using the inputFile component, it is dead easy to develop a JSF page in which the user can upload a file and that then displays some file properties.
MySQL net_write_timeout vs wait_timeout and protocol notes
(Peter Zaitsev) In my previous post I mentioned you might need to increase net_write_timeout to avoid connection being aborted and now I think I should have better explained that.
Producing Parameterized Pages
(Steve Muench) How many times have you clicked a hyperlink in an e-mail or Web page to access information about a specific book or airline reservation? These hyperlinks usually contain one or more parameters that reference the particular item you want to view, and the parameter values are used to re
SQL Server Security Primer Show Live on the Site
This Week’s SQL Server Show, SelectViews, is Live: (74) SelectViews: (Special Edition) – This week we’re going into security and SQL Server. Find out considerations, how-to and how SQL Server does security for your installations. >Watch the Show Here A SQL Server Farm is Tough to Manage… Unless you have the right tool. Multiple servers, no problem. Want to run […]
(74) SelectViews: (Special Edition) – This week we’re going into security and SQL Server.
Video Programming for IT Professionals