Blog | Jul 21, 2016
Always Encrypted is a feature designed to protect sensitive data, such as credit card numbers or national identification numbers (e.g. US social security numbers), stored in SQL Server databases. Always Encrypted allows clients to encrypt sensitive data inside client applications and never reveal the encryption keys to SQL Server.
Blog | Jun 16, 2016
Every new version of SQL Server Microsoft is getting better and better with new features making it a better choice among other data platforms. With the new installation features installation is more configurable.
Blog | Jan 29, 2016
SQL Server Integration Services (SSIS) uses a variety of connection managers to integrate different data sources into a package allowing for data to be moved around from place to place.
Blog | Dec 24, 2015
Instance File Initialization is a feature that allows SQL server to skip zeroing out of the data file and instantly allocate space by overwriting the new data as and when it comes over the old content.
Blog | Jun 16, 2015
A MySQL DBA has at least once run into a situation where a 'key' small-sized table needs to be restored, and it is a part of a larger combined dump making it a time-consuming task to restore the entire dump in order to get the missing part restored. This blog helps you out of this "dump" situation.
Blog | May 20, 2015
The deadlocks can be rightly called the “show stoppers” for the production environments where the application transactions can get errors without any details being logged in the database systems. For instance, in the lower versions of MySQL (below 5.6), capturing the deadlock information is not available with the MySQL provided log files. This blog will help users/MySQL DBAs to capture such information by making use of a simple shell script and thus providing the important details regarding the deadlock errors.
Blog | May 12, 2015
With a view to leverage the changing hardware landscape, Microsoft has for the first time introduced the concept of In-Memory OLTP, popularly known as Hekaton. This will make OLTP transactions faster than ever.
Blog | Jul 7, 2014
"The report server cannot decrypt the symmetric key that is used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content."
If you have ever encountered the above error flashing across your screen, this blog will help you!
Blog | Jun 20, 2014
Typically, an administrator does not have to specify how much memory should be allocated to the SQL Server, although the option exists and is required in some environments.