Modify All Database Data and Logfile Names
This script modifies all dtabase .mdf and .ldf to have a standardized name of DatabaseName_Data and DatabaseName_Log.
2011-08-08 (first published: 2011-07-28)
943 reads
Standardize
Case Cleanup Function
Capitalize the first letter of each new word in the string (clean, efficient, and easy to modify).
2008-08-14
320 reads
RE: Help with query
Hi myoldhouse, for relating you can use 'Outer Join'. But, as Andrew said, what do you want to do? Can you post an example with 'real' data? Cheers, Frank
2003-08-15
RE: Output to file
The download butkton at the bottom of the page. It's an extended proc which you "install" on SQL. The explination he gives makes it easy to use. I have used it and not had any problems. It runs under SQL so no, it is not a virus or anything harmful. If you want to dump […]
2003-05-28
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers