Horkay Blog
The postings on this site are my own and do not represent my Employer's positions, advice or strategies.
Monday, 21 August 2017

Solar Eclipse 2017

 

 
Monday, 21 August 2017 09:29:35 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Wednesday, 14 June 2017

Faith has first calf of 2017, a Bull calf.

 

 
Wednesday, 14 June 2017 19:41:36 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Tuesday, 13 June 2017

Configure read only routing for always on.

Necessary so that applicationintent=readonly goes to correct server.

Use SQLCMD to test, if it doesn't work (meaning return the read only replica server name), than you still need to configure the readonly routing, here is sqlcmd command:

sqlcmd -Svlnpaoam -E -d EAM -K READONLY -Q "Select @@servername"

Here is example to configure,

ALTER AVAILABILITY GROUP AG_LNP_EAM
MODIFY REPLICA ON
N'lnpclxsql11\EAM11' WITH 
(PRIMARY_ROLE (ALLOW_CONNECTIONS = all));

ALTER AVAILABILITY GROUP AG_LNP_EAM
MODIFY REPLICA ON
N'lnpclxsql10\EAM10' WITH 
(PRIMARY_ROLE (ALLOW_CONNECTIONS = all));
-----------------------------------------------------------------

ALTER AVAILABILITY GROUP AG_LNP_EAM
MODIFY REPLICA ON
N'lnpclxsql10\EAM10' WITH 
(SECONDARY_ROLE (ALLOW_CONNECTIONS = Read_Only));

ALTER AVAILABILITY GROUP AG_LNP_EAM
MODIFY REPLICA ON
N'lnpclxsql10\EAM10' WITH 
(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://LNPCLXSQL10.HRBINC.HRBLOCK.NET:1600'));
-----------------------------------------------------------------

ALTER AVAILABILITY GROUP AG_LNP_EAM
MODIFY REPLICA ON
N'lnpclxsql11\EAM11' WITH 
(SECONDARY_ROLE (ALLOW_CONNECTIONS = Read_Only));

ALTER AVAILABILITY GROUP AG_LNP_EAM
MODIFY REPLICA ON
N'lnpclxsql11\eam11' WITH 
(SECONDARY_ROLE (READ_ONLY_ROUTING_URL = N'TCP://lnpclxsql11.HRBINC.HRBLOCK.NET:1600'));
-----------------------------------------------------------------

ALTER AVAILABILITY GROUP AG_LNP_EAM 
MODIFY REPLICA ON
N'lnpclxsql10\eam10' WITH 
(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('lnpclxsql11\eam11','lnpclxsql10\eam10')));

ALTER AVAILABILITY GROUP AG_LNP_EAM 
MODIFY REPLICA ON
N'lnpclxsql11\EAM11' WITH 
(PRIMARY_ROLE (READ_ONLY_ROUTING_LIST=('lnpclxsql10\eam10','lnpclxsql11\eam11')));
GO
Tuesday, 13 June 2017 11:35:20 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#
Monday, 15 May 2017

John Deere Gator 625 review.

A good machine, replaces an EZ-GO STS 4x4, many reviews of the specs on these so I won't re-iterate them, but it's basically the same as the ez-go with better ground clearance, Fuel injected (nice to not need to manually choke it), a design more updated and more like a car than a piece of lawn equipment (with a price to match), an updated design (vs EZGO), but basically still the same engine horsepower 18 vs 20, twin cylinder, Kawasaki vs. Honda engine, 2 and 4 wheel drive, with lever for locking differentials (EZ-GO had electronic locking differential switches).

 

This thing is loaded with power winch, roof with lights, power dump bed, brush guard with front storage, tool bag across back, and bucket holder, impressive towing power.  Would prefer a USB plug as opposed to the cigarette lighter accessory outlet (who uses a cigarette lighter anymore ?)

 

Transmission seems good, makes a weird whining noise when I go down hills (usually at very low speeds < 5), than makes a "bucking / catching" noise at the bottom when you hit the gas, probably the clutch engaging, not sure, we'll see how it holds up, I've learned to come to a stop at the bottom of hills and then proceed forward to avoid that "bucking / catching" noise.

 

Feature x feature and price, I found the gator 625 was better than others out there (Actually my wife did !).

 

Now I just need to rebuild the EZGO motor!

 

Only a few complaints so far after two months, about 60 some miles is

  1. Tail gate needed to be worked, not sure the dealer put that together right, wouldn't close and the "bar" would slide / fall right out that secures to the catch mechanism of the bed, took me an hour or so to find the thing in the grass after it fell out while riding around in the back pasture, PIA, but easy to fix, and most likely the dealer just didn't do it right.
  2. a tinny metallic sound coming from somewhere in the front right fender while riding, just a little annoying, still can't find what is rattling.
  3. It's a LOT louder than the EZGO, not as loud as some people that complain about (it's a common complaint on these).  There is someone that sells a suppressor for this thing, a MUST BUY.
  4. Of course it's just wide enough it won't fit in my trailer, so hopefully I don't need the warranty, as getting it back to the dealer will require a flat bed tow or borrowing / renting a trailer.  [ more of an observation than a complaint ].
  5. Floor needs more aggressive texturing, too smooth and when working with muddy boots it's slippery.

 

Options and Accessories.

  • Winch is nice, but you must use wheel chucks, as it's so powerful that it just drags the gator closer to whatever your winching, so far I think the winch is probably only useful for pulling the gator out of the mud if it's stuck, everything I've tried to winch, I had to go get the tractor and chains instead, so the winch is a waste for me, YMMV.
  • The power dump bed is the best option, as if you've ever tried to manually dump rocks, dirt or wood chips you quickly realize how much you need that, BEST OPTION, BUT, don't forget you have to lift the bed to check the oil, and remember to turn the key to the off position or you may wind up with a dead battery the next morning.
  • Definitely nice to have a BUZZER linked to the Parking Brake, can't tell you how many times I drove that EZGO around without realizing the parking brake was on (there is an idiot light, but hard to see in bright sun).
  • The fuel injected Kawasaki engine seems "thirstier" than the EZGO, no scientific way to measure that, feels like I fill it up more.
  • Bed Extender is nice, though the design to remove it with steel roll pins and springs is about unworkable, so far I've broken two of the steel roll pins and cursed up and down trying to get the stupid pins lined up, probably best if you need a bigger bed, buy a piece of plywood and lay it in there, or at least, don't ever plan on easily removing and putting it back in, once it's in, it's in, save the money on this accessory and buy some plywood and get a radio !
  • Doors made of netting, not sure about these yet, I may remove them.
  • Easy enough the kids can drive it with no issues (has retractable seat belts even).
Monday, 15 May 2017 09:27:56 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Monday, 01 May 2017

Absolutely the best hot water heater.

Rinnai Hybrid Tank-Tankless Water Heater - https://www.rinnai.us/hybrid-tank-tankless-water-heater 

Bought at Lowes for a very good price.

Rinnai Hybrid 40-GPM 87300-BTU 1-Year Limited Liquid Propane Hybrid Water Heater

https://www.lowes.com/pd/Rinnai-Hybrid-40-GPM-87300-BTU-1-Year-Limited-Liquid-Propane-Hybrid-Water-Heater/1000201743 

Recently installed this hot water heater, 5 people in the house and it keeps up, have done laundry, dish washer and showers simultaneously and one after the other, so far, it's awesome !

Installed exactly where the old electric was, and was simpler than a "true tankless" hot water heater, which would have required re-doing propane regulator, cutting ceiling / floor joist to route intack and exhaust, re-routing water lines, hang hooded thing on outside of house to cover intake and exhaust and the hyprid was only 700 more than a regular hot water heater, so cheaper too, installation cost is / was the same as regular hot water heater.

We'll see how long it holds up, and the long term cost difference between propane vs. electric, but so far this thing is good, and no longer have to time our showers, do dishes or wash around who wants to shower !

 

 

Monday, 01 May 2017 09:00:49 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Friday, 28 April 2017

Asplundh delivers, wood chipper mulch dropped right to you by the truck load.

 

 
Friday, 28 April 2017 19:51:13 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Thursday, 20 April 2017

Aaron's cast removal 2017, the year of the bone !

 

Thursday, 20 April 2017 05:32:53 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Monday, 06 March 2017

Cast removal day !

 

 
Monday, 06 March 2017 07:53:42 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Monday, 20 February 2017

Troubleshooting tlog backup failure in always-on environment, backups on read-only / passive node.

This was an odd failure, as it occurred 4 or 5 times, right after the full backup, than it would "resolve itself", but the next day, right after the full backup, it would happen again, repeating itself daily in this fashion.

Tracked this back to an issue with the disk, where it seems we had a 605 error during a checkdb, that also "resolved itself" and the next days checkdb was good, so no action was taken, but this is what started the chain of events.

Eventually I did find someone with a similar issue that a system spid was hung, I resolved my issue by rebooting the environment(s).  Link and text below my error messages.

Log backup for database "{db name here}" on secondary replica created backup
files successfully but could not ensure that a backup point has been
committed on the primary.  This is an informational message only.
Preserve this log backup along with the other log backups of this
database.          [SQLSTATE 01000]

Msg 35250, Sev 16, State 11, Line 39 : The connection to the primary
replica is not active.  The command cannot be processed. [SQLSTATE 42000]
Msg 3013, Sev 16, State 1, Line 39 : BACKUP LOG is terminating abnormally.
[SQLSTATE 42000]


The operating system returned error 665(The requested operation could not
be completed due to a file system limitation) to SQL Server during a write
at offset 0x00001cb940e000 in file
'{drive letter\db.ndf file}:MSSQL_DBCC12'. Additional
messages in the SQL Server error log and system event log may provide more
detail. This is a severe system-level error condition that threatens
database integrity and must be corrected immediately. Complete a full
database consistency check (DBCC CHECKDB). This error can be caused by
many factors; for more information, see SQL Server Books Online

-------------

https://blogs.msdn.microsoft.com/psssql/2012/12/05/alwayson-error-log-backup-for-database-mydb-on-secondary-replica-created-backup-files-successfully-but-could-not-ensure-that-a-backup-point-has-been-committed-on-the-primary/ 

-------

This error surprised me when it showed up in the error log so I decided to dig into it a bit more.

“Log backup for database “MyDB” on secondary replica created backup files successfully but could not ensure that a backup point has been committed on the primary.  This is an informational message only. 

Preserve this log backup along with the other log backups of this database.”

The message appears on the secondary replica, where the backup was taken, and indicates one of two possible conditions.  To understand the conditions it helps to understand the state of the backup operation.

The error occurs after the point where the backup was successfully streamed to the backup media. The first concern I had was “is my backup valid” and the answer is YES!  The backup has been written to the backup media properly.

Now the secondary sends a message to the primary to update the backup position in the database.  If this message fails the error is logged.

1. The secondary sends the completed message to the primary.  The primary records the backup position but for some reason fails to respond the secondary (I.E. lost network connection.)   In this case the next backup will pick up were the current backup completed.

2. The secondary sends the completed message to the primary.  The primary never receives the message or fails in some way before it can record the current backup position.  (I.E. network, primary shut down, etc…).  In this case the next backup will acquire the same information as the last log backup and any additional log records generated.

As you can see the message may be a bit alarming but it is harmless to your backup strategy other than the fact that you might get extra log records in a backup but that can be properly handled during restore.  NO DATA LOSS!

----------

Diane Sithoo says:

I'm seeing a third condition, trying to perform native log backups, where for some reason, although the backup has been written properly to the backup media, all further attempts to backup fail with Msg 35250, Level 16, State 11, "The connection to the primary replica is not active.  The command cannot be processed.".  This is then followed by Msg 3013, Level 16, State 1, "BACKUP LOG is terminating abnormally."

So far, even in dealing with MS support, there is no resolution to this.  What happens is that at that point, the background process is blocked.  When I use DMV view sys.dm_exec_requests, it shows as HADR BACKUP LOCK HOLDER.  The wait type on the blocked process is LCK_M_U and the wait resource is DATABASE: <id> [BULKOP_BACKUP_LOG].  On the blocking process, the wait type is HADR_BACKUP_QUEUE.  Until I either restart SQL Server Agent on the secondary, or run DBCC STACKDUMP, it continues to block.

Monday, 20 February 2017 12:33:34 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server | Web_Blog#
Tuesday, 13 December 2016

Still trying to get some Red Baron Peach trees growing.

From Willis Orchards

  • Red Baron Peach - 4
  • Fuyu Persimmon Tree - 2
  • Arkansas Black Apple Tree - 2
  • Hall's Hardy Almond Tree - 2
  • Pawnee Pecan Tree - 2

 

Tuesday, 13 December 2016 16:15:07 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Friday, 09 December 2016

The Kawasaki KLX140G is great intermediate size dirt bike for teenage kids.  Good trail riding bike, electric start, choke up on the handlebars, chain is easy to adjust, oil and filter easy to get too.  Had to replace a clutch handle already when it was laid down while riding, overall a great bike.   If you take it to moto track, remember to remove the kickstand or ziptie it up, even though it has a strong spring you don't want it flopping down on a jump, seen a bad accident happen, so even though we haven't experienced that with this bike, I always take those off when the kid rides anything with jumps.

Pictures.

Friday, 09 December 2016 08:01:45 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Thursday, 06 October 2016

Couple different ways to get block size on windows.

Traditionally I used fsutil, previous blog post on that here, but recently I've been using powershell, and then using TSQL to run the powershell script and return it as a result set, which I then keep in a tracking system.

Here is the powershell script:

Get-WmiObject win32_volume | select SystemName, Label, name,
@{N="BlockSize";E={($_.BlockSize/1024)}},@{N="Capacity";E={[int]$a=$_.Capacity/(1024*1024*1024);$a}}

Here is the same script, embedded in TSQL (yes it uses xp_cmdshell).

Declare @Is_XP_CMDSHELL_Enabled Int

Set @Is_XP_CMDSHELL_Enabled = (
    SELECT CONVERT(INT, ISNULL(value, value_in_use)) AS config_value
    FROM  sys.configurations
    WHERE  name = 'xp_cmdshell');

-- not enabled
If @Is_XP_CMDSHELL_Enabled = 0 
BEGIN
    -- To allow advanced options to be changed.
    EXEC sp_configure 'show advanced options', 1
    -- To update the currently configured value for advanced options.
    RECONFIGURE
    -- To enable the feature.
    EXEC sp_configure 'xp_cmdshell', 1
    -- To update the currently configured value for this feature.
    RECONFIGURE
END
 
CREATE TABLE #output
(line varchar(255))
INSERT #output
EXEC xp_cmdshell 'Powershell –command "get-wmiobject Win32_volume |select Name,Capacity,Freespace,BlockSize,Label | ConvertTo-Xml -NoTypeInformation -As string"'

-- only disable xp_cmdshell if it was found this way
If @Is_XP_CMDSHELL_Enabled = 0 
begin
    -- immediately disable xp_cmdshell
    EXEC master.dbo.sp_configure 'show advanced options', 1
    RECONFIGURE
    EXEC master.dbo.sp_configure 'xp_cmdshell', 0
    RECONFIGURE
end
 
DELETE #output WHERE line IS NULL
 
DECLARE @doc varchar(max)
SET @doc = ''
DECLARE @line varchar(255)
DECLARE xml_cursor CURSOR
FOR SELECT line FROM #output
OPEN xml_cursor
FETCH NEXT FROM xml_cursor INTO @line
WHILE @@FETCH_STATUS = 0
BEGIN
SET @doc = @doc + @line
FETCH NEXT FROM xml_cursor INTO @line
END
CLOSE xml_cursor
DEALLOCATE xml_cursor
DROP TABLE #output
 
SELECT
item.ref.value('(Property/text())[1]', 'nvarchar(128)') AS VolumeName
,item.ref.value('(Property/text())[2]', 'nvarchar(128)') AS SizeBytes
,item.ref.value('(Property/text())[3]', 'nvarchar(128)') AS FreeBytes
,item.ref.value('(Property/text())[4]', 'nvarchar(128)') AS [BlockSize]
,item.ref.value('(Property/text())[5]', 'nvarchar(128)') AS Label
FROM (SELECT CAST(@doc AS XML) AS feedXml) feeds(feedXml)
CROSS APPLY feedXml.nodes('/Objects/Object') AS item(ref)

 

Thursday, 06 October 2016 17:03:45 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server | Web_Blog#
Wednesday, 05 October 2016
Wednesday, 05 October 2016 20:17:14 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Thursday, 01 September 2016

Always nice to have clustered disks having meaningful names other than "Cluster Disk 1".
Renaming lots of disks by hand is a pain.
In a multi-geographic cluster you may have clustered disks in different geographic locations, making it hard to distinguish by looking at the name what disk is in what data center, so we preface the name with an acronym for each datacenter. Refer to statement above, "Renaming lots of disks by hand is a pain".
Use power shell to automate the process.

Get-ClusterAvailableDisk | ?{$_.Number -eq "2"} | Add-ClusterDisk; start-sleep 05; Get-ClusterResource | ?{$_.ResourceType -eq "Physical Disk" -and $_.Name -like "Cluster*"}| %{$_.Name = "DC1_Backup_01"}

Thanks Vipin !

Thursday, 01 September 2016 11:12:04 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server | Web_Blog#
Friday, 12 August 2016

SQL 2012 multi-subnet cluster install 

Installing sql server 2012, clustered on windows 2012 with always-on across geographic data centers, these are my recent notes on setting this up:

Always challenging, and I've configured always-on across geographic data centers to single nodes in another data center, but this time we are installing SQL across geographic data centers where SQL Server itself is clustered with-in each data center.  This is to allow for local high-availability with-in each data center.

Here were some recent gotchas i ran into.

Make sure the service account is a full local admin, and has the rights to install .net 3.5.  Installation began and failed as .net 3.5 was not a feature.  It's pretty easy to add this feature on windows 2012, but the service account did not have access to the source media, so ensure your Windows administrator has added this feature.  The actual error doesn't say ".net 3.5 is missing, you get this cryptic message:"

The following error has occurred:

Error while enabling Windows feature : NetFx3, Error Code : -2146498298 , Please try enabling Windows feature : NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows features , see http://go.microsoft.com/fwlink/?linkid=227143

After that, ran the install again, and got a new error:

An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\{login removed}\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\11.0.0.0\user.config line 5)

This error it turns out is caused by the previous bombed install, and is documented here:
https://blogs.msdn.microsoft.com/smondal/2013/07/26/an-error-occurred-creating-the-configuration-section-handler-for-usersettingsmicrosoft-sqlserver-configuration-landingpage-properties-settings/

The fix is basically to delete the temporary and/or cached data, i used the following from a command prompt:   rd /s /q %localappdata%\Microsoft_Corporation

Next issue is the service account didn't have permissions to create the computer object in active directory.  This of course bombs the install, with no "retry", it just throws an error, than you are screwed, even if your active directory administrator adds the correct permission, it won't recover, install fails.

The error messages are:

Cluster network name resource 'SQL Network Name ({virtual name removed})' failed to create its associated computer object in domain '{this will be the AD Domain}' during: Resource online.

The cluster resource 'SQL Server' could not be brought online due to an error bringing the dependency resource 'SQL Network Name ({virtual name removed})' online.  Refer to the Cluster Events in the Failover Cluster Manager for more information.

Now you have to uninstall, there is an option to "remove a node from a cluster", and that is the option you must choose.  Of course this took me a bit to find, because for whatever reason the windows 2012 server do not show the "Remove Programs" in control panel.  The way around this is to go just run appwiz.cpl.

Now that you get the "remove a node from a cluster done", it won't prompt you that a reboot is required, but you will find when you run setup.exe again, it will fail because of a "Pending Restart", so reboot.  After reboot, your shared disk will now be on the other "node", so don't forget to go over there and move it back, i usually reboot the other node to force it and the quourum back, but there are powershell scripts you can use to move them as well.

Now that you got the clean reboot and your shared disk back, and you've removed your several failed attempts, clean up the disk, you may still see a directory created by the install, i usually rename it.

Now do the install again, and all will be good. 

Repeat on the other nodes in the other data center,

Friday, 12 August 2016 15:10:02 (Central Standard Time, UTC-06:00) | Comments [0] | SQL Server#
Monday, 11 July 2016

1st Calf for 2016 !

Monday, 11 July 2016 07:13:52 (Central Standard Time, UTC-06:00) | Comments [0] | Web_Blog#
Search
Popular Posts
Unpatched Vulnerabiltiy discovered ...
Spring Fornicator brewed...
SQL Server Security, not where it n...
Calculate Stock Break Even Price
Useable Space
Recent Posts
Archive
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)
Links
Categories
Admin Login
Sign In
Blogroll