Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Thursday, May 16, 2019


SELECT DB_ID(database_name) AS [db_id(database_name)] , database_name, backup_start_date, machine_name FROM msdb..backupset WHERE type = 'D' ORDER BY 1, 2;

SSMS 18.0 GA, pulling up properties of a database for a managed instance.

Thursday, May 16, 2019 9:40:17 AM (Central Standard Time, UTC-06:00) |  | SQL Server#
Saturday, April 06, 2019

I've heard of Quince tree's and bushes and finally decided to give some ago.
We'll see how they do, they are difficult to find, Willis Orchards had some and I was luck enough to get a few.  Picked up a Red Baron Peach tree too.  Historically I don't have good luck with Willis Orchards, though the stock they send is great looking, I think it's just Georgia is such a different soil type and zone than Missouri, the tree's often experience shock, and even though they ship FedEx, the tree's often show up with dried up roots, or budded out and the new leaves dried up, which is disappointing.
But they are one of the few places that carry Quince tree's so got to try.
Stark Brothers is supposed to have some this fall and spring 2020, so depending on how these do, I will keep trying.

QTY Description From Picture
3 Smyrna Quince
The Smyrna Quince is the most popular quince used by famous chefs. Widely used for cooking in Europe, the quince fruit trees are finding new attention now in America. The Smyrna Quince is a large apple shaped fruit with lemon yellow skin and excellent flavored tender flesh. This self-fertile fruit is highly perfumed and ripens September to October. (100 Chill Hours) Grows in zones: 5 - 9
Willis Orchards
2 Orange Quince
The Orange Quince is a very adaptable growing well in a range of conditions. This tree is just about as hardy as the peach, surviving temperatures as low as 0º F. Its branches will most likely die back if exposed to temperatures below -15º F, though the root will survive. The Quince can grow up to 20 feet high with unusual, crooked branches. They do best grown in moist, heavy soils and are often found in the wild near creek banks making this fruit a delicacy for wildlife. The orange quince bears heavily with large, bright yellow pear shaped fruits that are flavorful and aromatic. The fruit ripens in October through December and can extend through February in some colder areas. The Orange Quince is a self fertile tree and requires 300 chill hours.
Grows in zones: 5 - 9
Willis Orchards
1 Red Baron Peach
The Red Baron Peach Tree is a patented variety of unsurpassed excellence. Not only is the fruit a large, beautiful red, but the tree itself is prized for its large double red blossoms that cover the tree for several weeks in early spring. These delicious 3" diameter fruits ripen over an extended period of time from mid-July to mid-August, and require a low 250 chill hours.
Willis Orchards
2 Pineapple Quince
The Pineapple Quince is popular for its firm aromatic white flesh with a delicious pineapple-like flavor. This large pear-shaped fruit has smooth, golden yellow skin that is good for fresh eating or for fine jellies. Quince Trees are self-fertile and ripen large crops of fruit in September. (100 Chill Hours)
Grows in zones: 5 - 9
Willis Orchards
2 Jumbo Quince
This large bright-yellow fuzzy cousin of pears and apples is getting a boost from the Agricultural Research Service and making a come back. In Colonial times, many American orchards boasted at least one quince and vendors sold them along with pears and apples. Jumbo Quince fruits are hard and sour when raw. When heated their flesh turns rosy, soft and sweet. An excellent variety for making tarts, pies, butters, marmalades and jellies. The fragrant aroma from the fruit of the jumbo quince has an appealing drawing to large wildlife. The fruit typically ripens in October through December. The Jumbo Quince is disease tolerant and cold hardy growing in zones 5-9. Choose Willis Orchards for top-quality quince fruit trees for sale! Grows in zones: 5 - 9
Willis Orchards

Saturday, April 06, 2019 7:42:28 AM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Saturday, March 30, 2019

Strong Heat # 4


Saturday, March 30, 2019 1:55:55 PM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Wednesday, February 20, 2019

Was a very cold February for the cows !




Wednesday, February 20, 2019 8:26:20 PM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Thursday, January 24, 2019

Corrupt model database.

Nothing more fun than bug in vm ware causing disk corruption and leaving your model database suspect.

You can run in this state, as long as you don't create a new database and as long as your server doesn't reboot or SQL server service stop and start, as when SQL Starts back up, it will have an issue with model database.

Standard TSQL Statement, Restore database model from disk = 'some location' with recovery.

What this has to do with Record Rater, I have no idea, but I found this cool old record and it even still had the survey card... Big Red Music.

Very Cool...




Thursday, January 24, 2019 8:14:20 PM (Central Standard Time, UTC-06:00) |  | SQL Server | Web_Blog#
Monday, December 31, 2018

Final Tree's for planting in 2018 were delivered and put in the ground the past week.


QTY Description From Picture
2 Pond Cypress
(Taxodium ascendens)
The Pond Cypress Tree is very similar to the Bald Cypress, except that it has finer foliage, thicker bark and is always found growing in non-flowing bodies of water. These trees maintain a desirable straight trunk and develop thick calipers towards the base, even on younger trees. The Pond Cypress is a relatively maintenance free tree requiring minimal pruning only to remove lower dead branches. The cypress will grow 50 to 60 feet tall with a 10 to 15 feet spread and prefers to be planted in wet, poorly drained, acidic soil.
Willis Orchards
2 Indian Blood Peach
This heavy producer of good quality, white streaked with red fleshed peach holds well for canning and preserving. The Indian Blood peach is a zone 4 peach tree of the large red skinned clingstone variety that ripens August to September. The Indian Blood Peach tree does best with a pollinator and needs 900 chill hours. Grows in zones: 4 - 8
Willis Orchards
2 Red Baron Peach
The Red Baron Peach Tree is a patented variety of unsurpassed excellence. Not only is the fruit a large, beautiful red, but the tree itself is prized for its large double red blossoms that cover the tree for several weeks in early spring. These delicious 3" diameter fruits ripen over an extended period of time from mid-July to mid-August, and require a low 250 chill hours.
Willis Orchards
1 20th Century Asian Pear
The 20th Century Asian Pear Tree is an August ripening Japanese variety that is semi-self fertile. It is a medium to large, round yellow-green colored pear of good quality and decent sweet taste. This juicy Asian Pear treat is great eaten fresh and it stores well for canning and preserving. The 20th Century Asian Pear will set a much heavier crop when planted with one of the other Asian pear varieties. Requires 400 chill hours. Will grow in zones 5-9a. Grows in zones: 5 - 9
Willis Orchards
2 Eliza's Choice Crabapple
Eliza's Choice Crabapple Tree is a naturally select cultivar found on a small family farm near McMinnville, TN. This select crabapple tree variety is an excellent pick for wildlife plantings and jelly making. It has beautiful showy white blossoms in Spring and the fruits ripen later than many other varieties. The pictures show Eliza standing by her Choice Crabapple tree loaded with fruit in mid-October. However, the fruits continue to ripen and fall well into November, which makes Eliza's Choice Crabapple a must have for hunting enthusiasts.
Willis Orchards
1 Giant Fuyu Persimmon Tree
This is a very large hybrid of the Fuyu Jiro. The Giant Fuyu Persimmon tree also ripens in November and is non-astringent. The fruit is a dark orange color when ripe and has a delicious smooth texture. (100-200 Chill Hours) Grows in zones: 6 - 10
Willis Orchards
1 Ivory Silk Lilac
Not Your Grandma's Lilac! Looking for something different? The Tree Lilac (Syringa reticulata 'Ivory Silk') is not the flowering shrub you might have seen in grandma’s yard, but a small tree that bears huge (foot- long!) flower panicles in late June, well after other lilacs have given up for the season. The monster flower bunches are creamy white and give off a heady, musky scent that will perfume your entire garden. These trees only get about 25 feet high which makes them perfect for small yards or as a focal point. For an even greater impact, plant several along a fence line – they make a show-stopping tall hedgerow! On top of all this goodness, the Tree Lilac can withstand temperatures as low as 30 degrees below zero and isn’t affected by soil ph like other lilacs. It is the hardiest and most trouble free Lilac available, especially for northern climates. The Tree Lilac blooms more heavily than other Lilac varieties, too. It flowers later in the season, extending your Lilac pleasure. Through the summer your Tree Lilac will be densely covered in beautiful, deep green leaves, a refreshing sight in the height of summer heat. In the fall and winter the attractive, smooth, dark red bark adds an interesting dimension and texture to your landscape. Whether you’re new to lilacs or just want to add something different to your garden, the Tree Lilac is for you. Order yours today! * Huge flowers. * Fragrant blooms. * Cold hardy and trouble free. Don’t Prune Lilacs During Fall or Early Spring
Nature Hills Nursery
1 Shinseki Pear Tree
An early harvest of delicious Asian Pears on a hardy tree. Nothing beats a crisp easy-to-eat pear straight from the tree during the dog-days of summer. Shinseiki Asian Pear Tree is a beautiful tree that covers itself in loads of round, yellow-skinned pears. The tree is easy to grow and the fruit is oh SO delicious!
You will love these pears if you are a fan of Granny Smith apples over Red Delicious. Crisp, juicy texture and sublimely-sweet flavor are the hallmarks of these pretty fruit.
Since this is one of the earliest Asian pears to ripen available on the market today, you will be enjoying bowls of the yummy fruits weeks before your neighbors.
The tree grows naturally to a lovely conical shape and is covered in flowers in the spring. When the fruit is ripening, it looks like Christmas ornaments hung all over the tree. Young trees will produce up to 100 fruit, while 6-7 year old trees produce 500-700 pears each year!
Nature Hills Nursery
1 Falvor Supreme Pluot
Supreme Sweetness in a Gorgeous Fruit Pluots are an all-around great fruit and one of the best fruit tastes in all the world. In a field of amazingly sweet fruits, Flavor Supreme Pluot, Prunus 'Flavor Supreme', raises to the top with award after award for its taste. It’s like picking a winning diamond from a field of diamonds. You can’t go wrong with any pluot, but you will be very happy with the Supreme. It looks different than you’d expect – smooth, mottled-green skin with firm, juicy wine-red flesh. But don’t let the look fool you. These pluots marry the best of both plums and apricots and this brings out the sweetest taste imaginable. The tree itself has a classic shape and beautiful Japanese plum-like leaves. It makes a pretty landscape tree in your yard. A pretty tree with a bonus - you’ll have plenty of fruit to eat and an abundance to share with your friends and neighbors. Flavor Supreme needs a pollinator so order two. Or you can plant it with a Japanese plum like Beauty Plum or another pluot, like Flavor Grenade or Flavor King. Order a couple of these beauties today and enjoy this supremely sweet fruit next year. You’ll thank us! * Winter hardy * Super-sweet taste * Early harvest
Nature Hills Nursery

Monday, December 31, 2018 12:33:26 PM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Sunday, November 18, 2018

Thomas connects with 5 pointer twice !

AR15, with 300 Black out.

Hornady American Gunner Ammunition 300 AAC Blackout 125 Grain Hollow

120lb white tail before being field dressed.


Sunday, November 18, 2018 8:23:49 AM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Thursday, November 08, 2018

Eugene Horkay

Academic Letter for 2017 school year, awarded in 2018.

Thursday, November 08, 2018 8:18:33 AM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Saturday, November 03, 2018

Patching SQL Server, generally completes without errors, but sometimes, you do get complications.


This was in applying sql 2017 CU 11, 14.0.3814, to SQL Server Failover cluster (FCI), with always-on to another SQL Server Failover cluster (FCI), no listener between the two.  Failed on the passive node.


The dreaded error below:


Message Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 3933, state 1, severity 25. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.


Finally figured this out to be related to the check box for MS DTS on the properties for Always-On.


Supposedly fixed in CU7, but I think not.




Unchecked the DTC Support for AG Group.

Re-ran the patch, and it completed successfully.

I Love patches !

Saturday, November 03, 2018 7:06:56 AM (Central Standard Time, UTC-06:00) |  | SQL Server#
Saturday, October 27, 2018

Aaron Connects

First Deer

October 27, 2018


Saturday, October 27, 2018 5:26:00 AM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Tuesday, June 26, 2018

Configuring a listener on Azure with availability groups requires a special power shell script to be run afterwards to make it available outside the environment.

I had issues running the script with the multiple statement, but if you run them singularly you are good to go.




$ClusterNetworkName = "<MyClusterNetworkName>" # the cluster network name (Use Get-ClusterNetwork on Windows Server 2012 of higher to find the name)
$IPResourceName = "<IPResourceName>" # the IP Address resource name
$ILBIP = "<n.n.n.n>" # the IP Address of the Internal Load Balancer (ILB). This is the static IP address for the load balancer you configured in the Azure portal.
[int]$ProbePort = <nnnnn>
Import-Module FailoverClusters
Get-ClusterResource $IPResourceName | Set-ClusterParameter -Multiple @{"Address"="$ILBIP";"ProbePort"=$ProbePort;"SubnetMask"="";"Network"="$ClusterNetworkName";"EnableDhcp"=0}
#--  Probe Check Script:
Get-ClusterResource |`
Where-Object {$_.ResourceType.Name -like "IP Address"} |`
Get-ClusterParameter |`
Where-Object {($_.Name -like "Network") -or ($_.Name -like "Address") -or ($_.Name -like "ProbePort") -or ($_.Name -like "SubnetMask")}
Tuesday, June 26, 2018 11:16:12 AM (Central Standard Time, UTC-06:00) |  | SQL Server#
Thursday, May 17, 2018

Incredible, but true.

SQL Server 2017, specific build = 14.0.3015.40, on an Azure Cloud server, IAAS.

While restoring a database it just sits there forever what felt like forever (it was 80gb), and after awhile saw this in the error log:

The operating system returned the error '21(The device is not ready.)' while attempting 'GetDiskFreeSpace' on 'A:\'.

Guess what, you fix this by disabling your floppy drive in device manager. Absolutely amazing.


I actually still have some 5 1/2 and 3 1/4 floppy disks and a USB Floppy drive, though I doubt there would be a use for a "floppy drive" controller on a cloud machine, but it's good to see the floppy's in the cloud.

Thursday, May 17, 2018 8:10:34 PM (Central Standard Time, UTC-06:00) |  | SQL Server#

Setting up always-on availability group with no cluster.

So far works good, though some of our backup and monitoring queries began failing, specifically the function, sys.fn_hadr_backup_is_preferred_replica

Msg 35222, Level 16, State 0, Line 1 Could not process the operation. Always On Availability Groups does not have permissions to access the Windows Server Failover Clustering (WSFC) cluster. Disable and re-enable Always On Availability Groups by using the SQL Server Configuration Manager. Then, restart the SQL Server service, and retry the currently operation. For information about how to enable and disable Always On Availability Groups, see SQL Server Books Online.

We ended up working around this by checking the sys.availability_groups which has a column for cluster type, this way we can check if the always-on group has a cluster or not.

-- This leads to error
select [master].sys.fn_hadr_backup_is_preferred_replica('ao_test')
CASE WHEN dbrs.is_primary_replica = 1 and ag.cluster_type = 1 then 1
when dbrs.is_primary_replica = 0 and ag.cluster_type = 1 then 0
WHEN ag.cluster_type is null then 0
else Convert(int,[master].sys.fn_hadr_backup_is_preferred_replica(sd.[name])) end
as preferred_replica_backup
From sys.databases sd
LEFT OUTER JOIN master.sys.dm_hadr_database_replica_states AS dbrs
ON sd.group_database_id = dbrs.group_database_id and dbrs.is_local = 1
left outer join master.sys.availability_groups ag
on ag.group_id = dbrs.group_id where sd.[name] = 'ao_test'


Thursday, May 17, 2018 11:57:24 AM (Central Standard Time, UTC-06:00) |  | SQL Server#

Horkay Family Farms first heifer calf, 3 bull calves in row up until now !

5/17/2018, Not yet named


Thursday, May 17, 2018 11:26:42 AM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Monday, April 23, 2018

Planting Tree's for 2018.

Threw in some new cheap plants from Farmer Seed (aka burgess, plants are of questionable quality, hit and miss, but they are cheap).

Concentrating on removing invasive trees (locust, hedge apple, thorny Bradford pear) and replacing with Asian Pears, Arkansas Black Apple, Wealthy Apple and a few others.

We'll see what lives, success is usually pretty good with Stark Brothers and Nature Hills Nursery, though I've had terrible luck getting Sassafras trees to grow, 5 more this year.

QTY Description From Picture
2 Korean Fir Japanese Maples and Evergreens
2 Dolgo Crabapple Stark Brothers 1
Farmer Seed and Nursery 1
1 Starking Hardy Giant Asian Pear Stark Brothers  
1 Chojuro Asian Pear Stark Brothers  
1 Hosui Asian Pear Dwarf Startk Brothes  
1 Grimes Golden Apple Stark Brother's Nursery  
1 Arkansas Black Apple Nature Hills Nursery  
1 Sweet Chestnuts Farmer Seed and Nursery
2 Wealthy Apple Nature Hills Nursery  
1 American Holly Tree Form Nature Hills Nursery  
2 Flavor King Pluot Nature Hills Nursery  
1 Thunder Cloud Plum Nature Hills Nursery  
2 Scarlet Halo Peach Nature Hills Nursery  
2 Ichi-Ki-Kei-Jiro Asian Persimmon Stark Brother's  
1 Sunflower Paw Paw Stark Brother's  
1 Peruque Pecan Stark Brother's  
1 Chestnut Crabapple Stark Brother's  
1 Auburn Homestead Chestnut Stark Brother's  
5 Black Hills Spruce Chief River Nursery  
2 Green Giant Arborvitae Chief River Nursery  
5 White Pine Chief River Nursery  
5 White Spruce Chief River Nursery  
5 Concord Seedless Grape Chief River Nursery  
5 Somerset Seedless Grape (white) Chief River Nursery  
1 Heartnut Farmer Seed and Nursery  
1 Hall's Hardy Almonds
Farmer Seed and Nursery  
5 Sassafras Nature Hills Nursery - 2
Farmer Seed and Nursery - 3
1 American Persimmon Farmer Seed and Nursery  
4 Dwarf American Hazelnuts Farmer Seed and Nursery  
2 American Butternut Farmer Seed and Nursery  
2 Old Fashioned Lilac Farmer Seed and Nursery  
6 Canadian Hemlock Farmer Seed and Nursery  
1 Paw Paw Tree Farmer Seed and Nursery  
24 Rose of Sharon Hedge Farmer Seed and Nursery  
6 Purple Leaf Plum Hedge Farmer Seed and Nursery  
16 Forsythia Farmer Seed and Nursery  
1 Harry Lauder's Walking Stick
Farmer Seed and Nursery  
1 Golden Chain Tree Farmer Seed and Nursery  
4 Purple Smoke Tree Farmer Seed and Nursery  

Monday, April 23, 2018 1:48:59 PM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Monday, April 09, 2018

Horkay Family Farms

Breakfast laid daily !


Monday, April 09, 2018 1:12:02 PM (Central Standard Time, UTC-06:00) |  | Web_Blog#
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
SQL Agent will not start when a use...
SQL Instance will not fail back to ...
Hash Join vs. Merge Join
Recent Posts
May, 2019 (1)
April, 2019 (1)
March, 2019 (1)
February, 2019 (1)
January, 2019 (1)
December, 2018 (1)
November, 2018 (3)
October, 2018 (1)
June, 2018 (1)
May, 2018 (3)
April, 2018 (2)
February, 2018 (3)
January, 2018 (3)
November, 2017 (1)
October, 2017 (1)
August, 2017 (1)
June, 2017 (2)
May, 2017 (2)
April, 2017 (2)
March, 2017 (1)
February, 2017 (1)
December, 2016 (2)
October, 2016 (2)
September, 2016 (1)
August, 2016 (1)
July, 2016 (1)
March, 2016 (2)
February, 2016 (3)
December, 2015 (4)
November, 2015 (6)
September, 2015 (1)
August, 2015 (2)
July, 2015 (1)
March, 2015 (2)
January, 2015 (1)
December, 2014 (3)
November, 2014 (1)
July, 2014 (2)
June, 2014 (2)
May, 2014 (3)
April, 2014 (3)
March, 2014 (1)
December, 2013 (1)
October, 2013 (1)
August, 2013 (1)
July, 2013 (1)
June, 2013 (2)
May, 2013 (1)
March, 2013 (3)
February, 2013 (3)
January, 2013 (1)
December, 2012 (3)
November, 2012 (1)
October, 2012 (1)
September, 2012 (1)
August, 2012 (1)
July, 2012 (4)
June, 2012 (3)
April, 2012 (1)
March, 2012 (3)
February, 2012 (3)
January, 2012 (4)
December, 2011 (3)
October, 2011 (2)
September, 2011 (2)
August, 2011 (8)
July, 2011 (4)
June, 2011 (3)
May, 2011 (3)
April, 2011 (1)
March, 2011 (2)
February, 2011 (3)
January, 2011 (1)
September, 2010 (1)
August, 2010 (2)
May, 2010 (2)
April, 2010 (3)
March, 2010 (1)
February, 2010 (4)
January, 2010 (1)
December, 2009 (3)
November, 2009 (2)
October, 2009 (2)
September, 2009 (5)
August, 2009 (4)
July, 2009 (8)
June, 2009 (2)
May, 2009 (3)
April, 2009 (9)
March, 2009 (6)
February, 2009 (3)
January, 2009 (8)
December, 2008 (8)
November, 2008 (4)
October, 2008 (14)
September, 2008 (10)
August, 2008 (7)
July, 2008 (7)
June, 2008 (11)
May, 2008 (14)
April, 2008 (12)
March, 2008 (17)
February, 2008 (10)
January, 2008 (13)
December, 2007 (7)
November, 2007 (8)
Admin Login
Sign In