IBM Bluemix in Germany, includes dashDB and Cloudant
IBM Bluemix in Germany, includes dashDB and Cloudant
Read the complete post at blog.4loeser.net/…/ibm-bluemix-in-germany-includes-dashdb.html...
TDE: Looking inside your database and backups
TDE: Looking inside your database and backups
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file too. I fancied looking inside the MDF and a backup of my database before enabl...
#0403 – SQL Server – CAST/CONVERT to string – Pad zeroes or spaces to an integer
#0403 – SQL Server – CAST/CONVERT to string – Pad zeroes or spaces to an integer
Padding zeroes to an integer is often required during data migrations and integrations. Here is the approach I use in such data conversions. Read the complete post at feedproxy.google.com/…/...
SQL SERVER – sp_readrequest – Long Running Process
SQL SERVER – sp_readrequest – Long Running Process
Just another day while doing performance tuning engagement, Senior DBA of the organization and I both noticed that one of the SP sp_readrequest is continuously listed as long running SP. Well, the go...
Create Backup On Demand On the Cloud
Create Backup On Demand On the Cloud
In This Post i will show how to create backup for Dbaas Open the Oracle Database Cloud Service console. Click the database deployment for which you want to create a backup. Click the Administration ...
How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114
How to Find How Many Rows Each Query Returned Along with Execution Plan? – Interview Question of the Week #114
Question: How to Find How Many Rows Each Query Returned Along with Execution Plan? Answer:During my performance tuning consultancy engagement, this is one of the most asked questions. Everyone wants ...
SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request
SQL SERVER – Microsoft.SqlServer.Management.Sdk. Sfc.EnumeratorException: Failed to Retrieve Data for This Request
If you work with a product for a long time, you would start loving it. I have worked with many other RDBMS, but my love to SQL Server will never die. The amount of information available in logs is ver...
Toad Explain Plan More Advanced Options
Toad Explain Plan More Advanced Options
Hi, I have used this option to show SQL bind variable content for a while, I want to show you how I avoid running SQL Trace with this Toad Explain Plan feature. Toad has also made it very easy to run ...
Migrating from Oracle to MySQL
Migrating from Oracle to MySQL
With the loss of the Oracle Standard Edition One license, and the free Oracle Express Edition database stuck at the old 11g Release 2 from 2014, many smaller projects are considering whether MySQL mig...
Microsoft Brings New Capabilities to HDInsight and DocumentDB
Microsoft Brings New Capabilities to HDInsight and DocumentDB
Microsoft is headed to San Jose this week where they will be announcing new features for HDInsight and DocumentDB at Strata Hadoop + World. Additionally, the company is also announcing a new preview f...
SQL SERVER – Availability Group Missing or Deleted Automatically?
SQL SERVER – Availability Group Missing or Deleted Automatically?
As a part of my passion, I try to help people in fixing simple issues and explain the behavior by looking at logs. Here is an email from my friend about Availability Group Missing or Deleted Automatic...
Going Deep on Stats
Going Deep on Stats
Postgres includes lots of monitoring tools that allow you to see what is happening, but there are a few settings that really go into detail, e.g. log_statement_stats: SET client_min_messages = log; S...
- Go to the previous page
- 1
- …
- 89
- 90
- 91
- 92
- 93
- 94
- 95
- …
- 149
- Go to the next page