If you need to find out if a database is being used (or when it was last updated), a useful script contained within this post, will return the maximum date for each and every date/time field within all tables in the current database
When I searching the internet (in March 2013) I came across a useful list of shortcut keys for use within SQL Server when coding.
I recently copied all my e-mails out of an archive folder, so I could zip them up on my hard drive and then delete them out of my mailbox. To do this I wanted to rename each file with the date the email was sent, using the format YYYY-MM-DD. The Visual Basic for Application script within this post does just that 🙂
Back in January 2013, I had a problem with a computer I had assembled, incorporating an Intel DH77DF motherboard. It turned out it was a BIOS problem and was rectified by updated the BIO using a USB memory stick. This post will help you if you have similar problems.
Comparison between MIcrosoft SQL Server Transact-SQL and MySQL Syntax
This post contains the C# class code, used to get the connection string for Entity Framework
Script to show or hide a text box based on the value of a selected drop-down list
Code used to populate a list of drop-down options for an MVC application
Today I worked out how to transpose SQL dates (copied from SQL Server) in Microsoft Word…..
Hi. The Transact-SQL script below 1 returns the following information: ID – Just an identity column used within the script SchemaName – The name of the schema TableName – Obviously, the name of the table 🙂 ColumnName Type – The data type of the column Length – The maximum number of bytes used by the […]
Over the past month or so, I have been working on upgrading an Endeca system that currently processes about 150,000 records. The current system runs on Endeca MDEX Engine v5.1.3. The latest version at the time of writing this post, is 6.1.4A. I decided to work on a VirtualBox Virtual machine, running Windows Server 2008 R2. […]
I wanted to produce a list of the MAX of date fields (DateTime, SmallDateTime, TimeStamp) for all tables within all databases held in an instance of SQL Server.
The script below was written for SQL Server 2000, but should be easily customisable for SQL Server 2005