I’m a heavy user of iSCSI and frequently advocate its use. For me its been reliable and has saved money. However Steve and I have over the last year worked with to clients where the use of iSCSI has caused an interesting corruption situation. The first was a database corruption repair engagement where the database…
July 9, 2019 is coming faster than we think. That’s the day Microsoft will no longer support SQL 2008 and SQL2008R2. I know there is a thought out there of if its not broken don’t fix it but if your business depends on SQL Server running an unsupported version isn’t a good idea. On top…
Off my normally technical topics but I wanted to share about my new work desk. A Spalted Fiddleback Maple slap with live edges on the front and back the sides are smooth curved edges. I ordered a Uplift Desk frame with dual motors and the Memory Keypad. A friend I now owe a lot to…
I can’t take credit for this one. The credit goes to my friend Randolph. His post is at https://bornsql.ca/s/memory/ . He even has a script that will do it for you. This leaves some ram for Windows to use and I’ve found its a good map to follow for production servers. RAM Installed in System…
I’ve found there is a lot of confusion around the memory support of SQL 2012 Standard. Traditionally we see 2012 at 64GB and 2014 at 128GB and that is correct. However like most things in technology it depends. Yes SQL 2012 Standard has the 64GB Limit but the Limit only applies to the buffer pool.…