(Sapna) This article is about creating a derived custom server control in ASP.NET which will count how many times it has been clicked. Derived custom controls are those controls which extend the feature of the control.
Other News
IBM Cognos Proven Practices: IBM Cognos Active Report 10.1.1 Cookbook
(Jeff MacDonald, Daniel Wagemann and Matthew Chmiel) A description of the various features available within IBM Cognos Active Report and how they can be used to create and distribute interactive reporting applications.
Script to move all objects to a new schema for SQL Server
(Brent Shaub) I’m using a hosted database service and figuring out ways to best maintain my development and production environments. The host has a front-end to create databases through a website. After creating a database and completing a working script on Development, running this script on Produc
Optional Parameters
Optional Parameters Unlike many programming languages, SQL does not lend itself to optional parameters, especially when using stored procedures. I’m going to share a SQL tip today regarding different methods to implementing optional parameters. All code is written in TSQL for MS SQL Server, but may be modified to work in other SQL engines. For this demonstration I’m going to […]
Jeopardy on SSWUG.org
Jeopardy on SSWUG.org Today’s Jeopardy question pretty clearly demonstrates why it is difficult to create a Computer that can think like the Human Mind. I was amazed by the number of responses regarding yesterdays SSWUG Jeopardy question…and they were all nearly identical. What is dropping/mixing a stack of unnumbered programming cards? In the 60s programmers didn’t have direct access to […]
CHOOSE Function – SQL Server Denali
(VidhyaSagar) SQL Server Denali comes with one more new logical function which helps to pull data at the specified index from a list of values. CHOOSE() is the function that’s been added. Again this function exists in Access , so if you migrate the db from Access there is no need to rewrite your que
Troubleshooting SQL Server Storage Problems
(Denny Cherry) Question: When people talk about performance tuning, they talk about baselines. What are baselines and why do I need them?
Using the Display Database Command
(Troy Coleman) DISPLAY DATABASE is one of the most useful and versatile commands in the DBA toolbox. It’s used to display information about the status of the database, table space and/or index space. It also displays who is using an object, any locks that are being held, any claimers and any pages
Sample XML document for ProvisioningAgent.provisionFromXmlDocumentAsync()
(Darene Lewis) Below is an example of a provisioning XML document that may be passed to the ProvisioningAgent.provisionFromXmlDocumentAsync method.
Oracle Timestamp Processing – mildly annoying
(Neil Chandler) I was writing a small piece of SQL this morning which I needed to account for daylight savings time correctly. All of my databases run in UTC, so a quick foray into using TIMESTAMP AS TIME ZONE seemed the easiest way to accomplish this.