Jump to content

jinnantonnixx

Members
  • Posts

    3,659
  • Joined

  • Last visited

Everything posted by jinnantonnixx

  1. You really want good air flow in the loft. If yours has been 'membraned', you might want to consider gizmos called 'lap vents' which are plastic spacers that open up a channel between membranes. I fitted these in my loft and it's definitely helped with loft condensation I was experiencing. It also helps my PIV to get fresh air. Another important consideration with a PIV is making sure you loft hatch is sealed. Otherwise the PIV is pulling air through the loft hatch instead of outside and this will get you nowhere.
  2. For those having problems with SIMS reporting and OneDrive, SIMS appear to be addressing this in the Spring release. https://customer.support-ess.com/csm?sys_kb_id=11beb97f1b39b5d0408d8557d34bcbb5&id=kb_article_view&sysparm_rank=1&sysparm_tsqueryId=3ce92cd81b82f114408d8557d34bcb6a See footnote:
  3. I use a tent peg to open doors. You can engage every sanitation measure under the sun, but if your workplace requires you to open doors using a handle to get to your desk, it's an utter nonsense. You may as well cut out the middleman and shake hands with everyone in your workplace. Here'a a nice little story of how the virus can spread. https://app.getpocket.com/read/2919708911
  4. Waveform 11 Free is now available. https://www.tracktion.com/products/waveform-free
  5. I use Tracktion Waveform 10 for my music production. Tracktion company always release their older version for free. Obviously doesn't have the features of the new flagship software, but very good and 100% free. https://www.tracktion.com/products/t7-daw
  6. Interesting axle mechanism. But I think people forget just how efficient a chain is. https://en.wikipedia.org/wiki/Bicycle_chain#Efficiency Carbon belt drives look interesting, but they either need a frame re-design to install through the chainstays or a joining mechanism. Don't forget they'll jam up with small stones, grit, mud and ice which cannot be compressed and pushed through a regular chain!
  7. My escapade into the world of hub gears was a huge let-down. The seals on the hub were poor and the bearings ground down. Stripping the outer hub case revealed that the grease had turned into a muddy grinding paste and the bearings were totally shot. A huge disappointment. I replace and re-grease the bearings on my simple cup'n'cone bearings once a year and they're still going strong. A little pitted, perhaps, but many years left. As for hubs being "fully sealed and never need maintenance", I seriously doubt that. Smells like marketing to me.
  8. First off, I ride a single-speed to work (with a KMC BMX chain) and a good quality mountain bike with a 1x11 on weekends. I'm a fan of single-speed, very simple and cheap, no gear cables and the chain tends to last longer as you can buy tough BMX chains that maintain a straight chainline. Edit: You can see my single speed adapter here. I still use the same bike daily, I've had it for seven years and do 12 miles a day on it. I estimate it's done over 20,000 miles. That's an indication of the reliability of single-speed. http://www.edugeek.net/forums/general-chat/99718-cycling-work-18.html#post1136273 But a derailleur, when properly adjusted and with good cables, is simple and very reliable. Spend 10 minutes on Youtube learning how to adjust the alignment and the end stoppers and most problems will be resolved quickly with a screwdriver. After a while, you'll need to change the gear cable. A simple job and your gears will run like new. On to hub gears - I was seduced by the apparent simplicity and reliability of the hub system (with back-pedal braking) so I got a wheel with a Shimano Nexus 3 speed. What an utter disaster that was. Putting it simply, it's not built for Welsh weather. Throw in some gritty canal paths, and the thing was ruined in three months. I attempted to change the bearings so I downloaded the schematic to see what was involved. I had to double-check to make sure I hadn't downloaded the schematic for the space shuttle. In a nutshell - forget it. It's a specialist service item, if you can find anyone to service it. The seals were pretty much non existent, the bearings had largely disintegrated even after a short period. I ended up chucking it and getting a regular single speed wheel (dished for a cassette, but with a single-speed adapter). My frame has track-ends so I can adjust the chain tension as it wears. So, not a fan of the Shimano Nexus hubs. I wouldn't consider a (leisure-priced) hub bike for anything other than recreational, dry weather riding. Of course, you can get Rohloff hubs, but they're a different class and price range.
  9. ^^^ What he said. Re-iterating how important it is not to start the machine up. If you boot it up, it will start writing to disk, potentially overwriting your data. Take the disk out and hook it up via a SATA/USB recovery kit/dock. Alternatively make a recovery boot CD/USB and boot with this image to load the tools you need. Some options for a live CD/bootable ISO are listed here. https://www.cgsecurity.org/wiki/TestDisk_Livecd Recuva is worth a shot and is one of the easiest tools to use. When things have gone badly wrong, I've used Testdisk and Photorec to recover photos from a disk (an EXT4 partition which was reformatted to NTFS) with success. https://www.cgsecurity.org/wiki/TestDisk_Download Testdisk can attempt to recover files if the file and directory structure is still available, otherwise Photorec can do a raw scrape of the disk looking for identifiable file-types. Be sure to omit the file-types you're not interested in, or you'll have a lot of sifting.
  10. I *think* (and I might be totally wrong), that the RH is inextricably linked with the air temperature. The key word here is 'relative' in 'relative humidly'. It's defined as the air's ability to absorb moisture. The colder air (at the same RH as the warmer air) has a lower RH as it warms up when it enters the house, thus lowering the house's RH. I think that's the principle, but happy to be corrected. I fitted one a couple of years ago and I'm reasonably convinced that it's helping with dampness in the house.
  11. The second 'kill connection' script above will allow you to disconnect whoever has stolen the single-user connection to the database and save you waiting next time!
  12. From my old notes, usual caveats apply: Problem: Database Stuck in Single-User Mode In SQL Manager, run this query, inserting the correct database name. set deadlock_priority high alter database NAME-OF-DB set offline with rollback immediate; alter database NAME-OF-DB set multi_user with rollback immediate; alter database NAME-OF-DB set online with rollback immediate; If it's being held open by connections, kill the connections with this query: USE master GO DECLARE @kill varchar(8000) = ''; SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), spid) + ';' FROM master..sysprocesses WHERE dbid = db_id('INSERT-NAME-OF-DB-HERE') EXEC(@kill); Then try the first query.
  13. 'realmd' is the easiest way to join AD. Basically install realmd then connect with a single command. It walks you through it. https://www.techrepublic.com/article/how-to-join-a-linux-computer-to-an-active-directory-domain/
  14. $1,499 !!! https://www.theverge.com/2019/11/13/20963294/motorola-razr-new-foldable-smartphone-android-hands-on-flip-phone-photos-video
  15. I'm a keen mountain biker, and one by one my riding partners are getting e-bikes. I tried one of them other weekend (for the life of me I can't remember the brand, but it had top-end Fox shock and integrated battery, and was upwards of five or six grand. 29 on front wheel, 27.5 rear (mullets!)) Totally impressed. Apart from the obvious plus of going up hills quickly, the bike handled better than mine on downhills. The extra weight, which I thought would be disadvantage, lowered the centre of gravity and planted the bike firmly on the trails, on managed bikepark trails and off-piste. There was none of the skittishness you'd experience going fast over rocks. My bike is 'slack' but this had geometry very close to downhill bikes. So, to conclude, I want one.
  16. It certainly looks like you've got things under control. In that case, a db shrink would be a sensible option. As mentioned earlier, it's essentially a defrag operation on the database - db pages are moved to a contiguous group and old page space is deallocated and returned to the filesystem. In this case, you might want to size the database for an estimated sensible working size (e.g. 20 GB) and switch auto-grow to, say 500MB instead of a percentage. (Auto-grow is an emergency measure to prevent your database collapsing, not a management tool!) And don't use auto-shrink Microsoft recommends rebuilding the indexes after a shrink. Some good advice here: https://docs.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-database?view=sql-server-2017#Recommendations
  17. In a stable system, the database is backed up, the log file is truncated and the physical log file(s) are re-used. Truncating marks areas of the log file for re-use. This normally takes place when you backup - the backup procedure truncates the log file at a particular time, allowing the log file up to that point to be re-used. Truncating in itself does not shrink the log file. Shrink is a separate procedure. Doing this outside of a backup procedure breaks the log chain - you won't be able to use the log file for a restore to a point in time if you have a full recovery model. As an aside, the 'log file' usually consists of several virtual log files (VLF) occupying real file(s) on disk. Many VLFs indicate logical fragmentation, which in turn might be fragmented physical files, but this isn't normally an issue. The log files are written sequentially, and are only usually read during rollbacks and system startup. This is why it's possible to have gigantic log files with little noticeable drop in performance - the log file is not read, it's written to in a sequential manner, with little overhead, unless your disk systems start choking up. But if your log files are ever-expanding, it's an indication that the log file is not being truncated. The most common reason for non truncated log files this is that is that the database is not being backed up properly. This is a red flag. Shrinking databases and log files might buy you time, but it won't address the underlying problems. If you have access to SQL Server Manager, this SQL script will list all the databases on your SQL Server instance and when they were last backed up. SET NOCOUNT ON -- print the headers print 'Database backup_finish_date Backup_Type Days Ago Size MB Size GB ' print '---------- ----------------------- ------------ ---------- ------------------------------ -----------' DECLARE @mydatabasename as varchar(100) DECLARE MYCURSOR CURSOR FOR SELECT name from sysdatabases --all dataabases OPEN MYCURSOR FETCH NEXT FROM MYCURSOR INTO @mydatabasename WHILE @@FETCH_STATUS=0 BEGIN SELECT top(1) left(sysdb.name,10) ,bkup.backup_finish_date, case when type='D' then '** FULL **' when type='I' then 'DIFFERENTIAL' when type='L' then 'LOG' end AS [backup Type], (STR(ABS(DATEDIFF(day, GetDate(),(backup_finish_date))))) AS [Days Ago], ceiling(bkup.backup_size /1048576) AS [backup Size MB], cast((bkup.backup_size /1073741824) as decimal (9,2)) AS [backup Size GB] FROM master.dbo.sysdatabases sysdb LEFT OUTER JOIN msdb.dbo.backupset bkup ON bkup.database_name = sysdb.name where type='D' AND sysdb.name = @mydatabasename ORDER BY sysdb.name, bkup.backup_finish_date desc FETCH NEXT FROM MYCURSOR INTO @mydatabasename END CLOSE MYCURSOR DEALLOCATE MYCURSOR I'm unclear about your problem - is your database larger than you'd like, or your log files? This SQL script will display all the files associated with your databases, their physical file size, and how much of that size is actually is use. It would be interesting to see your results. declare @SQL nvarchar(max) select @SQL = COALESCE (@SQL,'') + ' USE ' + QUOTENAME(Name) + ' SELECT ''' + Name + '''AS [DB Name], a.Name AS [Logical Name], a.Filename AS [File Name], CONVERT(Decimal(15,2),ROUND(a.Size/128.000,2)) [Currently Allocated Space (MB)], CONVERT(Decimal(15,2),ROUND(FILEPROPERTY(a.Name,''SpaceUsed'')/128.000,2)) AS [space Used (MB)], CONVERT(Decimal(15,2),ROUND((a.Size-FILEPROPERTY(a.Name,''SpaceUsed''))/128.000,2)) AS [Available Space (MB)], b.log_reuse_wait_desc AS [Log reuse] FROM dbo.sysfiles a (NOLOCK), sys.databases b where b.name = ''' + rtrim(Name) + '''' from sys.databases where state = 0 AND name NOT IN ('master', 'tempdb', 'model', 'msdb') --print @sql exec (@sql)
  18. This is an easy repair for the company, so your first call should be to get a repair under warranty. For sheds out of warranty, it's fairly straightforward to replace individual boards of a shed if you get rot or splits in boards. Get a new board of the same profile as that to be replaced. Unscrew and remove one the vertical corner edging pieces holding the boards in Remove the nails holding the defective board and slide the defective board out Slide the replacement board in (you'll probably need a mallet) and nail the board in place. Replace the edging piece.
  19. The 5G Health Hazard That Isn’t How one scientist and his inaccurate chart led to unwarranted fears of wireless technology. https://www.nytimes.com/2019/07/16/science/5g-cellphones-wireless-cancer.html
  20. Never one to resist a car analogy, it's like a car with jammed brakes and flat tyres. Rather than fix the brakes and tyres, the garage recommends a bigger, more powerful engine to overcome the problems. Joking aside, what's the compatibility level suggested for SIMS these days? I remember this: http://www.edugeek.net/forums/mis-systems/147490-sims-slow-after-upgrade-sql-2014-a.html Another gotcha is the version of SQL in use not licensed to use all the available processors / cores. The giveaway is some of your processors showing as maxed out in Task Manager, while the others are just kicking back and chilling. https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2017?view=sql-server-2017 If you're OK with SQL queries, this will tell you if all processors/cores are available to SQL. You should see 'VISIBLE ONLINE' against your processors. select cpu_id,scheduler_id,is_online, current_tasks_count, status from sys.dm_os_schedulers where status IN ('VISIBLE OFFLINE', 'VISIBLE ONLINE')
  21. Lots of interesting info in that site.
  22. As the late, great Hitch would often quote, "That which can be asserted without evidence can be dismissed without evidence."
  23. Joking aside, sunshine is a demonstrably far more damaging. In this case a hat (tin foil or otherwise) is very good advice.
  24. Be aware that if you want to things with, say, clustering, SIMS makes xpcmdshell calls with the real server name, not the clustered alias. This will cause problems with the DMS.
  25. ^^ This. We've had around 100 SIMS databases spread over three or four servers over the years, but only ever needed one DMS. It's fairly straightforward.
×
×
  • Create New...