Blog

Microsoft SQL Server how to get a table size

SQL Tips
Microsoft SQL Server how to get a table size Sometimes you need to get the size of a particular table located in a database within the Microsoft Server and the following query can provide you that.  You can run this manually or place it in a stored procedure for numerous tables. The SQL code {{CODE1}} Looking at the actual code it displays the name of the table, schema name, record count (rows), size and additional information pertaining to the space used or not used. This is a nifty way to quickly view which tables are large and growing.  This provides analysis on the database giving a SQL admin a method to adjust what could happen in the future. You can also place this in your source code to call the…
Read More

New Apple Mac Books are having serious issues

Hardware Reviews
New Apple Mac Books are having serious issues Apple has been experiencing customers complaining and returning the latest MacBook Pro due to a slew of issues.   The product returns have been numerous and it seems that the issues must be addressed sooner than later. Apple’s new MacBook Pro comes with the brand new Intel Core i9 processor. Heating issues has created the biggest complaint and the rumors coming out are customers storing the MacBooks in the freezer to cool it down.  When a CPU tends to overheat quickly machines will shut down in the middle of work or worst case is that components could become damage. The issue with the MacBook cooling system which couldn’t keep up with the heat i9 processor is generating and causes another issue called “Thermal…
Read More

Microsoft Introduces Surface GO

Hardware Reviews
Microsoft Introduces Surface GO   Microsoft has decided to start selling a cheaper version of the surface pro, called the GO. The device is pretty neat and compact attempting to get into the iPad world.  There are 2 versions prices at $399.00 and $549.00.  The Surface Go is set up to be the small-time Surface tablet you have been waiting for, exhibiting excellent design and the perfect amount of power for a 10-inch 2-in-1 tablet. The cheaper version is 64GB / Intel 4415Y / 4GB RAM and the other device has 128GB / Intel 4415Y / 8GB RAM.    Below are some of the technical details and the accessories such as the keypad is additional purchase. This is a smaller version of the Surface Pro only in that you’re getting a smaller device with…
Read More

Broadcom to buy CA Technologies for $18.9 billion

News Items
California semiconductor maker Broadcom Inc. has agreed to acquire CA Technologies for about $18.9 billion in cash, the companies announced after Wednesday’s market close.  CA, a business software maker formerly known as Computer Associates, moved its headquarters to Manhattan in 2014 but still employs about 1,000 of its 11,000 workers at the site of its former headquarters in Islandia, Long Island New York. The company, co-founded by Charles Wang and Russell Artzt in New York City in the 1970s, was one of Long Island’s iconic corporations, an image tarnished by a $2.2 billion accounting scandal that led to a prison sentence for former chief executive Sanjay Kumar in 2006. Shares of CA closed Wednesday at $37.21, up 0.2 percent, but climbed about 16 percent in after-hours trading to $43.04. CA…
Read More

Toshiba 7200RPM SATA III 6Gb/s 3.5″ OEM Internal Hard Drive Review

Hardware Reviews
Toshiba 7200RPM SATA III 6Gb/s 3.5" OEM Internal Hard Drive Review   The Toshiba P300 Series 3.5 internal hard drive offers the storage capacity you need and the performance you demand. No matter what brand of desktop PC you are using, this reliable hard drive can take your performance and productivity to a whole new level. This drive combines Toshiba time-tested hard drive technology with the right balance of performance, capacity and long-term dependability, making it an excellent choice for your everyday computing needs. The exception to this hard drive is that the warranty is only 90 days standard.  The life time between MTBF or mean time between failures is limited.  Having worked with this hard drive numerous times you can expect a fatal error to occur within 2 and…
Read More