sqlsewer.blogspot.com
sqlSewer<b>This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. </b>
http://sqlsewer.blogspot.com/
<b>This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. </b>
http://sqlsewer.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
2.6 seconds
16x16
32x32
64x64
128x128
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
216.58.192.1
LOAD TIME
2.625 sec
SCORE
6.2
sqlSewer | sqlsewer.blogspot.com Reviews
https://sqlsewer.blogspot.com
<b>This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. </b>
sqlSewer: March 2014
http://sqlsewer.blogspot.com/2014_03_01_archive.html
This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. Wednesday, March 26, 2014. Oracle DBA TABLESPACE USAGE METRICS vs DBA DATA FILE with autoextent tablespaces. If you compare tablespace sizes with following two queries:. SQL select * from dba tablespace usage metrics. SQL select x.tablespace name,. Sum(xbytes/1024/1024) "Total Space (Mb)" ,. NVL( sum(x.bytes/1024/1024)-round(y.free,2) , sum(x.bytes/1024/1024) "Used (Mb)",. From dba free space.
sqlSewer: July 2013
http://sqlsewer.blogspot.com/2013_07_01_archive.html
This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. Wednesday, July 10, 2013. Oracle Date and Time comparison. There are several ways to do date and time comparison in Oracle. Here are a couple of examples how to do it (examples are using v$sqlarea view last active time column which data type is DATE) :. 1 Comparison as date with using TO DATE function:. 2 Comparison as string with using TO CHAR function (N. Ote different comparison = ):.
sqlSewer: February 2014
http://sqlsewer.blogspot.com/2014_02_01_archive.html
This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. Friday, February 28, 2014. Oracle ORA-12564 TNS:connection refused ( shared server ). If you get "ORA-12564: TNS:connection refused" errors from your database connections. Reason is typically misspelling in tnsnames.ora file. But if you are using shared server connections these errors can be seen also if you have not enough dispatchers or your dispatcher max session limit is reached. Oracle "...
sqlSewer: June 2013
http://sqlsewer.blogspot.com/2013_06_01_archive.html
This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. Friday, June 28, 2013. Oracle sequence last number check and creation clauses. Sometimes for example when you are updating database you might need to check that sequences last used value does not change. This can be done running following SQL before and after update and then comparing the result sets (this show only given schema sequences):. SQL set pages 120. SQL set lines 120. SQL spool off;.
sqlSewer: June 2014
http://sqlsewer.blogspot.com/2014_06_01_archive.html
This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. Monday, June 16, 2014. ORAchk to check databases (single and RAC). Oracle ORAchk utility will replace RACchk utility and allow you to check also single instance databases. You can also send notification emails throught it. And schedule automatic check via cron jobs. Here is quick guide to install and use ORAchk utility:. 1 Download from My Oracle Support (you'll need MOS account for this):.
TOTAL PAGES IN THIS WEBSITE
19
SQL Services Australia
SQL Services Australia is a SQL Server consulting business operating out of Sydney with a regular presence in Brisbane, the Gold Coast, Canberra and Melbourne. However, we can travel anywhere if the client is willing to cover any travel expenses. We specialise in Microsoft SQL Server databases, specifically SQL Server 2005 and higher. We don't work with earlier versions, and believe you shouldn't either: the older versions simply aren't as good, and we cannot offer the best solutions without the best...
Web hosting provider - Bluehost.com - domain hosting - PHP Hosting - cheap web hosting - Frontpage Hosting E-Commerce Web Hosting Bluehost
Web Hosting - courtesy of www.bluehost.com. There is no content here.
SQL Servings
Sunday, February 10, 2013. My Review of Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012. Originally submitted at O'Reilly. Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012. Training Kit (Exam 70-463): Implementing a Data Warehouse with Microsoft SQL Server 2012. Good resource for 70-463 Exam. From Kenosha, WI. Well-written, Accurate, Helpful examples, Easy to understand. Intermediate, Certification Resource, Student. The con...
SQLSet.com - Database users Communities of Practice • Portal
All times are UTC. Last 6 visited bots. Welcome to SQLSet.com the place to go for all things database. The Forums are grouped for easy navigation, registration is quick and simple. Once registered you can begin posting threads and exchanging ideas. Feedback is always appreciated, this site will only continue to be relevant through your valued contributions. Which open-source database do you use? Total votes : 8. 187 Which Open Source Database do you use? Thu May 29, 2008 1:17 am. Logout [ Google [Bot] ].
SQL Sets Blog
Wednesday, February 3, 2010. Feature in Focus – Annotate Your Data. Even the most well crafted data can sometimes fall short when it comes to. Telling the whole story. That is why SQL Sets. Allows you to add annotations. To your data sets (. Portable Data Set Documents. To clarify a point or point out a particular issue. This proves to be a valuable feature when you need to share this data set with business partners or co-workers for testing, auditing or simple analysis. Here's how it works:. Feature in ...
sqlSewer
This blog contains useful and interesting issues/problems about different sql and nosql databases. Mainly Oracle. Wednesday, August 20, 2014. Good Read for PostgreSQL DBA. PostgreSQL 9 High Availability Cookbook. Good PostgreSQL HA guide. Several good guidelines for designing PostgreSQL databases and HA Clusters. For example recipes for counting storage size, IOPS, cpu, memory etc. Also very specific guides how to use different replications and their monitoring management and HA solutions. You can also s...
SQL Database script generation for Visual Studio 2008 - Home
Project Hosting for Open Source Software. SQL Database script generation for Visual Studio 2008. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Last edited Feb 25, 2008 at 4:14 PM. Mon Feb 25, 2008 at 7:00 AM. Version 8.4.2015.21029.
www.sqlsh.com
SQL Shack - articles about database auditing, server performance, data recovery, and more
Row level security in SQL Server 2016. By Brian Bønk Rueløkke. With the release of SQL Server 2016 comes many great new features. One of these is the implementation of row level security in the database engine. This blogpost will cover the aspects of this new feature including:. Read more ». The DBAs guide to stretch database. By Brian Bønk Rueløkke. One of the new features in SQL Server 2016 and there is a lot is the ability to stretch the on premise databases to an Azure environment. Read more ». We ta...
SQL Share
Friday, November 4, 2011. Opening SQL Server 2000 DTS Package in SQL Server 2008. SQL Server 2000 DTS Designer components are required to edit DTS packages. Install the special Web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExplorerUI). Install SQLServer2005 BC and SQLServer2005 DTS softwares from http:/ www.microsoft.com/download/en/details.aspx? If you are still not able to get it working. Please follow the below steps:. Launching programs and...