Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Monday, 31 December 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, 31 December 2018 12:33:26 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Sunday, 18 November 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, 18 November 2018 08:23:49 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Thursday, 08 November 2018

Eugene Horkay

Academic Letter for 2017 school year, awarded in 2018.

Thursday, 08 November 2018 08:18:33 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Saturday, 03 November 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, 03 November 2018 07:06:56 (Central Standard Time, UTC-06:00) |  | SQL Server#
Saturday, 27 October 2018

Aaron Connects

First Deer

October 27, 2018


Saturday, 27 October 2018 05:26:00 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Tuesday, 26 June 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, 26 June 2018 11:16:12 (Central Standard Time, UTC-06:00) |  | SQL Server#
Thursday, 17 May 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, 17 May 2018 20:10:34 (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, 17 May 2018 11:57:24 (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, 17 May 2018 11:26:42 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Monday, 23 April 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, 23 April 2018 13:48:59 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Monday, 09 April 2018

Horkay Family Farms

Breakfast laid daily !


Monday, 09 April 2018 13:12:02 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Sunday, 18 February 2018

From a moth no less, no digital camouflage pattern needed here !

Sunday, 18 February 2018 11:02:09 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Saturday, 17 February 2018

      These speak for themselves.

Saturday, 17 February 2018 11:55:01 (Central Standard Time, UTC-06:00) |  | Web_Blog#
Friday, 16 February 2018

Been a Cold Winter !

Friday, 16 February 2018 11:21:27 (Central Standard Time, UTC-06:00) |  | SQL Server#
Monday, 29 January 2018

I track stored procedure counts and plans for reporting on volume, when a plan changes and data mining the plans for missing indexes and other information.

The trick to this is you have to track it over time as the DMV tracks cumulative count. An issue I ran into recently was that the cumulative count was negative. I don't know and found a few links, but no real explanation. So now when I find a negative count I usually mark it for removal from the query cache so that it resets. I'm guessing that the count reached the maximum value and "rolled" over to a negative values (similar to reseeding an identity to a negative value when the maximum value of an integer data type has been reached).

Monday, 29 January 2018 09:06:33 (Central Standard Time, UTC-06:00) |  | SQL Server#
Friday, 19 January 2018

Learning new things all the time.  Historically deadlocks have been hard to troubleshoot unless you were able to have a user recreate them or had some type of monitoring tool that was running an extended events session and/or a trace.  

Turns out that is not always true.  As usually you get the call, our application had a deadlock at 4am this morning, can you tell us what happened?  Of course you can, your the DBA, you were awake at 4am and monitoring their application for them.  BUT you can help them.

There are new things in SQL that make this easier, so learn them.  Links are below, script is in my script vault, and it's possible to see what happened with deadlocks at 4am, even though it's now 6am.  [on a real busy system it may not, but so far, it's been nice to me !].

Querying Deadlocks From System_Health XEvent



Tracing Deadlock Graphs: Extended Events or Server Side Trace


DECLARE @SessionName SysName

@SessionName = 'system_health'

SELECT  Session_Name = s.name, s.blocked_event_fire_time, s.dropped_buffer_count, s.dropped_event_count, s.pending_buffers
FROM sys.dm_xe_session_targets t
INNER JOIN sys.dm_xe_sessions s ON s.address = t.event_session_address
WHERE target_name = 'event_file'


@Target_File NVarChar(1000)
@Target_Dir NVarChar(1000)
@Target_File_WildCard NVarChar(1000)

SELECT @Target_File = CAST(t.target_data as XML).value('EventFileTarget[1]/File[1]/@name', 'NVARCHAR(256)')
FROM sys.dm_xe_session_targets t
INNER JOIN sys.dm_xe_sessions s ON s.address = t.event_session_address
WHERE s.name = @SessionName
AND t.target_name = 'event_file'

SELECT @Target_Dir = LEFT(@Target_File, Len(@Target_File) - CHARINDEX('\', REVERSE(@Target_File)))

SELECT @Target_File_WildCard = @Target_Dir + '\'  + @SessionName + '_*.xel'

--Keep this as a separate table because it's called twice in the next query.  You don't want this running twice.
SELECT DeadlockGraph = CAST(event_data AS XML)
DeadlockID = Row_Number() OVER(ORDER BY file_name, file_offset)
INTO #Events
FROM sys.fn_xe_file_target_read_file(@Target_File_WildCard, null, null, null) AS F
WHERE event_data like '<event name="xml_deadlock_report%'

;WITH Victims AS
SELECT VictimID = Deadlock.Victims.value('@id', 'varchar(50)')
FROM #Events e
CROSS APPLY e.DeadlockGraph.nodes('/event/data/value/deadlock/victim-list/victimProcess') as Deadlock(Victims)
DeadlockObjects AS
, ObjectName = Deadlock.Resources.value('@objectname', 'nvarchar(256)')
FROM #Events e
CROSS APPLY e.DeadlockGraph.nodes('/event/data/value/deadlock/resource-list/*') as Deadlock(Resources)
SELECT e.DeadlockID
, TransactionTime = Deadlock.Process.value('@lasttranstarted', 'datetime')
, DeadlockObjects = substring((SELECT (', ' + o.ObjectName)
FROM DeadlockObjects o
WHERE o.DeadlockID = e.DeadlockID
ORDER BY o.ObjectName
3, 4000)
, SPID = Deadlock.Process.value('@spid', 'int')
ProcedureName = Deadlock.Process.value('executionStack[1]/frame[1]/@procname[1]', 'varchar(200)')
LockMode = Deadlock.Process.value('@lockMode', 'char(1)')
Code = Deadlock.Process.value('executionStack[1]/frame[1]', 'varchar(1000)')
ClientApp = CASE LEFT(Deadlock.Process.value('@clientapp', 'varchar(100)'), 29)
WHEN 'SQLAgent - TSQL JobStep (Job '
THEN 'SQLAgent Job: ' + (SELECT name FROM msdb..sysjobs sj WHERE substring(Deadlock.Process.value('@clientapp', 'varchar(100)'),32,32)=(substring(sys.fn_varbintohexstr(sj.job_id),3,100))) + ' - ' + SUBSTRING(Deadlock.Process.value('@clientapp', 'varchar(100)'), 67, len(Deadlock.Process.value('@clientapp', 'varchar(100)'))-67)
ELSE Deadlock.Process.value('@clientapp', 'varchar(100)')
, HostName = Deadlock.Process.value('@hostname', 'varchar(20)')
LoginName = Deadlock.Process.value('@loginname', 'varchar(20)')
InputBuffer = Deadlock.Process.value('inputbuf[1]', 'varchar(1000)')
FROM #Events e
CROSS APPLY e.DeadlockGraph.nodes('/event/data/value/deadlock/process-list/process') as Deadlock(Process)
Victims v ON v.DeadlockID = e.DeadlockID AND v.VictimID = Deadlock.Process.value('@id', 'varchar(50)')
X --In a subquery to make filtering easier (use column names, not XML parsing), no other reason

Friday, 19 January 2018 16:39:00 (Central Standard Time, UTC-06:00) |  | SQL Server#
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
SQL Instance will not fail back to ...
Bravo base to Ghost rider tango
Hash Join vs. Merge Join
Recent Posts
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