SQL Database Learning Resources
SQL Database learning resources provided by industry leaders. Learn how to design, build and query SQL databases.
Most Popular This Month
OUI-10150:Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in component Oracle Database 11g 11.2.0.1.0Problem : Add a Component to an Oracle 11g rel2 Home get the following error INFO: *** Error Dialog: OUI-10150:Error: A runtime exception occurred while setting s_dlgCfgNamingLabelSIDnull in componen... [read more] 
ORA-01455: converting column overflows integer datatypeORA-01455: converting column overflows integer datatype Error: Export of 11g Rel2 using 10g Client will have the above error message at exporting triggers. The export failed with the following detaile... [read more]
AWR Report Missing Statistic Data – WARNING: Since the DB Time is less than one secondProblem description: In AWR report in 11g have found the following warning message in the Top and All Statistics Informations are missing "WARNING: Since the DB Time is less than one second, ther... [read more]
Announcing SQL Server 2012 Express LocalDB RC0LocalDB RC0 is Here, with a Brand New MSI! Release Candidate 0 for SQL Server 2012 has just shipped, bringing a new update to SQL Server Express LocalDB! As announced here LocalDB is a version of SQL... [read more]
INF : Restore Database UI fails with error: "Length cannot be less than zero. Parameter name: length"Recently we came across a situation where one of the customer was trying to restore a Database backup using SSMS and while going to Options tab UI failed with the error: "Length cannot be ... [read more]
Policy Based ManagementCheck our video blog, and get answers to your queries related to "Policy Based Management" in SQL server. This feature is helpful to ensure compliance at SQL server end. This blog will cover: What is ... [read more]
SQL Server 2008 R2 Express Database Size Limit Increased to 10GBGreat news for SQL Server Express users today! We increased the maximum database size in SQL Server 2008 R2 Express from 4GB to 10GB. You can try it out today – just go to SQL... [read more]
SQL Server could not create a subscription for Subscriber 'ServernameInstanceName'.The value for the @sync_method parameter is not validRecently we worked on a support case where creation of a Subscription was failing with the following error:- TITLE: New Subscription Wizard ------------------------------ SQL Server could not create a... [read more]
SQL Server Configuration Manager - Cannot connect to WMI provider - Invalid class [0x80041010]When I am trying to connect to my SQL Server 2008 box using SQL Server Configuration Manager today, the following error dialog pops up… Cannot connect to WMI provider. You do not have permission ... [read more]
Disable Numa in grub.confIf you notice in Oracle Linux 5.6, Oracle starts to disable NUMA at boot time as shown in the following grub.conf file: [root@rac561 ~]# cat /etc/grub.conf # grub.conf generated by anaconda # # Note t... [read more] |
Recent News & Resources
SQL Server Replication
Queries on SQL Server Replication? Check out our blog to get'em answered , that will give you an overview of the “Replication in SQL server”. Highlights of the blog:- What is... [read more]
How It Works: XEvent Action vs Field data values.
I have seen several traces and questions relating to the output of the XEvent so I thought I would try to explain them a bit in an effort to reduce confusion. Terms Field == E... [read more]
AlwaysON - HADRON Learning Series: Automated Failover Behaviors (Denali - Logging History Information, FCI and Default Health Capture, sp_server_diagnostics)
Quite an encompassing title I will agree but the features all work together to build a really nice product. I had this tucked away during beta and thought it would be helpful to ... [read more]
SetFileIoOverlappedRange Can Lead to Unexpected Behavior for SQL Server 2008 R2 or SQL Server 2012 (Denali)
You should be aware the Windows bug with API = SetFileIoOverlappedRange. This is used by SQL Server (2008 R2 and SQL 2012) only when Locked Pages has been enabled and is in use b... [read more]
TIMESTAMP data types and CURRENT_TIMESTAMP attribute
In the yet to be released MySQL 5.6.6 DMR, there has been a change to the restriction of just one TIMESTAMP column with the DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAM... [read more]
Intro to Debugging a Memory Dump
I was discussing debugging with some folk internally that didn't really have much exposure to it, but wanted to learn. I considered the items pretty basic and didn't really dive ... [read more]
An interesting find about Temp tables in SQL Server
I ran into a very interesting issue with temp tables recently, when working on a case. The issue description goes something like this. We have an application preparing some SQL sta... [read more]
INF: AlwaysON - The secondary database doesn't come automatically when the primary instance of SQL Server goes down
In this blog we would discuss about behavior of AlwaysON where the secondary database doesn't come automatically when the primary instance goes down. The secondary database goes in... [read more]
INF: Limitations for SQL Agent when you have many Jobs running in SQL simultaneously
Recently I have had a customer complaining that when he is adding more subscriptions to his publication, distribution agent job for the newly added subscriptions would not start. ... [read more]
Redirect to tools specific blogs
This blog is no longer active. We believe resources are better spent at targeting our tool specific blogs: For Oracle JDeveloper interest, visit https://blogs.oracle... [read more]
SQL_MODE and storage engines
I was again reminded why setting SQL_MODE is so important in any new MySQL environment. While performing benchmark tests on parallel backup features with a com... [read more]
IOUC Leaders Summit Presentation
At the recent leaders summit of world leaders in Oracle, Java and MySQL user communities I gave a presentation on Why Upgrade to MySQL 5.5 This is a more high l... [read more]
SQL Server 2012 - True Black Box Recorder
This would be a perfect time to post a blog talking about the new SQL Server 2012 features. However, I am going to leave that activity to the marketing folk... [read more]
Modern platforms: flash, disk, log-structured, update-in-place
Someone who knows a lot about storage asked me whether we can spend IOPS to improve compression.When deploying a pure-flash server I want a database engine that... [read more]
Getting the best performance out of MySQL Cluster – White Paper
There are a number of resources available to help get you up and running with MySQL Cluster so that you can start experimenting – including the quick start gu... [read more]