SQLServer
Implementing Waiting Pages in ASP.NET
The users of your application will be more likely to tolerate pauses in your application whilst processing goes on, if you provide a 'waiting' page.
 
Smoke and Mirrors
It seems hard to imagine that a presentation about a new IT application to the directors can go too well. Phil doesn't need to imagine- it happened to him. He winces at the memory.
 
Using BCP to export the contents of MAX datatypes to a file
Phil Factor presents a poetic stored procedure for storing any VARCHAR(MAX) to file.
 
Beware ye of ancient columns
I'm sure you all make changes to your schema over time adding columns to tables and occassionally dropping them. But were you aware that even though you drop a column from a table the space in the...
 
Temporarily Changing an Unknown Password of the sa Account
You are asked for the sa password for a SQL Server in order to perform a software upgrade. You, the DBA, don't know the password and it's not documented. Rodney Landrum provides a way out of this...
 
RSS Newsfeed Workbench
Robyn and Phil decide to build an RSS newsfeed in TSQL, using the power of SQL Server's XML.
 
SQL Server Endpoints: Soup to Nuts
SQL Server Endpoints are database objects that define the ways and means that SQL Server 2005 communicates on the network. Any DBA working with SQL Server 2005 will soon need to become familiar with...
 
Love amongst the computers
I love to go around junk shops and second hand bookshops looking for quirky second-hand books. It was whilst browsing through all the more dog-eared fiction (always a sign that the contents are...
 
XML Jumpstart Workbench
In which Robyn and Phil decide that the best way of starting to learn XML is to jump in and take a ride around the block.
 
Foreign Keys and their States
András Belokosztolszki, Red Gate developer, shows how foreign key constraints can be disabled and re-enabled in order to simplify operations such as the bulk loading of data into related tables.
 
Pop Rivett and the Expanding Log
Pop Rivett comes to the rescue when an expanding log file threatens the very existence of a young man's website...
 
<< Start < Prev 1 2 Next > End >>

Results 22 - 36 of 36