Elegant Squiggle Dichroic Fused Glass Pendant II
Monday, February 25, 2008
A squiggle of black glass floats over glittering turquoise dichroic glass. Visit Jellybug Artworks for more pictures and a chance to own this item!
A squiggle of black glass floats over glittering turquoise dichroic glass. 
Orange Swizzle Fused Glass Pendant
Thin flakes of orange and yellow glass -- we call them confetti -- float suspended in the middle of this pendant which is accented with glittering dichroic glass and a playful black stripe. Visit Jellybug Artworks for more pictures and a chance to own this item!
Lime Orange Swizzle Fused Glass Pendant
Mod chunks of glittering dichroic glass with a playful stripe. I'm keeping the prototype, but you can order one! Visit Jellybug Artworks for more pictures and a chance to own this item!
Dichroic Lima Bean Fused Glass Pendant
Dichroic glass inclusions glitter on a background of solid back. Visit Jellybug Artworks for more pictures and a chance to own this item!
Turquoise Twist Necklace
Six strands of turquoise nuggets, accented with pewter and hematite, drape elegantly and then disappear into ornate cones.This necklace is 21 inches long.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Lentil and Pearls Necklace
Lampworked glass lentil beads are the focal point for a twist of tigereye, shell, and freshwater pearls. Visit Jellybug Artworks for more pictures and a chance to own this item!
Irish Eyes Necklace
A braid of green glass and stone bead contrasts with an orange ceramic focal point. I'm keeping this one! Visit Jellybug Artworks for more pictures and a chance to own this item!
Brilliant Sea Shore Necklace
A twisted braid of red coral, tiny white shells, and carnelian chips, accepted with hematite and pewter flower blossoms. A pewter pendant, spiraled like a shell itself. Bright, intense, vibrant. It's definitely you!This necklace is 17 inches long.
Visit Jellybug Artworks for more pictures and a chance to own this item!
The SSIS subsystem failed to load
Saturday, February 23, 2008When you change servers and restore msdb, you may find your maintenance plans failing and putting the following messages into various logs:
- The SSIS subsystem failed to load
- Subsystem could not be loaded
- The job has been suspended
- The specified module could not be found
To verify that this is in fact the problem,
SELECT * FROM msdb.dbo.syssubsystems
If the directory pointed to by the rows doesn't exist, you've found the problem! Two quick queries will fix you right up:
-- Delete the existing rows.And finally, you need to restart SQL Server Agent for it to pick up the new table entries and unsuspend the SSIS jobs.
DELETE FROM msdb.dbo.syssubsystems
-- Fill the table with new rows pointing to the proper location of the DLLs.
EXEC msdb.dbo.sp_verify_subsystems 1
One More Thing
If you've changed servers and have SSIS packages (like maintenance plans), there's another thing you most likely need to do. Each package/plan has at least one database connection, and they're probably pointing to the old server. You need to modify each package/plan individually, changing the existing connection if you can (I couldn't -- all of the input boxes were disabled) or creating a new connection and changing all of the steps to use it. I've never been a user of DTS packages -- too rickety and GUI-driven for me -- but I can see why no one likes the direction Microsoft went with turning maintenance plans into DTS packages in SQL Server 2005.Labels: SQL Server
SQL Agent Doesn't Like Foreign Job History
We migrated our production database cluster from an MSA 1000 to an EVA 8100 with new servers this morning. (This is much easier than in-place upgrades where you take down the system, wipe the cluster nodes and rebuild them on the spot if you can swing it.) It went fairly smoothly, though when I went to compare the amount of time the EVA took to make full backups of all the databases (8 minutes) to the time it took the MSA (21 minutes), I found that even though I'd restored msdb from the previous server, there was no job history. Apparently SQL Agent doesn't take kindly to foreign job history and zorched it as soon as the new server ran its first job. I restored a copy of msdb, shut down SQL Agent and sucked the contents of sysjobhistory back in from the copy, changing the server column to the new server's name (and having to bump up the value of instance_id since the new server's SQL Agent had already made a few records), and the transplant took.
Labels: SQL Server
Gold Art Glass Leaf Necklace
A large art glass leaf in autumnal hues is the focal point. Blue satin cord complements, and golden pearls carry the color.The necklace is 16 inches long.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Craft Fair - Saturday, March 1st
Wednesday, February 20, 2008Elegant Squiggle Dichroic Fused Glass Pendant
A squiggle of black glass floats over turquoise dichro. I like this one so much that I'm keeping it! Visit Jellybug Artworks for more pictures and a chance to own this item!
Purple and Lime Dichroic Glass Pendant
This purple dichroic glass was turquoise before I fired it -- an unexpected but delightful change. Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Orange Millefiori Fused Glass Pendant
A stack of Italian millefiori with a dichroic noodle. I like this one so much that I'm keeping it! Visit Jellybug Artworks for more pictures and a chance to own this item!
Mountain Tree Fused Glass Pendant
A stylized tree sits atop a green mountain. A dichroic sun shines overhead. Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Deep Sea Stripe Fused Glass Pendant
A meandering stripe of yellow glass floats on a sea of dark teal accented with pink dichroic glass. Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Orange and Copper Glass Pendant
A spiral of hammered copper is sealed under a layer of clear glass onto a base of orange and yellow glass. Black dots dance above. Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Splash of Dichro Glass Pendant II
A splash of blue dichroic glass floats on a contrasting base of orange and lime with red accents. Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Splash of Dichro Glass Pendant
A splash of blue dichroic glass in a pool of lime. Bright yellow streamers float above. Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Amethyst Cascade Pendant
A spill of clear crystalline beads cascades from a spiral-capped amethyst pendant. Amethyst is the February birthstone and is associated with nobility and spiritual awareness.The pendant hangs on a 20-inch black satin cord.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Blue Fish and Pearls Pendant
A large blue lampworked glass bead, shaped vaguely like a fish. A cascade of bright orange vintage Lucite flower blossoms, rescued from a Rhode Island factory that closed the 1960s, and gold pearls. It's complementary, it's festive, and it's fabulous. This necklace should be yours!The pendant is 3.5 inches long and hangs on a 15 inch rubber cord.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Copper Bird Fused Glass Pendant
Saturday, February 16, 2008
Copper inclusions on a wavy blue background under a layer of stringer and confetti! Heated to 1500 degrees, then slowly annealed for strength and long life. Visit Jellybug Artworks for more pictures and a chance to own this item!
Lizard of the Veldt Fused Glass Pendant
A copper lizard wriggles on the African plains while a dichroic snake, floating above the clear surface, makes its way down the side. Visit Jellybug Artworks for more pictures and a chance to own this item!
Iridescent Red Fused Glass Pendant
Pink glass swooshes across a backdrop of iridescent red. Inclusions of copper winds in one corner and sprinkle across the landscape. Visit Jellybug Artworks for more pictures and a chance to own this item!
Feathery Ribbons Necklace
Fluffy, feathery ribbons cascade to your waist. A bright pink wooden bead slides to accent wherever you like, and the necklace slips on over your head. Visit Jellybug Artworks for more pictures and a chance to own this item!
Red Coral Pendant
Two red coral donuts are suspended on curls of thick wire from a leather thong.The thong is 22 inches long.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Gemstone Planets Necklace
Milky striped agate orbs, tumbled agate nuggets, and creamy red carnelian are ringed in shiny wood. Orange, black and white contrast well. Let festivity orbit you!This necklace is 19 inches long and fastens with a silver hook.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Two-Tailed Tigereye Pendant
Bright, festive glass beads cascade from a glistening polished tigereye donut. The pendant hangs from a warm brown soft leather thong.The thong is 15 inches long with an 3" extender chain.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Blue Vintage Lucite Leaf Earrings
These vintage blue lucite leaves were rescued from a Rhode Island factory that closed in the 1960s. Paired with an intricate pewter pewter bead, they're quite jazzy and retro chic!These earrings are 2.5 inches long and weigh nearly nothing.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Fun with Necklace Displays
Friday, February 15, 2008
Start off with a double row of tumbled turquoise pebbles and larger turquoise coins, accented with pewter beads and dangling pewter spirals. Add a large capiz shell pendant. Fabulous!This necklace clasps with a large lobster claw and features an extension chain that allows you to adjust its length between 13 and 16 inches simply by varying which link in the chain you hook the lobster claw through.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Stalking tempdb growth
Monday, February 11, 2008I made two small tables and a sproc to fill each and scheduled the sprocs to run every 10 minutes. I found two interesting things.
- Our tempdb data files could be much smaller. They're currently 20 GB, and we have 8 of them, as we're using the T1118 tempdb concurrency enhancement at the direction of Microsoft (it's ostensibly for 2000 only, but we're running 2005 and they have us using it), and they top out at 1.8 GB of data each.
- The tempdb checkpoint interval, which as far as I can tell I have no control over, as it has nothing to do with the server-wide recovery interval, appears to be 2-3 hours during the week and 6-7 hours on the weekend. When I graphed the log usage in Excel, the amount of data in the log very clearly repeatedly grew steadily to a point (13 GB during the week, 19 GB on the weekend), then plummeted to 0, then grew steadily back to that same point.
CREATE TABLE dbo.tempdbDataSize (If you haven't changed your tempdb file names, you can use a CHAR(7) in tempdbDataSize. Since we have 8, I renamed the first one from "tempdev" to "tempdev1" for consistency and numbered them (tempdev1 - tempdev8). We have a busy system, so I'm recording my tempdb log sizes in gigabytes. You may need to use megabytes instead, in which case you'll want to kick those TINYINTs up to SMALLINTs and remove the division by 1024 from the statement (below) which audits the log usage.
time SMALLDATETIME NOT NULL DEFAULT GETDATE(),
filename CHAR(8) NOT NULL,
usedMb SMALLINT
)
CREATE TABLE dbo.tempdbLogSize (
time SMALLDATETIME NOT NULL DEFAULT GETDATE(),
gb TINYINT,
usedGb TINYINT
)
I found the code to get the file usage by turning on SQL Profiler and then opening the Shrink Files pane in SSMS (remember not to click OK in this pane if you try this yourself -- shrinking tempdb while people are using it is Supremely Bad Idea).
The tempdb data size audit sproc:
CREATE PROCEDURE dbo.tempdbDataSize_audit ASThe tempdb log size audit sproc:
SET NOCOUNT ON
CREATE TABLE #tmpspc (
Fileid int,
FileGroup int,
TotalExtents int,
UsedExtents int,
Name sysname,
FileName nchar(520)
)
EXEC('USE tempdb INSERT INTO #tmpspc EXEC (''dbcc showfilestats'')')
INSERT INTO tempdbDataSize (filename, usedMB)
SELECT name, UsedExtents * 64 / 1024
FROM #tmpspc
DROP TABLE #tmpspc
CREATE PROCEDURE dbo.tempdbLogSize_audit ASThe sendEmail sproc is my custom wrapper for sp_send_dbmail -- you can just drop in a sp_send_dbmail call.
SET NOCOUNT ON
DECLARE @sizeGb INT, @usedGb INT
CREATE TABLE #tmplogspc (
databaseName SYSNAME,
logSizeMB FLOAT,
SpaceUsedPercent FLOAT,
status BIT
)
INSERT INTO #tmplogspc
EXEC ('dbcc sqlperf(logspace)')
SELECT @sizeGb = logSizeMb / 1024, @usedGb = logSizeMB * spaceUsedPercent / 100 / 1024
FROM #tmplogspc
WHERE databaseName = 'tempdb'
DROP TABLE #tmplogspc
DECLARE @subject VARCHAR(50)
IF @sizeGb >= 40
BEGIN
SET @subject = 'Tempdb log size is ' + CAST(@sizeGb AS VARCHAR) + ' GB'
EXEC sendEmail @toEmails = 'me@mydomain.com', @subject = @subject
END
ELSE IF @sizeGB > (SELECT TOP 1 gb FROM tempdbLogSize ORDER BY time DESC)
BEGIN
SET @subject = 'Tempdb grew to ' + CAST(@sizeGb AS VARCHAR) + ' GB'
EXEC sendEmail @toEmails = 'me@mydomain.com', @subject = @subject
END
INSERT INTO tempdbLogSize (gb, usedGb) VALUES (@sizeGb, @usedGb)
Diagnosis
My findings haven't been particularly useful in diagnosing the mysterious tempdb log growth. As a bandaid to prevent further system unavailability, I changed my sproc that rebuilds indexes overnight to do its sorts in the user database rather than in tempdb. This causes them to take a little longer, as the happy parallelism of having the index and the rebuild spread across multiple physical disks is lost, but the tempdb log has behaved since. One of the first things I checked for was recent large growth in table size (you record rowcounts daily so that you can see growth over time, right?), figuring this would correspond to large growth in index size and thus tempdb log usage during rebuilds, and there wasn't any, so this isn't particularly helpful.
Labels: SQL Server, SQL Server - Diagnostics, SQL Server - Scripts
Turquoise Starry Bracelet
Sunday, February 10, 2008
Stars and spheres of turquoise-colored howllite wave in a nest of blue threads. Tiny seed beads dance on silky fronds.Visit Jellybug Artworks for more pictures and a chance to own this item!
Apples and Amethysts Bracelet
Small coins and large ovals of green apple turquoise are interspersed with glowing amethysts in this elegant bracelet.The bracelet is 7.5 inches long and clasps with a strong magnet for ease of fastening.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Licorice and Limes Bracelet
Glossy hematite chips, pressed glass and lampworked beads, and frosty lime spheres with dashing strokes of texture curl smartly about your wrist! This bracelet is strung on memory wire, so it will fit any wrist.Visit Jellybug Artworks for more pictures and a chance to own this item!
Turquoise Raku Lime Bracelet
Chunks of tumbled turquoise and frosted lime spheres are punctuated with silver bicones and ceramic raku coins. This bracelet is strung on memory wire, so it will fit any wrist.Visit Jellybug Artworks for more pictures and a chance to own this item!
Vintage Amber Lucite Rings
Monday, February 4, 2008
Vintage lucite rings rescued from a Rhode Island factory that closed in the 1960s. These are light and swingy!I love the swirling colors in these earrings.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Amethyst Drop Earrings
Dainty spheres of deep purple amethyst rest just below your earlobe for a simple, elegant earring.Amethyst is the February birthstone and is associated with nobility and spiritual awareness.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Amethyst Hawaiian Drop Earrings
These amethyst chips are shaped in a "Hawaiian" cut which makes them look like small crystals.Amethyst is the February birthstone and is associated with nobility and spiritual awareness.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Lidded Amethyst Drop Earrings
Dainty orbs of deep purple amethyst lidded with pewter swirls rest just below your earlobe for a simple, elegant earring.Amethyst is the February birthstone and is associated with nobility and spiritual awareness.
Visit Jellybug Artworks for more pictures and a chance to own this item!
Blue Flower Blossom Earrings
Ultra dainty lucite flower blossoms, rescued from a Rhode Island factory that closed in the 1960s.Visit Jellybug Artworks for more pictures and a chance to own this item!
Green Cat's Eye Drop Earrings
Glistening green cat's eyes lidded with swirled pewter caps.Visit Jellybug Artworks for more pictures and a chance to own this item!
Floating Copper Glass Drop Earrings
Black glass and sparkling bits of copper float in a bubble of clear glass.Visit Jellybug Artworks for more pictures and a chance to own this item!
Flying Saucer Earrings
Hematite orbs flank an edgy silver rondelle for an earring that is simple, yet out of this world!Visit Jellybug Artworks for more pictures and a chance to own this item!
Streaky Gold Drop Earrings
Glowing gold glass beads have been painted with bright spots of orange and thin streaks of black.Visit Jellybug Artworks for more pictures and a chance to own this item!
Leafy Wooden Disc Earrings
Pewter leaves and hematite spheres dangle from dark wooden discs -- a funky, unique earring. Visit Jellybug Artworks for more pictures and a chance to own this item!
Moonscape Earrings
Mother of Pearl Flower Earrings
Orange Heishe Drops
Pressed Glass Drop Earrings
Raku Drop Earrings
Red Glass Drop Earrings
Red Swirl Earrings
Retro Fused Rounds
