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

CommunityToolbar in Delphi creates problems

Rad Studio Delphi Development
CommunityToolbar in Delphi creates problems The CommunityToolbarXXX.BPL located in your C:\Program Files (x86)\Embarcadero\Studio\XX.0\Bin creates problems for the IDE in the long run.  Apparently you can get an access violation when closing the IDE or if you click on tools\options followed by Ok you can get a script error using Tokyo.  The XXX is the version number located in the BIN folder.  For Berlin it was 240 and for Tokyo it was 250. Embarcadero intended good things to happen using the community toolbar but once again the QA department has failed to capture a bad bug. Something of this nature should never happen during the testing phase when the product is about to be released but lately it has happened alot. To rid the problem all you have to do is…
Read More

Can you trust Blockchain for your company ?

Software Events
Can you trust Blockchain for your company ? Blockchain has grown so fast in the recent year that sometimes your head will spin on what it can do and what it cannot do. Companies must be extremely careful with various consultants or gurus who indicate that using Blockchain technology will be the end all.   Consultants are cropping up with impressive frequency in even the most unlikely startup pitches and while blockchain technology does have genuinely interesting and potentially powerful use cases, it has enormous drawbacks for consumer applications that get little mention in media coverage. As it stands, blockchain is caught between three competing objectives: fast, low-cost, and decentralized. It is not yet possible to make one chain that achieves all three. Fast and decentralized chains will incur a high…
Read More

Embarcadero RAD Studio Tokyo Release 3 is Now Available

Rad Studio Delphi Development
Embarcadero RAD Studio Tokyo Release 3 is Now Available Embarcadero are pleased to announce RAD Studio Tokyo Release 3 for Tokyo (10.2.3) is now available for Delphi, C++Builder, and RAD Studio for customers on Update Subscription. As part of our ongoing commitment to enable developers to quickly and easily build innovative apps, we’ve expanded mobile support for all Professional, Enterprise, and Architect editions. Tokyo Release 3 adds the following features: C++ Enhancements for CMake Command Line Support. C++ Rename Factoring Expanded RAD Server Support for Ext JS Visual Framework Enhancements including HighDPI Support for VCL and Quality Improvements for FireMonkey (FMX) You can view a complete list of features, updates and bug fixes by clicking here While RAD Studio licenses are perpetual, releases are only available to customers with active Update Subscription.…
Read More

Bitcoin is still the wild west and 2017 proves that!

Software Events
Bitcoin is still the wild west and 2017 proves that! Bitcoin seems to be the talk at the moment with the prices soaring higher than ever but 2017 proves that when you invest into something where you really do not understand how it works or whom works for it just shows the risk you are taking.  Bitcoin had numerous companies jumping in during 2017 with the hopes of striking a gold mine.  The initial offerings to the public seemed to be a long shot due to the fact you would hand over funds and needed to wait days before getting something back into your wallet. Following on Bitcoin.com there was a study done where a huge 46 percent of the virtual currencies have already failed.   Out of the 902 vendors…
Read More