Author: Derrick
-
SQL 2008 and 2008R2 End of Life
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…
-
New Desk
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…
-
Max SQL Memory Recommendations
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…
-
SQL 2012 Standard Memory Limits
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.…
-
Printers and Old Memories
I was cleaning out my home office and came across something I’ve kept since my first tech job back in 2003. I was fixing a badge printing machine and after lots of tinkering out spit a Windows 98 test page PRINTED ON A CARD. I wonder if the card printer is still in use. The…
-
Rodents and Servers
—
by
Recent I was dusting off a lightly used Dell R720 for a client when to my horror I discovered a home for a mouse. This teaches me two things. One don’t leave a server in a storeroom. Two don’t ever take a card out and not replace the slot. This rodent squeezed his way in…
-
There are four lights!
I’m not sure what is it with tech manufacturers these days. They have to make the LED’s brighter and brighter. Below you will see four switches. The bottom two Cisco units have resonable brightness LED’s but Dell EMC went over the top with the S4100 series. They want us to know those fans are working.…
-
Microsoft Word Top Margin is Missing
—
by
I just had this issue last week and it took me much longer than I care to admit to figure it out so I figured I’d make a Blog Post about it. As you can see from my screenshot below the Top Margin is missing. To fix the problem you have to mouse over to…
-
DANGER!!! REPAIR_ALLOW_DATA_LOSS
Danger Do NOT RUN DBCC CheckDB REPAIR_ALLOW_DATA_LOSS DBCC CHECKDB (‘DATABASENAME’, REPAIR_ALLOW_DATA_LOSS); NEVER run the command above on a production database. As it says you will most likely loose data. That syntax commands SQL to throw out any corrupted 8K Page. There can be lots of data in that page and there may be multiple pages…
-
Update, Please…
I recently read a blog post on my friend Randolph West blog about Windows Updates. Please read what he said here. I’d like to take a minute and both echo what Randolph said and expand on it. Keeping your software up to date is important. I’ve heard all the excuses and even used them myself.…
-
DBCC CHECKDB
DBCC CHECK DB Steve and I recently repaired SQL Database Corruption for a customer who wasn’t running DBCC Check DB on a regular basis. Please don’t do this. DBCC Check DB both needs to be run on a regular basis AND you need to be monitoring the results. It’s so important to know about corruption…
-
Backups
Today I want to talk about backups. I’m not going to get into all the details about RPO and RTO but just the overall 50,000 foot level sentence that can help you make decisions about what you need. Back in High School I used to work on older Diesel powered Mercedes Benz for my best…